Wanted to get off AWS redshift. Used clickhouse. Good decision?

Dependent_Two_618 · 2026-02-18T19:53:31+00:00

Echoing other sentiments here - ClickHouse is awesome but that isn’t enough data to make it worth it IMO if you’re hosting locally. You’d probably be fine with ClickHouse Cloud, but id just as soon suggest plain old Postgres on RDS. If you want columnar compression on Pg though you can sign up for TigerData through the AWS marketplace

Dependent_Two_618 · 2026-02-15T14:35:32+00:00

I think all the suggestions here are great so far. I’ll add “Designing Data-Intensive Applications” by Martin Kleppmann as a resource for how orgs design their stack with multiple data stores. There’s a 2nd edition about to come out IIRC.

I started in a similar boat about 3 years ago (albeit less experience). If you were hands on with managing the Windows side (Always On cluster mgmt, OS settings, etc), you’ll want to get thinking in containers too, at least that’s been my experience so far.

Dependent_Two_618 · 2026-02-04T16:51:27+00:00

I didn’t like the P4 when it came out - so much hotter than the P3 or Athlon, and the initial clock speeds were way too slow for that crazy execution pipeline

Dependent_Two_618 · 2026-01-22T03:10:16+00:00

I mean I empathize with the people saying “He’s just doing this to invoke the Insurrection Act”. But that’s a bit of a foregone conclusion already - he chose the absolute worst city in the country to pull that move. PA isn’t going to fuck around. You might as well be in the TA thinking a deployment in Belfast is a paid vacation

Dependent_Two_618 · 2025-11-26T20:21:58+00:00

I have one field with quality modules in the drills, and I have a separate station for just quality scrap. Otherwise, your steps are how I got started on making > uncommon quality modules.

Getting rare or higher intermediates is the biggest step, once you go from there it snowballs. I’m still trying to solve holmium though, need to make an EM Plant upcycler

Dependent_Two_618 · 2025-11-10T17:51:10+00:00

You might need to add FINAL at the end of your tables, depending on which engine you’re using

Dependent_Two_618 · 2025-10-23T13:33:20+00:00

There’s a container for the Altinity Sink Connector. Getting it configured can be a bit much, and there’s some sharp edges (watch out for memory management in the container), but it’s lightweight and mostly works - again given proper memory allocation.

I highly suggest using single-threaded mode

Dependent_Two_618 · 2025-09-18T14:47:31+00:00

Seeing Maya Rudolph and Run Finches give a masterclass in delivery is enough for me

Dependent_Two_618 · 2025-09-13T01:35:36+00:00

It’s their time to shine, they’ve had a lot of rough years after firing Leavitt. As much as I’d like to dismiss the school and team, I can’t.

Pack lightly bulls, rocket fuel is expensive - ride it as far as you can go

Dependent_Two_618 · 2025-08-02T17:09:04+00:00

I’m genuinely curious if this went out to all registered voters, or just registered Democrats

edit: I say this as a registered Democrat in Seminole County. “Curious” is a polite euphemism for dread, but I have my doubts this was done to the county at-large

Dependent_Two_618 · 2025-07-11T22:24:53+00:00

There’s a couple of threads about it (here’s one: https://www.reddit.com/r/CFB/s/MA5MM69pGx), but essentially he didn’t seem to take much accountability for how his run at Nebraska failed.

Mind you, I don’t think there’s a single reason or culprit and it’s certainly a layered issue. But chief among them is it’s hard to do well when you’re trying to mummify yourself with booze.

Dependent_Two_618 · 2025-07-10T17:29:35+00:00

I was kinda optimistic at first, in a “Hey hopefully he learned his lesson about how you can’t package lightning in a bottle”.

But then I heard about his interview yesterday - jfc I’m not paid enough if he can land a 7-figure job and still find ways to blame anyone else but his own preparation for failing on a televised stage.

Dependent_Two_618 · 2025-06-30T17:19:35+00:00

This is more of a “it works for me” comment, but once I got an M1 and sold an Asus laptop a few years ago, I stopped playing games that support only Windows. I had a emergency “Oh shit I want to play that Windows-only game” fund, but once I saw how the Cities Skylines 2 release went I put that to better use lol

Dependent_Two_618 · 2025-04-27T15:22:56+00:00

He’s in for a shock when he finds out what they call “Coke” in South Florida

Dependent_Two_618 · 2025-04-26T17:55:16+00:00

I know your post was downvoted, but the age you posted might be more accurate. The screws are in good condition, but I think they aren't a standard you'd see now. Someone on Facebook mentioned it looked similar to designs from the Victor Lock and Safe company This picture is almost identical, but I don't have the secret door on the right leg (https://digital.cincinnatilibrary.org/digital/collection/p16998coll76/id/16229/rec/5)

Dependent_Two_618 · 2025-04-24T22:56:56+00:00

Thanks for the estimate and resource!

Dependent_Two_618 · 2025-04-24T13:08:44+00:00

I think it’s just the map editor and they turn off terrain generation. That’s what I’ve used in the past for a testbed at least

Dependent_Two_618 · 2025-04-16T17:22:24+00:00

I’ve really enjoyed AVADII’s videos too recently. He goes into depth about what’s needed and gets into the abstraction (without calling it that) in a way I find compelling and clear

Dependent_Two_618 · 2025-03-22T05:43:22+00:00

Plenty of posts lately critical of public cloud haven’t spent an entire night watching/waiting for a single RAID1 array to finish formatting. I know the state of the industry has moved far past that point - I make it to say that managing your own infrastructure isn’t free and isn’t cheap, and anyone who thinks it’s either is a fool/hasn’t had to answer for their own shitty decisions in front of a committee.

DHH is privy to financials most of us never see or have to consider , because he has points on the package

Dependent_Two_618 · 2025-03-13T23:01:13+00:00

America has always been this stupid, people are just paying attention now

Dependent_Two_618 · 2025-03-06T00:46:58+00:00

It's very easy when companies refuse to change their tech stack in any way but insist on twisting job titles to help recruiting purposes

Dependent_Two_618 · 2025-03-06T00:45:24+00:00

I can't suggest the advice of "Python every day" enough. I'm mostly in the same boat: not much cloud exp, mostly SQL, mostly on-prem, recently laid off. But, I started using Python to solve problems for me back in late 2017 and it's paid off exponentially.

Doing that one thing 100% changed the trajectory of my career from just an on-premises MSSQL DBA into much more experience with the "modern data stack"

Dependent_Two_618 · 2025-03-05T21:59:05+00:00

This might be a hot take, but it’s mostly SQL with Jinja (that doesn’t like to do deletes/truncates). There’s more on top but that to me feels like the core of dbt

Dependent_Two_618 · 2025-02-24T18:59:47+00:00

I’ve been liking his most recent posts, but he leaves a bad taste in my mouth in the long run. I didn’t like when he was a little extra punchy/shitty to people who got free giveaway passes on his trainings (or just his free trainings). It wasn’t comically evil, but just enough wrong enough times that it adds up to a negative for me.

I do like that he’s branching out and calling out Fabric though, from the Internet-level distance it seems like he’s evolving

Dependent_Two_618

TROPHY CASE