hodgesrm

39 ms·

571.
by hodgesrm 4y ago
Use an analytic database with column storage. Even on modest hardware they can insert millions of rows per second in a variety and query hundreds of millions per second. They are ideal for exploring data. MySQL by contrast is ideal for tran
572.
My Watch Thinks I'm Dead(nytimes.com)
2 points by hodgesrm 4y ago|1 comments
573.
by hodgesrm 4y ago
Hagiography is literally writing about the lives of saints: a sturdy addition to any writer's vocabulary. To avoid overuse there are also fine synonyms like panegyric (defined as "elaborate praise" in the OED) and encomium.
574.
by hodgesrm 4y ago
Shades of Cyrano de Bergerac. This is a flirtbot! Maybe somebody else already had the idea: the DNS for cyrano.ai is aleady taken.
575.
by hodgesrm 4y ago
> It resulted in a strategy where some teams have hired puffer people with the only purpose to have poor performance ratings assigned to them and let them go when the demand for such inevitably rose for such from HR. Those people are kno
576.
by hodgesrm 4y ago
You really notice the difference when you go to a country like Germany, which uses a lot more trucks to haul freight. The rail percentage is about 19% currently. [0] The Autobahn is packed with trucks. The percentage of rail traffic is lowe
577.
by hodgesrm 4y ago
Plausible is a good solution and pay a lot of attention to privacy issues. It's the other product I would look at along with PostHog. The analytics are based on ClickHouse and are very fast. disclaimer: My company Altinity has worked w
578.
by hodgesrm 4y ago
+1. My company hosts ClickHouse data for PostHog installations. The users I've talked to are very happy with it. Disclaimer: We are a partner with PostHog.
579.
by hodgesrm 4y ago
I'm all for disclosure and do so myself when commenting on things related to my company. But...I'm curious what level of disclosure you feel is required beyond saying you work at the company? Personally I don't want to read a
580.
by hodgesrm 4y ago
It looks as if there's a business opportunity to develop a modern Voight-Kampff test to detect AIs. [0] Anybody doing this now? https://nautil.us/the-science-behind-blade-runners-voight_ka...
581.
by hodgesrm 4y ago
The referenced presentation is an unusually good talk on optimization in DBMS. I recommend it to anyone interested in the topic. Among other tricks ClickHouse uses adaptive optimization to switch approaches during query execution. [0] It&#x
582.
by hodgesrm 4y ago
Maybe she's doing time somewhere? Just out of curiosity what would be the best way to update your LinkedIn in this case? "On sabbatical" does not seem to quite cut it.
583.
by hodgesrm 4y ago
> Once you put an accountant or MBA in charge of any company the company is dead. You can’t cost manage your way to growth. What about all the techie founders who have run companies into the ground? Most startups I know are run by techie
584.
by hodgesrm 4y ago
Slootman is an excellent manager. I suspect he could run just about any type of business.
585.
by hodgesrm 4y ago
You mentioned materialized views. How did you use them and what were the specific benefits? I agree they are one of the more amazing features in ClickHouse but you can always learn more about how to use them. Meanwhile Thanks for the post a
586.
by hodgesrm 4y ago
This. My laptop runs Windows (for non-programming reasons). It would feel like a prison except that WSL is really good--far more convenient than messing around with MacOS workarounds like brew. If you can't run Linux directly, Windows
587.
by hodgesrm 4y ago
> And even if he was, doctors push pills for commission, so don’t trust them too much either. Can you cite sources? Otherwise please don't post such claims. It's unworthy of Hacker News.
588.
by hodgesrm 4y ago
ClickHouse at least supports local joins quite well. Perhaps another way to put it is that BigQuery, Redshift, and Snowflake are not optimized for real-time response on large, wide tables. ClickHouse has features that allow it to pack multi
589.
by hodgesrm 4y ago
He would probably just make a cool lecture out of your mistake. ;)
590.
by hodgesrm 4y ago
Thanks for the shoutout to the Altinity Operator! I couldn't tell if you meant ClickHouse the company or ClickHouse the database in your comment. If the latter there are multiple hosted ClickHouse services--by my count at least 12 thou
591.
by hodgesrm 4y ago
Is this a usability problem or just an implementation choice? 8443 is the default port for secure HTTP traffic on ClickHouse and has been for many years. This particular endpoint uses that port so that applications using the Python clickhou
592.
by hodgesrm 4y ago
> @hodgesrm it's simply a copy of the Playground I've created in 2020. We've never said differently. I was one of the people who congratulated on you the dataset when you first introduced it and also authored an early arti
593.
by hodgesrm 4y ago
The GitHub dataset is a lot of fun. In addition to the ClickHouse Inc version mentioned in the article there's also a current version on Altinity.Cloud at the following URL: https://github.demo.trial.altinity.cloud:8443&#x2F
594.
by hodgesrm 4y ago
I think about this every time I fly coach, which is 99.9% of the time. It's also great if you are in a submarine or do electrical work in enclosed spaces.
595.
by hodgesrm 4y ago
Cool! What were the others?
596.
by hodgesrm 4y ago
Wow. The complacency of election officials and many advocates for election reform is stunning. Ideas like ranked choices are worse than worthless if you don't implement them correctly. It undermines faith in the entire voting process.
597.
by hodgesrm 4y ago
> What was the first database you used back in the day? Model 204 with COBOL. [0] M204 was a pre-relational database that used inverted indexes to locate rows. It sparked a life-long fascination with data. [0] https://en.wikip
598.
by hodgesrm 4y ago
That's completely true. But my point is that comparing them to Nazis is at best misleading and at worst actively harmful if you want to reason about what happened then and what's happening. Perhaps it's more useful to look at
599.
by hodgesrm 4y ago
> Now with internet, it is a process waiting to be disrupted. I would say it is already over due. Why is everything in this space about disruption? Doctors use the Internet all the time. One of my kids is a resident in internal medicine
600.
by hodgesrm 4y ago
It's probably enough to mute the worst offenders. I found that muting @ElonMusk made Twitter a lot more usable.

More ›