sgarland

10 ms·

181.
by sgarland 6mo ago
What always frustrates me is that when people on here discuss deeply technical and/or meta-aspects of programming (e.g. type theory), it's taken at face value, but the same is not true of databases. They are generally treated as a
182.
by sgarland 6mo ago
NOTE: this is critiquing the author's 4NF definition (from a link in TFA), not TFA itself. > If you read any text that defines 4NF, the first new term you hear is “multivalued dependency”. [Kent 1983] also uses “multivalued facts”.
183.
by sgarland 6mo ago
> You are looking at maybe a millisecond of latency overhead [for 1 megabyte] Considering the data transfer alone for 1 MB / 1 msec requires 8 Gbps, I have doubts. But for fun, I created a small table in Postgres 18 with an INT PK,
184.
by sgarland 6mo ago
Complexity mostly rose out of necessity, but the problem is it keeps being applied where it isn’t needed. Most projects don’t need Kafka, or Elastic, or Redis, or GraphQL, etc. My main complaint is that by and large, the people who are appl
185.
by sgarland 6mo ago
I did an experiment today, where I had a new Claude agent review the work of a former Claude agent - both Opus 4.6 - on a large refactor on a 16k LOC project. I had it address all issues it found, then I cleared context, and repeated. Rinse
186.
by sgarland 6mo ago
> just use serial Ideally you use IDENTITY with Postgres, but the end result is the same, yes.
187.
by sgarland 6mo ago
Both, assuming you’re ever going to index it - both use a form of a B+tree for their base indices. If it’s just being stored in the table, it doesn’t matter, but also if it doesn’t matter, just use v7.
188.
by sgarland 6mo ago
Aside from the perfect solution fallacy, pragmatically it's because most operating systems require more than that to run. Debian's current recommended minimum is 512 MB, though they note that with swap enabled, as little as 350 MB
189.
by sgarland 6mo ago
Constraints provide feedback. Real-world example from my job: we have no real financial constraints for dev teams. If their poor schema or query design results in SLO breaches, and they opt to upsize their DB instead of spending the effort
190.
by sgarland 6mo ago
Very cool, thanks for the response!
191.
by sgarland 6mo ago
In Postgres, an UPDATE is effectively an INSERT + DELETE [0]. 0: https://www.cybertec-postgresql.com/en/is-update-the-same-as...
192.
by sgarland 6mo ago
Unless your Cloudflare worker and the DB are scheduled onto the same physical server, they are not local to one another. I don’t know much about D1, but the overwhelming majority of cloud infra makes no such guarantees, nor are they likely
193.
by sgarland 6mo ago
In 5 years of running 3x Dell R620s 24/7 - which were already 9 years old when I got them - I had two sticks of RAM have ECC errors, and one PSU fail. The RAM technically didn’t have to be replaced, but I chose to. The PSU of course
194.
by sgarland 6mo ago
Namespaces exist in Linux [0], they weren’t invented by K8s. You can view application logs with anything that can read a text file, or journalctl if your distro is using that. There are many methods of performing application upgrades with m
195.
by sgarland 6mo ago
It doesn’t sound like OP was optimizing anything; it sounds like they just knew how to use that stack, and so are able to get customer validation while also spending very little per month.
196.
by sgarland 6mo ago
If I give you a box with 1 GiB of RAM, you are literally forced to either optimize your code to run in it, or accept the slowdown from paging. How is this specious?
197.
by sgarland 6mo ago
It sounds vaguely like InnoDB’s concurrency control solution which uses tokens [0] as a unit of maximum work a query can perform. 0: https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-t...
198.
by sgarland 7mo ago
I intermingled the two claims, you’re correct, and was not intending to move the goalpost. I apologize. Claim one: setting up unattended-upgrades, SSH keygen, and automating cert rotation is trivial and easily automated. Claim two: you shou
199.
by sgarland 7mo ago
When AWS announces that they’re EOL’ing the Python or NodeJS version in your Lambda, or the version of your RDS cluster, etc. you also are required to take human action. And in fact, at any appreciable scale, you likely want that behavior
200.
by sgarland 7mo ago
If an LTS of an OS replaced nginx with something else, a. it would be announced with great fanfare months in advance b. if you don’t want to do that, add apt / yum / zypper install nginx to your Ansible task, or whatever you’re us
201.
by sgarland 7mo ago
The parent I responded to was discussing issuing certs, configuring SSH keys, and updating an OS. Those are all in fact trivial and easily automated. What you have stated requires more knowledge (especially Postgres). You’re not going to ge
202.
by sgarland 7mo ago
You don’t, you automate it. This has been a solved problem for literally years.
203.
by sgarland 7mo ago
This is all trivial, and can and should be automated. Furthermore, all of your arguments can easily be applied to NodeJS version deprecations, React realizing they shipped a massive CVE, etc. I will die on this hill: parent is correct - the
204.
by sgarland 7mo ago
> The sqlite_sequence table is the most underappreciated debugging tool in SQLite. It tracks the highest auto-increment value ever assigned for each table — even if that row was subsequently lost. > WorkQueueTask.count returns ~300 (c
205.
by sgarland 7mo ago
> Writing assembly is probably completely irrelevant. ffmpeg disagrees. More broadly, though, it’s a logical step if you want to go from “here’s how PN junctions work” to “let’s run code on a microprocessor.” There was a game up here yes
206.
by sgarland 7mo ago
That’s definitely not how I learned it, nor how my kids have learned it. I vividly remember writing out “2 x 3 = 2 + 2 + 2 = 3 + 3.” I later memorized the multiplication table up to 12, yes, but that was not a replacement of understanding w
207.
by sgarland 7mo ago
Some things are just enjoyable. I get no real utility from photography - it’s not my career, it’s not a side gig, and I’m not giving prints out as gifts. Most of the shots never get printed at all. I do it because I enjoy the act itself, of
208.
by sgarland 7mo ago
I would love to see someone attempt to do multiplication who never learned addition, or exponentiation without having learned multiplication. There is a vast difference between “never learned the skill,” and “forgot the skill from lack of u
209.
by sgarland 7mo ago
CPU performance was acceptable; GPU was the one was that falling off a cliff. Re: particular unit, I’m not sure - it was perfectly fine during anything “normal,” and admittedly, asking a laptop to run at 100% for any extended period of time
210.
by sgarland 7mo ago
Tangential, I bought a nearly identically-spec'd (didn't spring for the 8 TB SSD - in retrospect, had I kept it, I would've been OK with the 4 TB) model, and returned it yesterday due to thermal throttling. I have an M4 Pro w

More ›