SQLite Forum

"database or disk is full" with in-memory database. Suggested next steps?
Login
Thanks all -- very helpful.

In rqlite, the SQLite database is not the source of truth (the [Raft log](https://raft.github.io) is). So, is there any issue with simply pushing the limit up at start-up to, say, something large like 32GB? Perhaps more? Does SQLite allocate the memory at startup? If not, maybe this would allow folks to use all the memory on the machine (and use other techniques to limit it). But smaller databases would still work fine. Worse case the OS kills the rqlite process (OOM), but that doesn't matter -- the authoritative data is on disk in the Raft log.

A goal of rqlite is simple operation. I can always allow users to increase the limit at the rqlite command line, but it would be great if they didn't have to.

I guess I could just test it myself. Any traps?