gavinray

31 ms·

631.
by gavinray 3y ago
It's worth noting that the author is also the same person who gave the talk "Modern B-Tree Techniques" at Strange Loop, which is sort of the de-facto overview of B-Tree's as they relate to databases in modern times. htt
632.
by gavinray 3y ago
Postgres has a datatype and search operators that work natively like this: https://www.postgresql.org/docs/current/ltree.html For instance: CREATE TABLE test (path ltree); INSERT INTO test VALUES ('Top&
633.
by gavinray 3y ago
Whoever thought that the idiomatic approach to "Hello, World!" in their language ought to involve using special overloaded operators as symbols to act on pipes must've been on something very strange.
634.
by gavinray 3y ago
Hey just a thought: 16 years is a long time, many of those shell dashboard sources are probably lost. It'd be interesting to upload them somewhere as a "historical museum" of sorts.
635.
by gavinray 3y ago
I have a burning desire to know what was going on here -- fascinating.
636.
by gavinray 3y ago
Absolutely brilliant I used to do the same with school report cards, which began being delivered electronically when I was in Middle School ;^)
637.
SQLite Jsonb Support Landed(sqlite.org)
2 points by gavinray 3y ago|0 comments
638.
by gavinray 3y ago
This is essentially Hasura without a networked API or the ability to make queries that do cross-datasource joins
639.
by gavinray 3y ago
In the most non-inflammatory way possible: I am not sure I'm convinced of the performance benefits of crossing a JNI boundary to invoke a method in another language, versus letting the JVM JIT and optimize native JVM code. Would be int
640.
by gavinray 3y ago
I always enjoy reading stuff written by Andrey, he's a brilliant fellow for sure. Can highly recommend his personal blog as well: https://puzpuzpuz.dev/
641.
by gavinray 3y ago
There are like, 10 common databases and I would put Clickhouse up there right under the classics like MySQL/Postgres/Oracle/MS-SQL.
642.
by gavinray 3y ago
> Continue being the fastest systems language possible. If you want to be pedantic -- in theory C++ can never be the fastest systems language possible because of the language's rules about aliasing. You'd need to smat
643.
by gavinray 3y ago
Honestly, the changes in C++ 20 and 23, plus the upcoming changes for 26 (looking at you, Concurrency TS v2) have so drastically improved the language it's almost like the ES5 -> ES6 evolution of JavaScript. I might be in the minori
644.
by gavinray 3y ago
When I was a teenager I had an idea: If you rolled marbles down a hill, assuming that identical starting conditions were applied each time, then the marbles' paths and final position would be the same each time. This also implies that
645.
by gavinray 3y ago
Absolutely nothing, this is a "sausage being made" sort of thing.
646.
by gavinray 3y ago
But doesn't that mean that at least nationally, it's essentially a money printing machine? Because this is my layman's conception of how media licensing works, at least.
647.
by gavinray 3y ago
I guess I just assumed that now that he had the proper credentials, he could go a get a job with them? I'm not sure what your economy and job market are like in Australia right now, maybe this is a misguided assumption. Also, in Americ
648.
by gavinray 3y ago
Do people really have such a violent reaction to using ~100MB of disk space for one of the most advanced compilers in the world? I have 2TB of internal SSD storage on my laptop, and I can buy extra TB's for $50 each. Why on earth would
649.
by gavinray 3y ago
What? I mean, there are specific sizes that will fit in the L-(N) cache. And consequently, sizes that don't suffer from the false-sharing problem in concurrent scenarios due to this. https://en.cppreference.com/w/c
650.
by gavinray 3y ago
In Australia, you have laws that force employers to pay you a minimum wage based on your recognized certifications/credentials? Wild. That's pretty fortunate for employed people (IE, you have a tangible and well-defined path to a
651.
by gavinray 3y ago
I've had good experiences with OptaPlanner: https://www.optaplanner.org/
652.
by gavinray 3y ago
IDA Free has essentially all the features of Pro nowadays, if you're only looking to do x86_64 on Windows/Linux. https://hex-rays.com/ida-free/ The only thing you lose out on is Python scripting, which is kin
653.
by gavinray 3y ago
On an unrelated note, could I ask your opinion? My wife is passionate about film/TV production and VFX. She's currently in school for this but is concerned about the difficulty of landing a job afterwards. Do you have any recommen
654.
by gavinray 3y ago
Yeah I am not sure what the difficulty is tbh, but I know nothing about codecs and media encoding. The FR issue is here, by the way: https://github.com/HandBrake/HandBrake/issues/4640 Thanks for the suggestio
655.
by gavinray 3y ago
Can anyone ELI5 why Handbrake says they can't implement a "target file size" option? I use an Android video compressor that does this fairly well. But on the FR for this on the Handbrake GH one of the maintainers says it&#x27
656.
by gavinray 3y ago
Lots of platforms have a maximum file share size. For instance, if you want to post a video to Discord, you have a ~50MB cap unless you pay like $10/mo I use Handbrake to compress videos over that cap. I could post it to YouTube but I
657.
by gavinray 3y ago
> This is powered by a modified version of the Postgres planner that runs as part of the pganalyze app. This modified planner can generate EXPLAIN-like data from just a query and schema information - and most importantly, that means
658.
by gavinray 3y ago
From what I've heard from ex-FAANG, I'd wager that a significant portion of the Go is code-generated for things like RPC definitions or service skeletons.
659.
by gavinray 3y ago
Server-driven UI is a thing that's been gaining traction in recent years. To my knowledge, at least a few FAANG companies have adopted this for the reasons mentioned in the article (AirBnB, Lyft, Expedia) https://github.com&
660.
by gavinray 3y ago
Hmm, okay fair enough

More ›