3 ms·
SQLite is an embedded database so you wouldn’t really want that. Postgres is fine for database servers, SQLite is for program-embedded local databases.
by ok_dad 4y ago
SQLite is an embedded database so you wouldn’t really want that. Postgres is fine for database servers, SQLite is for program-embedded local databases.
- Gigachad 4y agoI don't think anyone has questioned sqlite for local databases. But there is a lot of talk around using sqlite for web app databases where it may work, but seems clearly inferior to any of the alternatives.
- Aperocky 4y agoDepend on what size the webapp is. sqlite.com seems a pretty good cut off traffic volume, I would guess between 95-99% of all web apps are probably consistently getting less traffic than sqlite.com
- chrsig 4y agois sqlite.com a dynamic site? it seems like it's static html
- Aperocky 4y agosupposedly they are powered by sqlite, so it has to be read somehow. Though a cache may have been what most of the traffic is hitting.
- rawoke083600 4y agoI read somewhere on their page, each page is done with about 200 queries.
- SQLite 4y agoThere is a lot of static content on https://sqlite.org/ https://sqlite.org/ but also a lot of SQLite-backed dynamic content. I just checked the logs. Over the past 5 days, 12.03% of non-robot HTTP requests were against dynamically generated pages. Most of the dynamic content is generated by the version control system, Fossil (https://fossil-scm.org/ https://fossil-scm.org/). For example: https://sqlite.org/src/timeline https://sqlite.org/src/timeline or https://sqlite.org/forum/forum https://sqlite.org/forum/forum Fossil is hosted on the same machine as SQLite. Fossil is self-hosting and the Fossil website is 100% dynamically generated. Every HTTP request against https://fossil-scm.org/ https://fossil-scm.org/ does about 200 SQLite queries (give or take - depending on the page).