How to set PRAMGA for Sqlite
Really not sure how this would be done here. Some of them are permanent but some need to be set on every connection. in my example something like:
PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
PRAGMA mmap_size = 134217728;
PRAGMA journal_size_limit = 67108864;
PRAGMA cache_size = -2000;
Where would i set these?
2 Replies
Some pragmas are session pragmas, others are database pragmas. The database pragmas should go in a migration, and the session pragmas should go at the start of your application or when creation the drizzle object
well i tried to run it with the client before passing it to drizzle but no errors no execution either 🤔
but i guess i gotta check again