How to Efficiently Choose the Right Database for Your Applications

Re:How to Efficiently Choose the Right Database for Your App... by sradman on Sunday February 28, 2021 @05:55AM (#26292413)

SQLite is ubiquitous as an embedded database in client-side apps, especially iOS and Android. This ubiquity and simplicity make it a viable alternative to PostgreSQL during development. This is why all popular ORM/QueryBuilder frameworks support SQLite and fits with your appreciation of it.

SQLite as an embedded server-side database requires extra work and configuration to make it a viable alternative to PostgreSQL. It lacks good write concurrency and recoverability by default. It is, however, continually improving but gaps remain.

Since it does not have a wire protocol, SQLite is rarely connected to a data warehouse via ETL so it does not fit well as an alternative to TiDB.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by wayneftw on Sunday February 28, 2021 @10:06AM (#26293865)

> SQLite as an embedded server-side database requires extra work...

No, it depends on the server application. An all-read or read-mostly server requires nothing special. Same for any server that expects a low number of users or database per user(s).

Mozilla uses it on servers for documentation sites. You can also run your own Firefox sync server using SQLite.

[ Parent | on HN ]