Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
sgarland
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
26 ms
·
451.
▲
by
sgarland
1y ago
I actually did use virtualenvwrapper quite a bit until uv. I had built up various shell aliases and functions, so it was fairly painless to create and manage venvs. uv just means that I don’t have to think about that part now.
452.
▲
by
sgarland
1y ago
> There are more than two programming languages in the world. Great, then you know how to check it in your language of choice.
453.
▲
by
sgarland
1y ago
In a shell script, set -u. It’ll terminate if you reference an unset variable. In other languages, check that the var you pulled in isn’t falsey before proceeding.
454.
▲
by
sgarland
1y ago
I think parent is referring to something like SOPS [0], which can pass secrets via FIFO. That way, there’s nothing on disk, the pipe is cleared after first read, and /proc/cmdline doesn’t reveal anything. 0: https://git
455.
▲
by
sgarland
1y ago
Yes, I know how to fix it. I’m saying that it’s absurd to have to drop down to SQL to get an ORM to play nicely; Django handles this with a flag.
456.
▲
by
sgarland
1y ago
Wait until you find out that the RDBMS optimizer may also sometimes convert your outer joins to inner joins. I dislike all ORMs, but I especially dislike SQLAlchemy for its hideously bad docs.
457.
▲
by
sgarland
1y ago
Alembic cannot fake a migration, which is a continual source of pain for me at my current job. There are many migrations that I simply don’t trust development teams to do. The inability to easily tell Alembic to get over itself and trust th
458.
▲
by
sgarland
1y ago
That would be ideal, but in practice, SemVer is frequently broken with technicalities or outright disregard for standards. Look at K8s: still on v1, but there have been countless breaking changes. Their argument is that the core application
459.
▲
by
sgarland
1y ago
What do you have against ARC? It’s an extremely proven piece of tech.
460.
▲
by
sgarland
1y ago
They literally tell you to fork it, and also demonstrate how to recreate some features. I don’t know what else you think should happen.
461.
▲
by
sgarland
1y ago
If/when they launch a bigger unit than 8-bay, with ZFS, I’ll probably buy it. I’m already in the ecosystem and love it, and while my homegrown Debian-based NAS is rock-solid, I’d totally switch if they had a 3U or 4U high-capacity offe
462.
▲
by
sgarland
1y ago
I hadn’t heard about Datastar until this brouhaha started, but having read everything, I’ve come to the conclusion that many people are entitled primadonnas. I really do not understand the outrage. Nothing has been taken away, it hasn’t bee
463.
▲
by
sgarland
1y ago
That is very cool! Was/is it available on BDR v3.6? I think that’s the version I was using.
464.
▲
by
sgarland
1y ago
Bold of you to assume it was automated. The process I used was tmux with pane synchronization. I asked to automate it (probably would've just been a shell script, _maybe_ Python, issuing SQL commands to stdin), but people were afraid o
465.
▲
by
sgarland
1y ago
> But then again, Aurora is pretty awesome Why do you like Aurora? Genuinely curious. Here's my list of pros and cons, after having used Aurora MySQL. Pro: Buffer pool persistence after restart is admittedly a very cool trick. That&
466.
▲
by
sgarland
1y ago
I replied above with some problems I experienced, but this question is slightly different, so I'll add more here. IME - both at a place using active-active, and at places that suggested using it - the core issue is developer competency
467.
▲
by
sgarland
1y ago
To clarify, I was working with 2nd Quadrant BDR (now Enterprise DB Postgres Distributed), running on some extremely large EC2 instances, in a global mesh - IIRC, five regions. Also in fairness, EDB told us that we were the largest mesh they
468.
▲
by
sgarland
1y ago
> There are some systems that claim to beat CAP but they typically have caveats and assurances that are required. If by “caveats and assurances,” you mean “relax the definitions of CAP,” then yes. CAP, in its strict definition, has been
469.
▲
by
sgarland
1y ago
I got a patch to Debian’s vixie-cron accepted [0], which thus far has been my proudest achievement. It’s tiny and stupid, and should never happen to anyone reasonable, but nevertheless, you can now change your server’s TZ without restarting
470.
▲
by
sgarland
1y ago
You do not want multi-master. If you think you do, think again. Source: I have operated a large multi-master Postgres cluster.
471.
▲
by
sgarland
1y ago
I tried a bike once, and that was enough. My brother had an R6, and since we were both idiots, he encouraged me to give it a try. It was on that day that I discovered that their brakes are thankfully equally potent as their engines. I finis
472.
▲
by
sgarland
1y ago
uv has done for Python what Docker did for containers. Could you accomplish what Docker did with OS primitives like cgroups? Of course. Do most devs know what those are, much less how to use them? Doubtful. I consider myself to be fairly go
473.
▲
by
sgarland
1y ago
Thank you for the sincere and in-depth response. I hadn't really meant mine to be troll-esque, but I can see how it could come across that way. My favorite comparison of two sites from the same place is HAProxy: haproxy.com is the one
474.
▲
by
sgarland
1y ago
Rebuttal / question: what about Web1.0 sites that still exist? Is the subconscious connotation that they’re dated also carrying an air of wisdom? Or do the people using them simply not care? Personally, I feel as though I fall into the
475.
▲
by
sgarland
1y ago
Thanks for this. I want to clarify something: the “you” in my post was directed at users of a product like this, not you, the creator. Re: lower friction, you’re probably correct, though that also brings with it concerns like those that I p
476.
▲
by
sgarland
1y ago
This does not solve the problem of knowing what you’re doing. If anything it makes it worse, because you think you understand it.
477.
▲
by
sgarland
1y ago
I get the appeal, but am also horrified at the “let’s pipe scripts to bash with sudo,” and the lack of visibility into what the DB is doing. I am a huge proponent of running your own, but along with that comes a responsibility to know wha
478.
▲
by
sgarland
1y ago
And I don’t understand the glorification of consultancy firms like Deloitte. They’re grossly overpaid MBAs, not deep experts in your niche field.
479.
▲
by
sgarland
1y ago
Better idea: the U.S. could adopt the income tax practices of most other countries, where the revenue service tells you what you owe, instead of making you guess. No need for A.I. or Intuit.
480.
▲
by
sgarland
1y ago
Postgres doesn’t have unsigned column types out of the box. There’s an extension that enables it, but you’d have to know about that (which you should, if you’re managing a DB, but I digress). MySQL does have unsigned ints out of the box, FW
More ›