Multithreaded access to a SQLite database

If you use SQLite like me you’ll know that it is amazingly powerful, convenient, and compact. However if you have an app that needs to do a lot of database IO concurrently with SQLite you may run into the fact that it is classically single-threaded and does not give you the guarantees that are present in normal RDBMS systems. Here is a nice writeup of a few of the strategies you can use to perform SQLite reads/writes in a multithreaded app. Worth a read if you use SQLite. Link.

Tagged , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: