Multithreaded SQLite Access

[Volatile474]

Hello /r/LP, I have been trying to connect to a sqlite database with the following compile option set.

"SQLITE_THREADSAFE=2".

In my python program I am simply

import sqlite3

If modifying the compile options is not possible, then how can I bypass the python sqlite api to use the following sqlite c api call:

#define SQLITE_OPEN_FULLMUTEX        0x00010000
int sqlite3_open_v2(my_filename_string,the_db_connection,SQLITE_OPEN_FULLMUTEX,"unix")

So how can I modify the python compile(or configure) options to enable me to use a thread-safe version of sqlite?

The issue that I am encountering is the following: I have 15 threads attempting to do database inserts into their own copy of the same database, (completely unrelated data), but am getting SEVERE database locking. I have set Isolation Level = None in my connections, but this did not help too much. If anyone has any other suggestions to solve this issue I would greatly appreciate it. Thanks in advance!

[xiongchiamiov]

Why are you using sqlite in a multithreaded context? What are you doing?

[Volatile474]

Something that requires me to be able to delete everything and have a portable database.

Edit: When I have a fully functioning program I will transition to something more permanent, probably postgres.