3 ms·
I don't think there is a modern database that have the safest options all turned on by default. For instance the default transaction model for PG is read commit
by Thaxll 10mo ago
I don't think there is a modern database that have the safest options all turned on by default. For instance the default transaction model for PG is read commited not serializable
One of the most used DB in the world is Redis, and by default they fsync every seconds not every operations.
- hobs 10mo agoPretty sure SQL Server won't acknowledge a write until its in the WAL (you can go the opposite way and turn on delayed durability though.)
- hxtk 10mo agoCockroachDB is serializable by default, but I don’t know about their other settings.
- deleted 10mo ago[deleted]
- andersmurphy 10mo agoSQLite is alway serializable and by default has synchronous=Full so fsync on every commit. The problem is it has terrible defaults for performance (in the context of web servers). Like just bad options legacy options not ones that make it less robust. Ie cache size ridiculously small, temp tables not in memory, WAL off so no concurrent reads/writes etc.
- jwr 10mo agoFoundationDB provides strict serializability by default.