sgarland

44 ms·

961.
by sgarland 2y ago
What sibling comment said. Planet Earth is probably the most famous series, and for good reason, but Netflix also has a bunch of others he’s narrated that are quite good. I also really liked Dancing With The Birds, with Stephen Fry, but tbf
962.
by sgarland 2y ago
Anecdotally, this isn’t surprising. I’ve always enjoyed nature documentaries, and since getting a large TV and decent sound system, I really enjoy them. They’re very calming to watch as a winding-down activity at night.
963.
by sgarland 2y ago
Outstanding! I’m consistently impressed by PlanetScale knowing WTF they’re doing, and fighting against the constant propaganda from the hyperscalers about what their offerings are capable of. High IOPS with high latency is useless. It’s a s
964.
by sgarland 2y ago
It is indeed, but I’ll be the first to admit it’s a bit clunky to use beyond a few variables and actions. Sorry for snapping. I’m exhausted with devs complaining that some older and well-established piece of tech (Postgres, HAProxy, nginx t
965.
by sgarland 2y ago
That is described in the link, in section 36.18, albeit for C. If you have another language, i assume you get to figure out how to make it work. [0]: https://www.postgresql.org/docs/current/extend-pgxs.html
966.
by sgarland 2y ago
Frankly, I think devs need to stop being such primmadonnas about DX. Not everything has a slick UI that does most of the work for you. Take Linux, for example: you have to email your PR as a patch, inline as plaintext to a mailing list. Yet
967.
by sgarland 2y ago
You already can [0]. C, PL/Perl, PL/Python, and PL/Tcl exist out of the box, in addition to PL/pgSQL, which I assume you were implying isn’t a “real programming language.” [0]: https://www.postgresql.org/
968.
by sgarland 2y ago
I would much rather this than letting devs write their own queries, ORM or not. But then, I own the DBs, and I am constantly dealing with the result of poor schema and query decisions.
969.
by sgarland 2y ago
I’ve consistently found Aurora MySQL and PG to be slower than everything, including my 12 year old Dell R620s. You can’t beat data locality, and the 4/6 quorum requirement of Aurora combined with the physical distance kills any hope of
970.
by sgarland 2y ago
I continue to find horror shows during incidents; sometimes not even the cause, merely a tangential rabbit hole I wandered down. “Are you… are you storing images in BLOBS?” “Yes. Is that bad?”
971.
by sgarland 2y ago
I mean no disrespect, but it is stunning how hard the idea of owning your own hardware is to a large percentage of the tech population. You can just… own servers. I have five in a rack in my house. I could pay a colo a relatively small fee
972.
by sgarland 2y ago
That's fair; it is significantly heavier - 360g according to their tech specs. An M1 is still no slouch, especially if you have higher than the base RAM spec. The other reason I went with (or eventually got to, anyway) a MBP was the na
973.
by sgarland 2y ago
With respect, the core issue here is you lacked a basic understanding of Linux, and this is precisely the problem that many people — including myself – have with LLMs. They are powerful and useful tools, but if you don’t understand the fu
974.
by sgarland 2y ago
Yes, it was. Previously, I had an XPS 13” that was pretty decent, and then an Intel Air, which was even better. I bought an M1 Air, base model, at launch, and was blown away. For once, a manufacturer wasn’t lying about battery life. What Ap
975.
by sgarland 2y ago
I think we’re agreeing; I said I loved my M1 Air even more than my 2013 Intel Air. The M1 still had the wedge, they lost it with the M2.
976.
by sgarland 2y ago
I am so upset that Apple nixed the wedge Air. I loved my 2013 Air, and much more so, my M1 Air. Once they lost the wedge, and especially when the MBP got a 14” option, I lost interest. 14” is the absolute perfect size for a laptop, IMO.
977.
by sgarland 2y ago
If that; I’ve met plenty who only care that they work, not how they work. As someone who works in infra and dabbles in coding, this is a continual bugbear, because often I’ll find an optimization while troubleshooting “my” problem, and
978.
by sgarland 2y ago
Yes, I found a loop performance regression [0] in 3.12 and 3.13. [0]: https://github.com/python/cpython/issues/123540
979.
by sgarland 2y ago
I remember the day we got 56K from our ISP. Our modem was 56K (no idea what model, some internal WinModem), but the ISP was limited to 33.6K. Then one day, the connection screech sounded different, and I excitedly pointed this out. Several
980.
by sgarland 2y ago
Postgres has Bloom filters: https://www.postgresql.org/docs/current/bloom.html It also has arrays, sets, and bitstrings, though for the latter you can just as easily (and with less space consumed) map it in your a
981.
by sgarland 2y ago
Or when the devs don’t want to rewrite their schemata in a way that would massively reduce I/O requirements. Then when you lose a cache node, the DB gets slammed and falls over, because when the DB team implemented service-based rate-l
982.
by sgarland 2y ago
> 'Why can't we just store this data on the shards in PostgreSQL, next to the swipes?'. The data itself would be microscopic in comparison and the additional load would also be microscopic in comparison to what these serve
983.
by sgarland 2y ago
A well-designed schema in a properly-sized-and-tuned [MySQL, Postgres] instance can and will execute point lookups in a few hundred microseconds. That said, I agree that if you need a KV store, use a KV store. Though of course, Postgres can
984.
by sgarland 2y ago
EDIT: The site no longer exists, it seems. The project (which is not my creation) was a regularly-updated dump of all GitHub metadata (PR comments, Issues, etc.). Here's an archive snapshot: https://web.archive.org/web&
985.
by sgarland 2y ago
Yep. I used it once for a personal project involving GHTorrent [0], and each query was about $20. That may be peanuts for a business, but for someone playing around on their own, it's incredibly prohibitive. [0]: https://g
986.
by sgarland 2y ago
> Basically we started to collected detailed analytics and thus had a rapidly growing table of around 2B records of user events during their sessions. As it grew past a 500 million records it turned out to be impossible to query this tab
987.
by sgarland 2y ago
What gave me pause was when my base-spec M1 Air handily beat my admittedly old server (Xeon E5-2650v2) on a single-core compute-bound task [0] (generating a ton of UUIDs). I know Ivy Bridge is 12 years old at this point, but I didn’t expect
988.
by sgarland 2y ago
Of course it is. It’s the same reason the media touts the horror stories of lengthy wait times for public healthcare, while ignoring the fact that having the theoretical choice without the means is worse.
989.
by sgarland 2y ago
> No one takes the time to fully understand all the PRs they approve. I was appalled when I was being effusively thanked for catching some bugs in PRs. “No one really reads these,” is what I was told. Then why the hell do we have a requi
990.
by sgarland 2y ago
For my one foray into ML, in 2020, I also built my own labeling system. It was stupidly simple; IIRC, it was a Jupyter Notebook that presented you with text to label, and you’d do so by hitting 1-5, which were mapped to sentiments / em

More ›