28 ms·
SQLite is a great database engine. I often wonder if it could even be better without extreme backward compatibility. It could be nice to have Foreign Keys enab
by conaclos 4y ago
SQLite is a great database engine. I often wonder if it could even be better without extreme backward compatibility.
It could be nice to have Foreign Keys enabled by default, and make all tables strict by default. A new binary format that reduces the size of database by leveraging table strictness and type info could also be great.
- ngrilly 4y agoAgreed, but priorities: I think that new high concurrency backend is a more important improvement.