hodgesrm

44 ms·

721.
by hodgesrm 4y ago
The article left out one of the most fundamantal topics of databases--clustering of data in storage is everything. Examples: 1. If you store data in rows it's quite fast to insert/update/delete individual rows. Moreover, it&#
722.
by hodgesrm 4y ago
SERIALIZABLE is ridiculously slow if you have any level of concurrency in your app. READ COMMITTED is a reasonable default in general. The behavior GP is describing sounds like an out and out bug. Dirty reads incidentally weren't suppo
723.
by hodgesrm 4y ago
I disagree. I'm a big fan of Chandler and his monumental creation, Philip Marlowe. Deckard is quite a different character. Just comparing the two, Deckard's role is to be a witness to Batty's dawning humanity (as well as Rach
724.
by hodgesrm 4y ago
> Beautiful opening, great story in the middle, utterly incomprehensible ending. I'm really glad to read this. Kubrick really lost me at the end. I thought I was just not getting it. The first 2/3s though are as good as any f
725.
by hodgesrm 4y ago
Good quote. For me what distinguishes the film and makes it better than the original story is exactly the elevation of the replicants into fully sentient beings. Batty started out as a grifter in the original and became the center of the st
726.
Yann LeCun has a bold new vision for the future of AI(technologyreview.com)
3 points by hodgesrm 4y ago|0 comments
727.
by hodgesrm 4y ago
It's a little more nuanced than that. Developing home nuclear reactors is an example where the approach might not benefit society at large. Edit: Comment is off-topic but I've heard this phrase so many times it's triggering.
728.
by hodgesrm 4y ago
Not to mention big compression and big vectorization. I'm right this minute messing around with a trillion+ row dataset in ClickHouse. It runs fine on a VM with 36 vCPUs and 1.8Tb of storage. (AWS c5.9xlarge instance type, EBS GP2 stor
729.
by hodgesrm 4y ago
That's the current term of art. It used to be "lifestyle business," which has a more passive-aggressive feel to it.
730.
by hodgesrm 4y ago
If you had to pick a single title to summarize the Hacker News ethos, this would be it.
731.
by hodgesrm 4y ago
My safety tip based on decades of cycling: think of safety as a game of percentages, like baseball. Stopping in the blind spot of a car is a low percentage maneuver—do it enough times and you’ll get hit. I try to ride in a way that reduces
732.
by hodgesrm 4y ago
What would you propose as an alternative? Many such roads are the only route available.
733.
by hodgesrm 4y ago
Exactly.
734.
by hodgesrm 4y ago
Drizzle failed because it didn't have a use case that made it clearly better than MySQL. It's hard to displace an incumbent DBMS, because they take a long to time to mature internally as well as develop a productive ecosystem.
735.
by hodgesrm 4y ago
I appreciate your benchmark and was interested to learn about how QuestDB processes TSBS queries efficiently. I work extensively with ClickHouse and it's always enlightening to learn about how other databases achieve high performance.
736.
by hodgesrm 4y ago
Agree. Or just load test on your own software, publish how you did it, and let other vendors respond for themselves.
737.
by hodgesrm 4y ago
I'm not sure which incident you are referring to, but Pepys was not a great human being in many ways. The fact that he revealed himself so deeply makes the diaries quite remarkable.
738.
by hodgesrm 4y ago
That article was a good response.
739.
by hodgesrm 4y ago
> If your formula is sufficiently wrong, which is the rule not the exception, you can’t make up for it with perseverance. It's not a simple decision, at least based on my personal experience. If you have a good team, a good market,
740.
by hodgesrm 4y ago
Hi, You don't mention how much data you have, what the arrival rate is, and how long you would keep it. You did mention you are familiar with ClickHouse. For datasets under a few billion rows you don't need any special materials
741.
by hodgesrm 4y ago
Plus he knew pretty much everyone at court from King Charles II down. You feel as if you also know them all personally after reading Pepys for a while.
742.
by hodgesrm 4y ago
Funny, the committers were at an Amsterdam meetup last night and we were talking about ClickHouse Keeper. I don't think that's very high up the list of priorities for them right now. The focus is more on ensuring it is bombproof--
743.
by hodgesrm 4y ago
Right. We put a lot more effort into ensuring people get on-boarded and properly integrated. That's the hard part (on both sides) to making the distributed company model work. I don't think you can ever do enough on that. We owe a
744.
by hodgesrm 4y ago
(Sorry for the delay, on the road.) We're a US C-Corp. Our founders are spread out over the US and Europe. I'm not one of them myself, but rather joined later. The flip from UK to US took 2 months end-to-end and cost close to $100
745.
by hodgesrm 4y ago
ClickHouse chose an API compatible rewrite because it allowed the project to banish issues like Zookeeper transaction ID rollover and eliminate an external dependency while allowing a gentle migration to the new "ClickHouse Keeper&quot
746.
by hodgesrm 4y ago
But your point that it's out of date is definitely right.
747.
by hodgesrm 4y ago
Delaware, though we originally incorporated in the UK and then flipped as a condition of receiving investment. (Thanks Accel people!) The flip was the most complicated thing we've done--accounting, lawyers on both sides to avoid the dr
748.
by hodgesrm 4y ago
We are US incorporated with staff in 14 countries. We use contracts for non-US staff and recently implemented letsdeel. So it looks good. You do not need a legal entity in most countries and in fact there can be significant disadvantages. T
749.
by hodgesrm 4y ago
> The problem isn't that there's a recession coming, the problem is that there hasn't been one for a long long time. That's a bon mot if there ever was one.
750.
by hodgesrm 4y ago
Actually that table syntax partitions by month, which is a little non-intuitve. In modern ClickHouse SQL it would look like the following. CREATE TABLE tsbs_modern ( created_date Date DEFAULT today(), created_at Date

More ›