HackerTrans
TopNewTrendsCommentsPastAskShowJobs

vogtb

no profile record

Submissions

Optimizing 100B ClickHouse Events

replo.computer
2 points·by vogtb·10 เดือนที่ผ่านมา·0 comments

comments

vogtb
·4 เดือนที่ผ่านมา·discuss
I lived in Chicago for about a decade, and around 2017 to 2023 I set a goal of biking to every one of the 76(?) neighborhoods. I made it to about 63. There are definitely neighborhoods rougher than others. But tbh every neighborhood has good food, and, you know, normal people living there. Like, in Garfield park I remember buying ribs from a guy that was just sorta cooking them outa the back of his truck. They were terrific. Pilsen has great Mexican food, and Devon has nuts Indian food (Ghareeb Narwaz is by far my favorite). Yeah, in some neighborhoods, on a couple of blocks there are guys out on the corner selling. But no one's bothering anyone. There's nowhere you can't go on a Saturday at 1PM. Basically, what I'm saying is, the Chicago you see on the news isn't the one I live in. So, you know, keep your wits about you, take care, but I think everyone in Chicago should go to a random neighborhood and get some food.
vogtb
·4 เดือนที่ผ่านมา·discuss
This reminds me of another artist that did an isometric map of the city. I bought one and it hangs on my office wall. https://www.etsy.com/listing/1673296980/map-of-chicago-loop-...

Always fun to have someone over who knows the city. We'll spend 20 minutes pointing to all the buildings we've worked in, places we've eaten, or where The Bear or The Fugitive were filmed.
vogtb
·5 เดือนที่ผ่านมา·discuss
Handy rocks. I recently had minor surgery on my shoulder that required me to be in a sling for about a month, and I thought I'd give Handy a try for dictating notes and so on. It works phenomenally well for most text-to-speech use cases - homonyms included.
vogtb
·5 เดือนที่ผ่านมา·discuss
Same. I thought his portrayal of anarcho-primitivism was really cool and interesting as well. Also, other people called it boring but one of my favorite parts was in Blue Mars as they hammer out the Martian constitution.
vogtb
·6 เดือนที่ผ่านมา·discuss
Neat! Having literally everything backed by object storage is The Dream, so this makes a lot of sense. So to compare this to the options that are available (that aren't Kafka or Redis streams) I can imagine you could take these items that you're writing to a stream, batch them and write them into some sort of S3-backed data lake. Something like Delta Lake. And then query them using I don't know DuckDB or whatever your OLAP SQL thing is. Or you could what develop your own S3 schema that that's just saving these items to batched objects as they come in. So then part what S2 is saving you from is having to write your own acknowledgement system/protocol for batching these items, and the corresponding read ("consume") queries? Cool!
vogtb
·7 เดือนที่ผ่านมา·discuss
The line "How could I forget that I had given her an extra key?" comes to mind. Maybe someone left an API key laying around somewhere? Although I could be giving the hackers too much credit...
vogtb
·7 เดือนที่ผ่านมา·discuss
Val.town seems to be serverless, where as this is explicitly a server. One is really a subset of the other though, so I suppose if you're deploying ts functions to a service/server, and your execution costs match up with the tiers here, exe.dev could be cheaper.
vogtb
·7 เดือนที่ผ่านมา·discuss
Oh, we're doing Fly again? Cool! I don't mean that sarcastically -- making it dead simple to get a VM at a domain or IP in a few seconds is good and useful. We should keep trying this idea, because every time it gets easier.

On a side note, a lot of people in this thread are doing a sort of "I don't get it, your website sucks" but it's like, come on dude! Just read the site! It takes less time to read the pricing, docs, and FAQ than it does to post about how you don't get it.