sgarland

10 ms·

121.
by sgarland 4mo ago
I will die on the hill that triggers are a perfectly fine tool, when used reasonably. ON INSERT isn’t usually the one I point at causing problems; that’d be ON DELETE CASCADE. 1:M relationships with large values of M are already iffy for de
122.
by sgarland 4mo ago
Yes, at some point it boils down to “how much do you actually care?” I was in the same position when I lived in Texas; the local school board was insane, but I didn’t care enough (because my kids were in a Montessori school) to do anything
123.
by sgarland 4mo ago
They should be performing bulk deletions, due to GDPR: “Data must be stored for the shortest time possible.” Unless you have some kind of rolling cron checking every few minutes (and even then, depending on your scale, that may well be co
124.
by sgarland 4mo ago
I assume partly because that would be extremely surprising behavior, and depending on the RDBMS and version, could introduce unexpected stalls. For example, MySQL < 8.0.23 scans the entire buffer pool to clear pages that were dropped, wh
125.
by sgarland 4mo ago
That’s a fair rebuttal. A counter - though not entirely so, depending on the logic behind your statement - is that public schools (in the U.S., anyway) are paid for by taxes, even if you have no children who are benefiting from it.
126.
by sgarland 4mo ago
The same is true to a lesser extent in MySQL / MariaDB. It does better since it doesn’t do oldest-to-newest tuple chains, but it’s still adding non-trivial work to the DB, much of which is effectively wasted if you don’t care about the
127.
by sgarland 4mo ago
I see nothing wrong with mandating vaccines if you want to exist in society. You want to use public services? Be a responsible part of the public. Vaccines were once heralded as miracles of science, because they are. It wasn’t until the U
128.
by sgarland 4mo ago
Everything would still be bloated, it’s just that the people doing the bloating point to that quote as though it’s defending their position. What kills me is that a lot of the stuff just isn’t that hard. You need a data structure that you’l
129.
by sgarland 5mo ago
> using joins just isn’t feasible That sounds like you’re either joining on an unindexed column, or have outdated statistics. 8 queries implies 8 tables, which is well under the limit for both Postgres and MySQL where the planner may giv
130.
by sgarland 5mo ago
Every DB, even MySQL can return the autoincrementing integer for you as part of the insert. Postgres, SQLite, and MariaDB (likely others, I’m just not familiar) can even return the rest of the data, should you need that. IME, most of the ar
131.
by sgarland 5mo ago
Or just write tests, instead of relying on statistical improbability to prevent disaster.
132.
by sgarland 5mo ago
Yup. Anymore, “we’ll handle that in code” reads to me as “I don’t understand my tools, and don’t want to learn.” Or hubris. The sheer number of times I’ve seen data integrity errors because someone didn’t think they needed a database-level
133.
by sgarland 5mo ago
For one, Airflow (or anything external, for that matter) has no insight into DB load, so when devs slam 200 concurrent workers at the DB, other workloads may be impacted. In contrast, this could (I don’t think it does at this time) get near
134.
by sgarland 5mo ago
It’s always been possible to rewrite it; LLMs just made it possible for people who don’t understand it to do so. I personally don’t see that as a benefit, but you do you. As to the age statement, why on earth does that matter? HAProxy launc
135.
by sgarland 5mo ago
The only true relational database engine I’m aware of is Rel [0], which is a learning tool at best, not a production-capable DBMS. I understand that SQL is pseudo-relational, but it’s as good as you’re going to get if you want something you
136.
by sgarland 5mo ago
Fully agree. If you want to follow the thought process through a large PR, review each commit (assuming, of course, the author made reasonable commits) on its own.
137.
by sgarland 5mo ago
> I could see FROM being first, that would actually make a little more sense to me. Personally, I disagree. In English, an imperative statement like "move that chair from the dining room to the living room" is generally verb-fi
138.
by sgarland 5mo ago
What do you consider to be clever SQL?
139.
by sgarland 5mo ago
I agree with everything except this: > Understand the wire protocol and the client-server model. I'm a DBRE, and have locally compiled MySQL with debug symbols to step through something with gdb. I have yet to examine the wire proto
140.
by sgarland 5mo ago
Right? Make any metric meaningful for an employee, and they will find ways to maximize that metric. I thought this was a well-understand phenomenon.
141.
by sgarland 5mo ago
I know you said “mostly,” but wood is a huge outlier. It’s too heterogeneous to be accurately worked by machines at the level of accuracy that truly fine craftsmanship demands. To be clear, I’m talking about the level where a single chair c
142.
by sgarland 5mo ago
I stumbled across Voron and was immediately hooked. I have a Bambu X2D, and while it is quite nice, the frustration of "I don't have access to X" is very real. There are a ton of things I want to do involving automation, reco
143.
by sgarland 5mo ago
I have had exact opposite experience WRT display technologies. I normally use USB-C <-> DP, but they are far more finicky than HDMI. I only use the former because the hub I have for my Mac doesn’t do 4K@120 Hz over HDMI. EDIT: sorry,
144.
by sgarland 5mo ago
My Acer Predator can disable that option. The downside is specifically for MacOS, the Mac often gives up trying to sync before the monitor has finished its side of things, and since the Acer has a non-configurable, extremely short auto-powe
145.
by sgarland 5mo ago
It would, but it forces the requirement of DISTINCT. With the original, if there were declared PKs (pokemon_name is fine for the main table, with a composite for others), the semi-join (EXISTS) would eliminate the need for DISTINCT entirely
146.
by sgarland 5mo ago
Alas, I’ve learned that while everyone wants to hire them to fix their hideously fucked systems, they really don’t enjoy being told that their systems are, in fact, hideously fucked. They’d much prefer you quietly put out fires while biting
147.
by sgarland 5mo ago
They did it better. I’ve never met anyone who has used both GitLab CI and GitHub Actions and thought they were remotely equivalent.
148.
by sgarland 5mo ago
> Great engineers are problem solvers and builders who care about system design, distributed systems, reasoning through failures, safely integrating new capability into critical systems, and making decisions under ambiguity. Yes, and the
149.
by sgarland 5mo ago
…this is GitLab, not GitHub.
150.
by sgarland 6mo ago
Sure - but it’s easier to spot and squash. Banning the use of the command and shell modules eliminates a majority of spaghetti / idempotency footguns.

More ›