pyrqlite
pyrqlite copied to clipboard
Python (DB-API 2.0) Client for rqlite, the lightweight, distributed database built on SQLite.
This searches for larger (more specific) matches first so that for example `gameid` and `game` get matched independently. I found this operated differently from the sqlite3 library, here's some test...
I get the following error unless I set defaults in datetime columns: ` venv/lib/python3.8/site-packages/pyrqlite/extensions.py", line 111, in 'DATETIME': lambda x: x.replace('T', ' ').rstrip('Z') `
Hello, I just ran into this issue when trying to insert a large amount of rows into an rqlite database using multiple-item INSERTs. Example code: ```python #!/usr/bin/env python3 import pyrqlite.dbapi2...
The plan right now is to implement transaction support in rqlite 5.0. If this work completes, this library should be updated to take advantage of. See https://github.com/rqlite/rqlite/issues/266 for details of...
After implementing most of Python's sqlite3 type extensions, I tried to adapt a Django DB Backend for RQLite based on the SQLite one. But Django' stock SQLite backend [do use](https://github.com/django/django/blob/master/django/db/backends/sqlite3/base.py#L199)...
It would be nice if I could connect to whichever endpoint is online. Something like this: ``` connection = dbapi2.connect( hosts=['db1', 'db2', 'db3'], port=4001, ) ``` Otherwise, endpoint has to...
Is there a way that I can connect to rqlite through a SOCKS proxy? Thanks!
This test fails with pyrqlite as follows: ``` ____________ BinaryConverterTests.test_CheckBinaryInputForConverter ____________ self = def test_CheckBinaryInputForConverter(self): testdata = b"abcdefg" * 10 compressed = zlib.compress(testdata) > result = self.con.execute('select ? as "x...
I'm having difficulty trying to make test_CheckCaseInConverterName and test_CheckColName both succeed simultaneously (though they both succeed with python's own sqlite3 module). ``` =================================== FAILURES =================================== _________________ ColNamesTests.test_CheckCaseInConverterName __________________ self =...