Damn, I don't think I've read about most of the site top database...
Maybe I should try to use something different than PostgreSQL, at least in some side projects.
Database of Databases
21–30 of 65 posts
Re: Database of Databases
#22Any good learning resources for implementing your own DBMS, and DB internals? (not DB theory, not SQL, not intro).
https://github.com/rqlite/rqlite
https://github.com/rqlite/rqlite/blob/master/DOC/DESIGN.md
I built a distributed database using Raft and SQLite, and I put a lot of thought into its design and implementation -- to make it as simple (but not simplistic) and clear as possible. One goal was clear separation between the consensus layer, the database access, and the HTTP API. I think it's a good resource to study (even if I do say so myself).
Re: Database of Databases
#23They're using SQLite which is single threaded and single user by design. So this website will not be able to service that much traffic.
Should be fine for reads. Sqlite.org is dynamic, pulling from sqlite data for ~20% of the pages, and it does fine with HN piling on. The single threaded would be an issue for writes, but I don't see why they would be doing writes for a page view. See https://www.sqlite.org/whentouse.html
Well it looks down now.
Re: Database of Databases
#24They're using SQLite which is single threaded and single user by design. So this website will not be able to service that much traffic.
Should be fine for reads. Sqlite.org is dynamic, pulling from sqlite data for ~20% of the pages, and it does fine with HN piling on. The single threaded would be an issue for writes, but I don't see why they would be doing writes for a page view. See https://www.sqlite.org/whentouse.html
Well it clearly wasn't :) Site is down already
Re: Database of Databases
#25Are these websites just completely unable to handle a 1000 simultaneous requests?
Someone should make a database of caches or CDNs. Then combine knowledge! /s
Re: Database of Databases
#26HN Hug of death.
Re: Database of Databases
#27Thought it was some groundbreaking new database technology.... Speaking of, What would an interesting version of "database of databases" look like?
Apparently SQLite. Who would have thought?
Re: Database of Databases
#28Any good learning resources for implementing your own DBMS, and DB internals? (not DB theory, not SQL, not intro).
CMU DB Group has all their lectures on youtube. Checkout 15445 and 15721
https://www.youtube.com/channel/UCHnBsf2rH-K7pn09rb3qvkA
Re: Database of Databases
#29Did anyone else pronounce this like dibby-dibby-yo?
Re: Database of Databases
#30They're using SQLite which is single threaded and single user by design. So this website will not be able to service that much traffic.
I've survived a few HN front pages on SQlite + $5 DO droplet. Don't disparage my primary tech stack like this ^_^
The traffic from a HN frontpage is relatively low per second tbh.