sgarland

38 ms·

811.
by sgarland 1y ago
> Ship first, worry about scale later This is repeated constantly, but I fear that it is internalized as “write shitty code and throw money at it later.” If you have taken the time to learn your language well, you can avoid a lot of rea
812.
by sgarland 1y ago
You are the first person I have ever seen argue that tobacco in moderation is healthy. Quite the claim.
813.
by sgarland 1y ago
I have yet to see DevOps actually executed well. IME, it always winds up with half-assed infrastructure, because devs often have little interest in ops, and even more rarely have any kind of background in it. The entire concept seems to me
814.
by sgarland 1y ago
Not familiar with CADT, and Google wasn't any help for anything that seemed relevant.
815.
by sgarland 1y ago
I do want to add that many of the devs I work with and have worked with are genuinely interested in learning this stuff, and I am thrilled by it. What bothers me is when they neither have an interest in learning it, nor in fixing their bad
816.
by sgarland 1y ago
Please see this comment: https://news.ycombinator.com/item?id=43863885 We have excellent metrics between PMM and AWS Perf. Insights / Enhanced Monitoring. I assure you, on-disk temp tables were to blame. To your point,
817.
by sgarland 1y ago
I’ve worked with both (I personally have an unrelated BS and an MS in SWE, which I used purely to get my foot in the door – it worked), and IMO if someone has a BS, not MS, there’s a decent chance they at least understand DS&A, probably
818.
by sgarland 1y ago
Didn’t have to, prod benchmarked it for us, twice. If you’re curious, the EBS disks Aurora uses for temporary storage, when faced with a QD of approximately 240, can manage approximately 5000 IOPS. This was an r6i.32xlarge. My hypothesis is
819.
by sgarland 2y ago
It’s because modern devs by and large have zero concept of latency differences. I had to explain to people yesterday why an on-disk temporary table in MySQL was slower than an in-memory one. “But the disk is an SSD,” was an actual rebuttal
820.
by sgarland 2y ago
Codeweavers Crossover does an admirable job at filling the gap (shoutout for making AoE II run like it’s native), but yeah, there are some that you can’t get around using Windows for.
821.
by sgarland 2y ago
How dare you – Steam Launcher 11 makes a pleasant sound upon login, harkening back to its forebears, CD-ROM Launcher 95 and 98.
822.
by sgarland 2y ago
Fully agree that Desktop Linux isn’t nearly there. If I need a Linux DE for something, I spin up a Debian VM with XFCE, because that seems to suck the least, and I already have prebaked Debian images. For headless servers, I want nothing el
823.
by sgarland 2y ago
> Ubuntu Well, there’s your problem ;-) This is great, though, really. I broke our computer so many times growing up, I couldn’t possibly count. I don’t think I ever lost anything of import, other than some savegames of mine. I keep tell
824.
by sgarland 2y ago
From your link: >> gsd > gnome-settings-daemon. >> no-longer > Don't think that's in the OED >> This is rather unfriendly and considerably more effort than editing logind.conf > I don't like the ton
825.
by sgarland 2y ago
Until you have to administer the DB. It’s doable, of course, but RDBMS administration for anything beyond toy scale gets interesting.
826.
by sgarland 2y ago
A company I was at had an internal blog where anyone could write an article, and others could comment on it. Zero requirement to do so, and it in no way factored into your rating. I think it was the result of a hackathon one year. Anyway, I
827.
by sgarland 2y ago
> With UUIDs there is absolutely no need for that. Except now (assuming it’s the PK) you’ve added the additional overhead of a UUID PK, which depending on the version and your RDBMS vendor, can be massive. If it’s a non-prime column, I h
828.
by sgarland 2y ago
Thanks for the links, I appreciate it. The GScholar link had many studies, yes. I found some conflicting opinions. Institute of Transportation Studies, UC California [0]: “There is, however, no empirical study that demonstrates that the 85t
829.
by sgarland 2y ago
So have a pending table with id, user_id, created_at, and index the latter two as a composite key. SELECT id FROM pending WHERE user_id = ? ORDER BY created_at DESC LIMIT 1. Preferably delete the row once it's been permanently stored.
830.
by sgarland 2y ago
> Texas That’s because there is no effective regulation of the state’s power industry. Since they’re (mostly) isolated from the national grid, they aren’t required to listen to FERC, who told them repeatedly that they should winterize th
831.
by sgarland 2y ago
I think you’re thinking out the cache property of a sequence, but it defaults to 1 (not generating ranges at once). However, Postgres only needs a lightweight lock on the sequence object, since it’s separate from the table itself. MySQL doe
832.
by sgarland 2y ago
I’ve never understood this argument. In every RDBMS I’m aware of, you can either get the full row you just inserted sent back (RETURNING clause in Postgres, MariaDB, and new-ish versions of SQLite), and even in MySQL, you can access the las
833.
by sgarland 2y ago
I’m not saying it’s not an undertaking if you’ve never done it, but there are plenty of tools for MySQL and Postgres (I assume others as well) to do zero-downtime online schema changes like that. If you’ve backed yourself into a corner by a
834.
by sgarland 2y ago
So does Postgres to an extent, but in general, MySQL has more hidden edge cases, and Postgres has more hidden maintenance requirements.
835.
by sgarland 2y ago
On a sub, anyway, the diesel is always started with air, not just in emergencies. Makes a cool sound as it comes up.
836.
by sgarland 2y ago
When you have a few million rows, no. When you have hundreds of millions or billions of rows, yes, it matters very much.
837.
by sgarland 2y ago
The problem is that companies tend to only hire DB expertise when things are dire, and then, the dev teams inevitably are resistant to change. You can monitor and predict the growth rate of a table; if you don’t know you’re going to hit the
838.
by sgarland 2y ago
I’ll go further; don’t automatically default to a BIGINT. Put some thought into your tables. Is it a table of users, where each has one row? You almost certainly won’t even need an INT, but you definitely won’t need a BIGINT. Is it a tabl
839.
by sgarland 2y ago
Or if it’s MySQL, the PK is implicitly copied into every secondary index. Adds up quickly.
840.
by sgarland 2y ago
> If a significant percentage of vehicles are deemed unsafe to drive because of this, then removing them from the road would be a good thing. “Good” is not a binary state, and it’s also wildly subjective. If by removing 100,000 unsafe ca

More ›