sgarland

7 ms·

91.
by sgarland 4mo ago
Correct me if I'm wrong, but MongoDB appears to have a 100-msec gap for its journaling behavior [0] by default. This would be akin to setting innodb_flush_log_at_trx_commit [1] = 2, which is not its default. I also note that in their
92.
by sgarland 4mo ago
I think the author has a certain writing style that you apparently dislike, which is fine, but it’s hardly slop. I agree that the comparison between Sketch being somewhat unreliable but fast undercuts the claim that speed and reliability of
93.
by sgarland 4mo ago
I don’t think I’ve ever noticed a difference in speed on the terminal between distros. Shells (or more accurately, plugins / frameworks - I recently gave up oh-my-zsh in favor of zimfw for that reason), yes, but not the terminal itself
94.
by sgarland 4mo ago
> Document behaviors. Model the system. Let the system decide what data storage it requires. Counterpoint: force the system to use an RDBMS to store data in properly normalized schema, because it’s the only thing guaranteeing that the da
95.
by sgarland 4mo ago
Much like I can’t take Prisma seriously because they shipped an ORM that couldn’t do JOINs, I can’t take any database seriously that can’t manage ACID. “bUt wE haVe BAsE.” Cool story. Relational databases are some of the oldest and best-tes
96.
by sgarland 4mo ago
Profile your code sometime; I assure you, with a properly indexed query, the actual query time is insignificant compared to everything else, unless your app is Rust, C, Nim, etc. The overwhelming majority of OLTP queries I see running on ma
97.
by sgarland 4mo ago
I’m a DBRE, and also happen to like SQL. With that as a disclaimer, I really do not think it’s a difficult language to learn. Learning the intricacies of your RDBMS’ behavior for various functions (like MySQL’s ORDER BY and GROUP BY optimiz
98.
by sgarland 4mo ago
Fun fact, NIST also still runs the TIME protocol (RFC 868 [0]) [1]. 0: https://www.rfc-editor.org/rfc/rfc868 1: https://tf.nist.gov/tf-cgi/servers.cgi
99.
by sgarland 4mo ago
I’ve not tried encoding my own MP3s in at least a decade, but when I was doing so, 128 kbps was instantly distinguishable to me on anything with cymbals, especially hi-hat: it loses that shimmery sound. At 192 kbps I could tell if I really,
100.
by sgarland 4mo ago
> [RLS]… planner goes haywire and does per-row-matching Er… yes? It’s called Row-level security; how else are you going to validate that a row passes a policy?
101.
by sgarland 4mo ago
I had AudioGalaxy before Napster, and preferred higher bitrates (192 KBPS CBR, until VBR took off), but yes - RealAudio didn’t have that long of a lifetime in comparison.
102.
by sgarland 4mo ago
I was gonna say, we absolutely had streaming music. Did it suck? Yes, but it was novel, so it was acceptable. I had a 33.6 connection that my ISP eventually upgraded to full 56K, which I discovered by noticing that the dial-up handshake sou
103.
by sgarland 4mo ago
As long as you aren’t biasing for any protected classes, why does it matter? If you as an employer have found that graduates from Foo University is a generally positive signal, then why wouldn’t you bias for that, if it’s saving you signifi
104.
by sgarland 4mo ago
I’m confused about the choice for Parquet and DuckDB here. PostGIS is arguably a better match for what this project is doing, and would let you skip most of if not all uses of Shapely and Pyproj.
105.
by sgarland 4mo ago
I don’t remember for my first application; probably a few hours. My second application was 27 pages, of which you can attribute a few to the pre-existing template. I spent probably 10-15 hours on it, spread across several evenings.
106.
by sgarland 4mo ago
Oxide is literally the only company where I have found zero reasons why I would be unhappy to work there. I have listened to many, many podcasts, read RFDs… it always seems like a place I would thrive. To that end, I have applied twice in t
107.
by sgarland 4mo ago
Those examples are all equally difficult to reason about. Cache invalidation is equivalent to refreshing a materialized view, and UNLOGGED tables bring about new and exciting ways lose data.
108.
by sgarland 4mo ago
As the sibling comment from eximius mentions, devs will routinely reach for these long before they’re remotely needed. A well-tuned Postgres installation on fast hardware and intelligent schema design can scale incredibly far, even if you’r
109.
by sgarland 4mo ago
DB-level rules saving the day once again.
110.
by sgarland 4mo ago
QuickTime is fine. It does the basics, is intuitive, and fast.
111.
by sgarland 4mo ago
> VLC VLC on my Mac uses about 130 MB of RAM (as reported by Activity Monitor) to play a FLAC file, and about 300 MB to play a high-bitrate 1080p MP4 file. The audio file memory consumption frankly seems high, but it’s fine, and apparent
112.
by sgarland 4mo ago
You know hardware failures can occur, right? I worked as an SRE at a well-known monitoring company that used a similar architecture. It worked extremely well, and aside from one software SPOF (which still had a blast radius limited to that
113.
by sgarland 4mo ago
If anything, it’s similar to a pod, not a container.
114.
by sgarland 4mo ago
IME, there is a negative correlation “justifies increased memory consumption by citing DX” and “ships code with fewer critical issues.”
115.
by sgarland 4mo ago
I have no problem with pandas (though polars is immensely faster, for those cases where it matters), just as I have no problem with numpy; what I dislike is people reaching for them for the most trivial of things that are already solved by
116.
by sgarland 4mo ago
I naïvely assumed that avoiding being paged was motivation enough, but experience has disabused me of that notion. Time after time, “we’ll fix one more thing on our hacky, bespoke bullshit” has won out over “we will use boring, pre-existing
117.
by sgarland 4mo ago
> the fact that programs and websites are delivered by large teams, there are dozens of submodules that are often loaded even when not needed Precisely this. We had an incident once where a CSV had a postal code field be interpreted as a
118.
by sgarland 4mo ago
I learned about Stow after I found out about Chezmoi, and felt like Chezmoi was the better fit for me. I make heavy use of templating to keep work / personal aliases and functions separate, and could not be happier with the outcome.
119.
by sgarland 4mo ago
I was literally looking today to see if there was any news on this, because it’s been widely assumed that they’d release it. $4000 is… a lot. I can buy a used CSE-846 for about 1/4 of that, an X10–era mobo for a few hundred bucks, and
120.
by sgarland 4mo ago
And Dahl’s foundation or whatever it’s called had the audacity to try to rewrite the books; removing references to people as ugly, or fat, etc. You don’t get to rewrite books because they make you feel uncomfortable. Don’t read them. Even D

More ›