sgarland

38 ms·

721.
by sgarland 1y ago
TRUNCATE is DROP TABLE + CREATE TABLE, it’s not a bulk delete. It bypasses the typical path for writes entirely.
722.
by sgarland 1y ago
Why does it not support TRUNCATE?
723.
by sgarland 1y ago
I was replying to your statement, not the article. Did I miss that quote in it? > We all have to use technologies that we're not world-class experts in I’m not asking people to be experts, just to know how it works. If you write sof
724.
by sgarland 1y ago
> I think the interesting question is like, if I have X amount of time and mental bandwidth to learn about a technology, what's the most helpful lossy compression of concepts that fits? You cannot possibly know if your condensed ver
725.
by sgarland 1y ago
MySQL and Postgres both support it; that's a huge percentage of what most devs are ever going to encounter. MSSQL and Oracle may do so as well, but I'm not familiar with those beyond some trivial usage. More to the point, this lac
726.
by sgarland 1y ago
> Database [anything] Honestly, the author couldn't have chosen a worse example if they tried. RDBMS are so absurdly complex and have so many edge cases for everything, that they are my canonical answer to why it's a bad idea t
727.
by sgarland 1y ago
For that matter, if you index `(name, email)` and query with `name` and `address` as the predicates, unless there's a better option, or the table is tiny, there's an excellent chance the planner will use that index to narrow down
728.
by sgarland 1y ago
I very much enjoyed the Vercel fanboys posting their enormous bills on Twitter, and then daring people to explain how they could possibly run it on, you know, a server for anything close to the price. I took the bait once and analyzed a $50
729.
by sgarland 1y ago
If nothing else, handling interrupts from the NIC to pull packets out of its receive buffer, though that should be usually be isolated to a couple of cores. Also, re: I/O, the CPU usually also has to handle interrupts there, as well as
730.
by sgarland 1y ago
Every time a dev discovers how tremendously bloated and slow modern software is, an angel gets its wings.
731.
by sgarland 1y ago
> Kafka / RabbitMQ These are different things, and the fact that they're so often conflated is IMO prima facie that they're misused. If you need a queue, you shouldn't be reaching for Kafka, and vice-versa. > Then
732.
by sgarland 1y ago
You're 100% correct, but unless I'm missing something, this has already been done (modulo JavaScript, thankfully): PostgREST [0]. [0]: https://docs.postgrest.org/en/v13/
733.
by sgarland 1y ago
> For example, to store a graph in a RDBMS, the ideal format is probably an adjacency list with a recursive query to iterate it I know this was a minor point, but I think it speaks to the overall topic, so I'll poke at it. Adjacency
734.
by sgarland 1y ago
I thought this was going to discuss how WinRAR remains a tiny executable, single-digit MB, in an age of bloat. Still a good post, but not what I thought it would be.
735.
by sgarland 1y ago
Re: lag, that’s a fair point, but IME devs don’t care if it’s 10 msec or 1000 msec, they don’t trust it either way. “I have to read after write.” I know MySQL doesn’t have RETURNING, maddeningly, but I’ve tried explaining how they could use
736.
by sgarland 1y ago
Yes, an instance. You know you can set up hot standby for vanilla MySQL and Postgres as well and achieve the same thing, right? They developed those to make a shit ton of money, and on that front, they succeeded.
737.
by sgarland 1y ago
> Yeah that's my point! That's the load per instance that I see at my current company, we just have fewer replicas. Yup. At a previous company and current, I had single instances handling 120K QPS. > If you get it wrong (and
738.
by sgarland 1y ago
> For clones you dont pay for the extra storage for the new database, only the delta if you add new data... Considering how much they’re charging you just to query storage, that’s still a net negative. If anything, you’re going to pay MO
739.
by sgarland 1y ago
Oh yeah, separating compute and storage by a large physical distance was a great idea that certainly had no downsides! It's so awesome that they added "Optimized Reads" as an option, which is literally just running the DB on
740.
by sgarland 1y ago
> Also, not all developers can roll their own sqls If you can't write SQL, don't use an RDBMS until you learn it. This sounds like gatekeeping because it is: I don't understand why so many people are willing to accept that
741.
by sgarland 1y ago
I would never say that self-hosting anything is trivial. Linux administration, tuning, and troubleshooting can be learned, obviously, and the same is true of RDBMS. Neither is a trivial skillset if you want to actually be able to run stuff
742.
by sgarland 1y ago
> they're clearly struggling with this single-master setup and trying to keep it afloat while migrating off ("no new workloads allowed"). TFA states they’re at 1 million QPS, in Azure. 1 million QPS with real workloads is
743.
by sgarland 1y ago
The part of this argument that doesn’t make sense to me is that you’d think any CEO would have a reasonably decent bullshit detector, but maybe since they have to shovel it out so much, they forget how to detect it in others.
744.
by sgarland 1y ago
Wants is the operative word. If you show up to a racetrack with zero experience and a Ferrari, you’re not going to be accepted if you try to pretend that you know how to drive. You’ll probably also hit the wall, which hopefully would prov
745.
by sgarland 1y ago
The platonic ideal of DevOps is fine, yes. The problem I’ve consistently run into is there is a vanishingly small percentage of devs who want to do Ops, or even consider that a server with real constraints is running their code. Performan
746.
by sgarland 1y ago
They seem to be a game dev judging by their other posts. I imagine there’s a lot less content online about that for LLMs to scrape than yet another CRUD app.
747.
by sgarland 1y ago
It generates reasonably performant code because most of the industry isn’t writing code that’s computationally bound. If you have to wait for network I/O anyway, it doesn’t really matter if your code is optimal, because that wait will
748.
by sgarland 1y ago
Fair point. I don’t hate AI, and use it sometimes, but I’m always painfully aware that it can and will make mistakes, some subtle, that must be caught by someone who already knows most of the answer.
749.
by sgarland 1y ago
> I like writing front end code. I'm probably never going to have a job where i need or would even want to write a low level graphics library from scratch. Fine, I'm not red-eyed 3am hacker brained, but I'm passionate and
750.
by sgarland 1y ago
If you don’t learn _how to learn_, you’re going to struggle mightily in life. Not just at your job.

More ›