I'm calling it now. Captain Dissolution will debunk this.
...what is there to debunk?
Readit Newstaurknaut commented on Representing Graphs in PostgreSQL richard-towers.com/2025/0... · Posted by u/gsky
Im a big fan of GraphDatabase's since about 10 years. I even wrote my own "in memory graph storage" in golang for a specific use case that none of the big GraphDatabase's could cover at the time.
That said - i WISH people would embrase the existing GraphDatabases more and make the hosters support them as standard, rather than abusing existing relational databases for graph purposes.
And to make it clear,i'm not talking about my own experimental one, i mean stuff like Neo4j, OrientDB etc.
> rather than abusing existing relational databases for graph purposes.
In my experience, the vast majority of graphs can be embedded in relational databases just fine and most people don't want general graph querying. People just don't like optimizing queries (or equivalently the schema to enable such queries).
I personally have never seen a pitch for graph databases that makes them seem attractive for more than data exploration on your local machine.
The binary would only contain the database engine; not the database. It’s probably a few MB, if I had to guess.
Presumably the database needs to be distributed to servers, too. The engine needs to access something. This is a necessity whether or not it's referred to as a binary.
I'd consider no relational db scales reads vertically better than SQLite. For writes, you can batch them or distribute them to attached dbs. But, either way, you may lose some transaction guarantee.
Reading without write contention is not a terribly difficult problem. You could use any database and it'd work fine. It's the mutations that distinguish db engines. Sqlite is indeed close to ideal but the comparison to other databases (at scale no less) is without substance.
Fascinating read. Those suggesting Mongo are missing the point.
The author clearly mentioned that they want to work in the relational space. Choosing Mongo would require refactoring a significant part of the codebase.
Also, databases like MySQL, Postgres, and SQLite have neat indexing features that Mongo still lacks.
The author wanted to move away from a client-server database.
And finally, while wanting a 6.4TB single binary is wild, I presume that’s exactly what’s happening here. You couldn’t do that with Mongo.
This comment appears to be the only place between article and thread where mongo getting recommended is even mentioned. Maybe stop giving them free press. I certainly haven't heard anyone seriously suggest them for about about ten years now.
Edit: ok the other guy mentioning mongo is clearly being sarcastic
> assholes pitching bull markets
Totally willing to believe I’m just naive about this; I don’t see what “bull market vs. bear market” has to do with the running of the bulls festival.
I imagine the original use of "bull market" was derived from this practice. If this isn't the case i have no clue myself.
taurknaut commented on AI can interpret animal emotions better than humans science.org/content/artic... · Posted by u/marojejian
Gallaudet University has the video archives.
Here is one of many:
https://media.gallaudet.edu/channel/Videolibrary+Archive/158...
I'm very aware of these archives. They are very clearly not sufficient to train a model to interpret asl to the standards of corporate america. Let alone the standards of an arbitrary human. Hence my above post.
taurknaut commented on Uchū – Color palette for internet lovers uchu.style... · Posted by u/NetOpWibby
What would this example page have on it? Do you have a favorite layout?
I imagine at least something mapping each color to what it applies to.
Haters will say dis/misinformation makes it not worth it, but i simply point out that it's the truly stupid people who speak the loudest and you need to look deeper. There's no going back to a world where for-profit media is above critique. The relentless violence in palestine firmly endorsed and enabled by western media has pretty much destroyed any faith I had that our for-profit media is capable of self-regulation. Dunking on these morons is a public good.
What we really need to figure out is a way to systemically encourage punching up, not down.