3 ms·
SQLite is great. But the simple fact that it runs locally makes it a poor technical fit in many scenarios.
by mypalmike 4y ago
SQLite is great. But the simple fact that it runs locally makes it a poor technical fit in many scenarios.
- forinti 4y agoFor every technology there are scenarios in which it is a poor fit. You don't want to install Postgresql or Oracle on an embedded system nor would you want the extra weight of administering them for a system that has few users. The SQLite site runs on SQLite and it has considerable traffic.
- sgbeal 4y ago> The SQLite site runs on SQLite and it has considerable traffic. The forum and source code trees run on sqlite (via the Fossil SCM, authored by sqlite's Richard Hipp). The main sqlite site is static HTML with a tiny sprinking of JS.
- simonw 4y ago"But the simple fact that it runs locally makes it a poor technical fit in many scenarios" MySQL and PostgreSQL can run locally too. I assume you mean that SQLite doesn't provide a network server interface out of the box?