sgarland

12 ms·

271.
by sgarland 9mo ago
This is what I don’t understand: why highly-paid SWEs seem to think that their salaries will remain the same (if they even still have a job) if their role is now a glorified project manager.
272.
by sgarland 9mo ago
> The major thing I advocate for is don't pick a NOSQL database to avoid relational dbs, only to try and do a bunch of relational work in NOSQL that would have been trivial in an RBDMS. It has always felt to me like devs will gravit
273.
by sgarland 9mo ago
NUL in the middle of a string is fine, types have no meaning, VARCHAR limits are just suggestions… The flexible typing is the biggest WTF to me, especially because it necessitates insane affinity rules[0]. For example, you can declare that
274.
by sgarland 9mo ago
Seriously. I would expect him to be more of an offer-only scenario.
275.
by sgarland 9mo ago
MySQL is definitely easier to use if you don’t want to ever have to think about DB maintenance; on the other hand, you’re giving up a TON of features that could make your queries enormously performant if your schema is designed around them
276.
by sgarland 9mo ago
If you think Postgres has idiosyncrasies… https://sqlite.org/quirks.html
277.
by sgarland 9mo ago
That’s going to be enormously expensive. If you need guaranteed tenant isolation, put them in separate schemas, with specific user grants. That scales up much better than you’d think. Or use Citus Postgres, and get sharding by schema for fr
278.
by sgarland 9mo ago
> make the changes but exit with a non-zero status That's reasonable. My personal (and that of my team at the time) take was that I was willing to let formatting - and only formatting - be auto-merged into the commit, since that isn
279.
by sgarland 9mo ago
> And if each of your clients is in the Healthcare industry and dealing with end-user medical data? Or financial data? Then you're probably going to need some combination of HIPAA / SOC 2 / PCI DSS certification, regardles
280.
by sgarland 9mo ago
I ran 3x R620s 24/7/365 in my homelab for ~6 years (well, other than when I moved, or shut one down for a clean-and-inspect, or lost power in excess of what my UPS could handle... thanks, Texas). The only things that failed during
281.
by sgarland 9mo ago
Same! I don't mind copy/pasting a code snippet or asking a question, and I also always ask it to show its sources for anything non-obvious. That alone cuts down on a lot of bullshit.
282.
by sgarland 9mo ago
Agreed. Mostly, what has occurred is I now have to field a lot more PRs that weren't well thought out (let's be honest, there was no thought), and - my personal favorite - argue with an AI via a human, where they post an AI's
283.
by sgarland 9mo ago
You should have kept reading: > Redundancy is not needed since no specific data is critical. > we have a redundant mkv storage array to store all of our trained models and training metrics. That's just called understanding your f
284.
by sgarland 9mo ago
The degree is whatever you want to deal with. I had a rack at my last house (need to redesign the space for it at new house) with 3x Dell R620s in a Proxmox cluster, running K8s, serving Ceph from NVMe drives over Infiniband (for the mesh t
285.
by sgarland 9mo ago
> But until then it's a long term cost optimization with really high upfront capital expenditure and risk. The upfront capex does not need to be that high, unless you're running your own AI models. Other than leasing new ones,
286.
by sgarland 9mo ago
SRE has also lost nearly all meaning at this point, and more or less is equivalent to "I run observability" (but that's a SaaS solution too).
287.
by sgarland 9mo ago
Note that they're running R630/R730s for storage. Those are 12-year old servers, and yet they say each one can do 20 Gbps (2.5 GBps) of random reads. In comparison, the same generation of hardware at AWS ({c,m,r}4) instance maxes
288.
by sgarland 9mo ago
The person I replied to said they wanted an open-source reimplementation of Aurora. My point - which was probably poorly-worded, or just implied - was that there's a lot of work that goes into something like that, and if you can't
289.
by sgarland 9mo ago
Nitpick (I blame Amazon for their horrible naming): Aurora and RDS are separate products. What you’re asking for can mostly be pieced together, but no, it doesn’t exist as-is. Failover: this has been a thing for a long time. Set up a synchr
290.
by sgarland 9mo ago
Agreed. The higher-ups at my company are, like most places, breathlessly talking about how AI has changed the profession - how we no longer need to code, but merely describe the desired outcome. They say this as though it’s a good thing. Th
291.
by sgarland 9mo ago
It depends. I wrote a pre-commit hook (in shell, not precommit the tool) at a previous job that ran terraform fmt on any staged files (and add the changes to the commit) because I was really tired of having people push commits that would th
292.
by sgarland 9mo ago
That’s what --no-verify is for.
293.
by sgarland 9mo ago
> BIGINT I’d use a SMALLINT (or in MySQL, a TINYINT UNSIGNED) for a lookup table. The bytes add up in referencing tables. > Most people don't employ these strategies because storage is cheap and compute time is expensive. Memory
294.
by sgarland 9mo ago
> It's worth actually being specific about what differentiates a junior engineer from a senior engineer. There's two things: communication and architecture. Uhhh… also skills and abilities? You won’t develop either of those by
295.
by sgarland 9mo ago
Agreed. My work is mandating Claude Code usage this week for everyone. I spent all day today getting it to write tickets, code, and tests for something I knew how to do. I don’t understand the appeal. Telling the AI “commit those changes an
296.
by sgarland 9mo ago
Did you unironically use the term “web scale” in reference to a database?
297.
by sgarland 9mo ago
If you go to an emergency room at a hospital which accepts Medicare (so, essentially all of them), you will be screened, and if in danger, medically stabilized (modulo difficult pregnancies in some states with anti-abortion laws, unfortunat
298.
by sgarland 9mo ago
They seem to be able to induce whistleblowers to off themselves at a shocking rate, though.
299.
by sgarland 9mo ago
If the market was critically examining fundamentals and thinking beyond the next quarter, I might agree with you. As it is, by and large it cares about the next earnings report. I work in fintech, at a market leader. We are wildly ineffic
300.
by sgarland 9mo ago
But when a long train of abuses and usurpations, pursuing invariably the same Object evinces a design to reduce them under absolute Despotism, it is their right, it is their duty, to throw off such Government, and to provide new Guards for

More ›