sqlite3worker
sqlite3worker copied to clipboard
palantir
A threadsafe sqlite worker for Python
execute_with_columns method to allow users to retrieve also column names. Maybe a better integration is possible, but it was the easiest and fastest way to do it with a compatibility...
I would like to access column header, but it seems that at the current moment it is not possible, right? Without the library I did it in this way: ```...
I have two tables that I'd like to insert data into. They are joined by a foreign key. I want to put A into the first table, grab its auto-generated...
I am trying to update an existing record, and it seems like the changes are not committed. What am I doing wrong here? ``` >>> from sqlite3worker import Sqlite3Worker >>>...
First of all, I may be mistaken in how this all works, but it seems like all queries are queued and processed serially. Since there is already a conditional for...
I found sqlite3worker extremely helpful to me, and made a number of enhancements that I wanted to share back with the project: 1) dbapi compatible interface that implements enough features...
To apply seemless implementation, you should add the extensions (fetch functions) that are also in the native library. Better memory management and it helps with processing data.
Unnecessary CPU cycles were being wasted in busy waiting happening inside query_results method. Added synchronisation using threading.Event for select queries to improve the performance overall.
