4 ms·
Yes! It kinda happened because I had no idea how SQLite worked so I thought this was normal. Then I thought this is great and makes it easier to move the db fi
by pieterhg 4y ago
Yes! It kinda happened because I had no idea how SQLite worked so I thought this was normal.
Then I thought this is great and makes it easier to move the db file if it just has 1 table. So I can download it easily for local dev for ex.
And yes in case there's corruption which never rly happens, only one file thus table would be affected.
PS: one thing that really helped reduce issues was setting PRAGMA MODE to WAL