4 ms·
I'm missing something as easy to deploy as SQLite, but without its performance problems (like the stop-the-world write lock). Basically, I'd love an embeddable
by pornel 5y ago
I'm missing something as easy to deploy as SQLite, but without its performance problems (like the stop-the-world write lock). Basically, I'd love an embeddable Postgres with a single-file storage.
- psanford 5y agoIf you are using SQLite and care about performance, be sure to run in WAL (Write Ahead Log) Mode: `PRAGMA journal_mode=WAL;`[0]. WAL mode is significantly faster and does not have a "stop-the-world write lock" ("Reading and writing can proceed concurrently"). WAL mode is also more efficient with disk I/O, which makes it faster for single user applications as well. [0]: https://sqlite.org/wal.html https://sqlite.org/wal.html
- sterlinm 5y agoCheck out DuckDB https://duckdb.org/ https://duckdb.org/
- goughy 5y agoThis: https://firebirdsql.org/ https://firebirdsql.org/