Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
hodgesrm
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
71 ms
·
901.
▲
by
hodgesrm
5y ago
It's up for me. I'm coming off Sonic at 50.0.0.0/15.
902.
▲
Hiking America’s three longest trails in less than a year. What could go wrong?
(latimes.com)
124 points
by
hodgesrm
5y ago
|
84 comments
903.
▲
by
hodgesrm
5y ago
This feels like an origin story for me. I borrowed Fear and Loathing in Las Vegas from the library on a sleepy Air Force base in Texas. It still amazes me they had the book: the librarian was either celebrating the literature of ex-Air Forc
904.
▲
by
hodgesrm
5y ago
Every extra kilo of fuel means one kilo less of cargo. I would guess that the shorter hops require 45K kilos less fuel so you can load more cargo instead, thereby increasing efficiency.
905.
▲
by
hodgesrm
5y ago
> I'm leaving apple for linux as we speak for two reasons, privacy and they can't help but mess with shit every time they release an update. "Mess with shit" was what drove me to Linux by around 2015. It seemed like e
906.
▲
by
hodgesrm
5y ago
Altinity.Cloud accepts credit card payments. Disclaimer: I work at Altinity.
907.
▲
by
hodgesrm
5y ago
I think you meant a Casual Mass of critical cyclists. :)
908.
▲
by
hodgesrm
5y ago
> Cloud services trade performance woes for budget surprises. I'm not sure why you think this is a trade-off. In general cloud services automate operations. Whether they are faster is unrelated. Many are not--services that use objec
909.
▲
by
hodgesrm
5y ago
My company runs a cloud service for ClickHouse. We've spent a lot of time thinking about pricing. In the end we arrived at (VMs + allocated storage) * management uplift + support fee. It's not a newfangled serverless pricing model
910.
▲
by
hodgesrm
5y ago
"Snowflake" is a type of analytic schema. [0] It's a good name for the product for anyone familiar with data warehouses. [0] https://en.wikipedia.org/wiki/Snowflake_schema
911.
▲
by
hodgesrm
5y ago
The uniqueness of Snowflake comes from decoupled compute and storage with data lying at rest on object storage. This was very innovative at the time. The approach is being copied by more or less every competitor in the analytic space so ove
912.
▲
by
hodgesrm
5y ago
Same here. I've had surgeries for cataracts and detached retina (2 of each). Eye surgery has outstanding outcomes and involves virtually no physical discomfort. I'm profoundly grateful for modern medical technology, as I would oth
913.
▲
by
hodgesrm
5y ago
Thanks, I would have missed that completely without your comment.
914.
▲
by
hodgesrm
5y ago
> On the other hand, a project that rarely updates information, such as an analytics application where data doesn't change after it has been collected, will benefit more from a nonrelational database. SQL data warehouses are relatio
915.
▲
by
hodgesrm
5y ago
Well, to begin with, the the United States has never been completely democratic even at the best of times. If you run the clock back 50 years+ full rights were denied to many minorities. This was not microaggressions. It was full out refusa
916.
▲
by
hodgesrm
5y ago
> Regardless of your stance on the issue, does anyone actually believe that three "voting rights" professors will give a politically unbiased testimony in 2021? Why is this question even relevant in a court case? There's n
917.
▲
by
hodgesrm
5y ago
Gender in German is an incredible pain. There are rules for about 50% of the words, e.g., a word that ends in "ung" like Beleuchtung is always feminine. The other 50%? It's a guess. After a while I concluded it must be a defe
918.
▲
by
hodgesrm
5y ago
"Near shore" == "Canada"
919.
▲
by
hodgesrm
5y ago
Nice article. Materialized columns in ClickHouse are a bit like indexes in the sense that they give a faster path to the answer by reading less data. ClickHouse devs are adding a feature called semi-structured data that will optimize stored
920.
▲
by
hodgesrm
5y ago
Cube.js fills a need I've heard many times in ClickHouse work--how to build a clean data delivery API that mediates application access to analytic databases. There's a basic impedenance mismatch between highly concurrent apps tha
921.
▲
by
hodgesrm
5y ago
Dune seems more like the middle ages in space, specifically the period of explosive Muslim expansion starting in Medina in the 630s. The empire he describes reminds me of the Umayyad Caliphate with a distant Emperor (Caliph) ruling over fie
922.
▲
by
hodgesrm
5y ago
Hi Ajay! Thanks for the thoughtful response and email. I would love a direct meeting and will contact you shortly. I don't mean to gloss over ClickHouse imperfections. There are lots of them. For my money the biggest is that it still t
923.
▲
by
hodgesrm
5y ago
You are right about transactional differences between ClickHouse and PostgreSQL but you are comparing apples and oranges. ClickHouse prioritizes speed, efficiency, and scale over consistency. These are reasonable choices, especially in the
924.
▲
by
hodgesrm
5y ago
Is your comment on ClickHouse and DBT based on using the DBT ClickHouse plugin? [0] If so I would be very interested in understanding what you or others see as deficiencies. [0] https://github.com/silentsokolov/dbt-clic
925.
▲
by
hodgesrm
5y ago
Don't use helm. The ClickHouse Kubernetes Operator is the way to go. Here's the project: https://github.com/Altinity/clickhouse-operator This is generally true for most databases these days. Use an operator
926.
▲
by
hodgesrm
5y ago
Go to one of the several public ClickHouse endpoints and run this query: -- Elastic vs CH in a single table. SELECT toYear(created_at) Year, uniqIf(creator_user_login, repo_name in ('elastic/elasticsearch'))
927.
▲
by
hodgesrm
5y ago
ClickHouse now has more unique contributors with merged PRs on an annual basis. The lines crossed early this year, or even late last year.
928.
▲
by
hodgesrm
5y ago
I got an HP Laserjet in the late 80s for a computer center I ran at the University of Washington in Seattle. It was the best piece of hardware I've ever purchased. The clincher was the care with which they packed it and the simple inst
929.
▲
by
hodgesrm
5y ago
Newegg reviews were pretty good--they steered me away from a lot of noisy gear when building servers. That kind of feedback does not exist in the specs.
930.
▲
by
hodgesrm
5y ago
You could tell if you screwed something up performance-wise, because the tape would have to reposition and reread if your program was not ready to read blocks coming of the device. With IBM 6250 BPI drives this meant it would overshoot mass
More ›