Is there a limit to the amount of SQLite database storage my custom app can hold? I’m not trying to store a ton of data in there anyway but I just wanted to confirm if there is a limit and if so what it is. I couldn’t find this documented anywhere, so if there is documentation maybe we can link to it in this thread to help someone else find it easier too.
Hi @iansvo. I think the best place to find details on this is within SQLite itself: Implementation Limits For SQLite and the limits are in the billions of rows and hundreds of terabytes.
The main thing to look out for with SQLite is that it does have a “single-writer” where only writer process can be active at a time and there is database locking that happens. So SQLite is really good for read heavy, write light use cases which happens a lot in the Commerce space.