sgarland

38 ms·

871.
by sgarland 2y ago
+1 for BunnyCDN. It's fantastic.
872.
by sgarland 2y ago
If you truly reach the limit of vertical scaling with Postgres, 9/10 I guarantee you have some hideously unoptimized schema and queries. The remaining 1/10, I hope, has actual DB experts on staff that know what they’re doing.
873.
by sgarland 2y ago
Bash is bash, zsh is zsh; how are they different? coreutils differs, sure, and I dislike BSD’s implementation of them, but that’s why gnu-coreutils exists.
874.
by sgarland 2y ago
Faced with the option to pay higher costs for incredibly good hardware, or to run any of the many *nix distros, you chose to have meh hardware, and a restrictive OS that is built as a GUI first, terminal a distant second. Just… why.
875.
by sgarland 2y ago
Thank you for the historical context and details!
876.
by sgarland 2y ago
What a lovely sentiment. Fully agree; staying in the terminal for as much as possible makes for far less friction when context-switching.
877.
by sgarland 2y ago
You are a sad minority, IME. I’m right there with you. I extended the uuid library to generate UUIDv7, based off of the RFC. It’s pretty easy to implement, as it turns out. Overruled, because “we don’t want to have to maintain additional co
878.
by sgarland 2y ago
Am I missing something, or is this a fancier string.Template [0]? Don't get me wrong, it looks very useful, especially the literals. [0]: https://docs.python.org/3/library/string.html#template-strin...
879.
by sgarland 2y ago
We have those because people do not know other options exist, or know, and lack the patience to read. By and large, people don't read docs, full stop. This is why you get entire stack traces being dumped into Slack, or error messages t
880.
by sgarland 2y ago
> Look at thus coreutils guide: https://www.gnu.org/software/coreutils/#mailinglists This is for general help. Mailing lists. Can you think of a less productive way to manage this type of information? Sending a
881.
by sgarland 2y ago
For small programs with limited flags, I like (and write them this way) having `--help` simply list the expected syntax, and a brief description of the short and long flags. If I need a pager to read it, it's too long for `--help`.
882.
by sgarland 2y ago
> Hard disagree. Markdown is the way to go. As other child comments have stated, this is entirely subjective, and many would disagree with you (myself included). I live primarily in the terminal, and the ability to seamlessly look up syn
883.
by sgarland 2y ago
You are correct, I missed that. In MySQL, functional indices are implemented as invisible generated virtual columns (and there is no vector index type supported yet that I'm aware of), but Postgres has a more capable approach.
884.
by sgarland 2y ago
I think they’re about the same in complexity, other than that Postgres offers more options. MySQL did have logical replication long before Postgres, so I’ll give it that. Postgres has one option for replication that is a godsend, though: co
885.
by sgarland 2y ago
Tbf everything you mentioned, MySQL also has (in the latest version, for vectors). But either way, the answer is simplicity and cost. I assume you’ve heard of Choose Boring Technology [0]? Postgres is boring. It’s immensely complex when you
886.
by sgarland 2y ago
The advantage is when you want to store something for ease of use, but don’t want the disk (and memory, since pages read are loaded into the buffer pool) hit. So here, you could precompute the vector and index it, while not taking the doubl
887.
by sgarland 2y ago
Yes (very exciting!), but you won’t be able to index them, and that’s really where they shine, IMO. Still, I’m sure they’ll get there. Maybe they’ll also eventually get invisible columns, though tbf that’s less of a problem for Postgres as
888.
by sgarland 2y ago
Sorry you’re being downvoted; you are correct. I love Postgres, but devs absolutely flock to it because influencers said to. At a job a while ago, my team put out a poll asking for devs opinions and reasons for their preferred RDBMS. Every
889.
by sgarland 2y ago
If only Postgres had Virtual Generated Columns. Not being snarky; MySQL has had them for ages, and they are a perfect fit for this: takes up essentially zero disk space, but you can index it (which is of course stored). It is, in my mind, t
890.
by sgarland 2y ago
They’re common issues with any SQL RDBMS, period. Don’t UPDATE the PK if you don’t need to, don’t paginate with OFFSET, batch your INSERTs. The other shown problem (multiple JOINs with GROUP BY having a relatively high ratio of rows read to
891.
by sgarland 2y ago
Except you can use AI (against the rules, but there is 0% chance they’re catching everyone) for a degree. The only way to be sure that I know of is to ask questions in-person. They don’t have to be absurd, just things that you should be a
892.
by sgarland 2y ago
Pointers are not a difficult concept.
893.
by sgarland 2y ago
> Improved performance across every dimension we’ve tested, which we attribute to six improvements to the Hatchet architecture: range-based partitioning of time series tables, hash-based partitioning of task events (for updating task sta
894.
by sgarland 2y ago
Some of this doesn’t make sense. If you have common settings that you always want enabled, like sql_mode, then set it on the server’s config, and stop wasting time doing so on every session. If you do need some session-specific variables,
895.
by sgarland 2y ago
LOL yes. I have diagnosed and treated ADHD, and my therapist suspects (but it is currently undiagnosed) that I am autistic. Super fun times.
896.
by sgarland 2y ago
I had that mindset, but then an overwhelming amount of personal and work stress made me change. Unfortunately, as I wrote in a comment further up, now I feel like I’m too far on the other side, where all I do after work is relax. If anyone
897.
by sgarland 2y ago
My current problem is that I feel like I’m only barely managing to not completely burn out via relaxation at night. I used to have a ton of excitement over my side project, but for the past several months, I can’t muster the energy. I play
898.
by sgarland 2y ago
It’s because by and large, web devs do not know computing fundamentals, because they’ve had no reason to learn them. If your language handles memory management for you, why would you learn about it? If poor performance in your app can be de
899.
by sgarland 2y ago
Did you see [0] above, from crudbug? They listed a few. [0]: https://news.ycombinator.com/item?id=43588786
900.
by sgarland 2y ago
Just don’t do something stupid like changing system Python, because it will silently fail. I learned this the fun way, by inheriting someone else’s travesty of a setup (spoiler: if you have to hardlink random shared libraries to get stuff t

More ›