DB-API 2.0 interface for OctoDB
Project description
OctoDB for Python3
This is a wrapper library to use OctoDB on Python 3
It is based on pysqlite3
Additional features: (compared to Python's sqlite3 module)
- User-defined window functions (requires SQLite >= 3.25)
- Flags and VFS an be specified when opening connection
- Incremental BLOB I/O, bpo-24905
- Improved error messages, bpo-16379
- Simplified detection of DML statements via
sqlite3_stmt_readonly
. - Sqlite native backup API (also present in standard library 3.7 and newer).
Installation
You must install some OctoDB library for this one to work. It can be either pre-compiled binaries or you can compile it by yourself. You can start with the free version.
Installing with pip
pip install octodb
Cloning and Building
Optionally you can clone the repo and build it:
git clone --depth=1 https://gitlab.com/octodb/octodb-python3
cd octodb-python3
python3 setup.py build install
Usage
import octodb
import json
import time
conn = octodb.connect('file:app.db?node=secondary&connect=tcp://server:port')
# check if the db is ready
while True:
result = conn.cursor().execute("PRAGMA sync_status").fetchone()
status = json.loads(result[0])
if status["db_is_ready"]: break
time.sleep(0.250)
# now we can use the db connection
...
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
octodb-0.4.10.tar.gz
(40.5 kB
view hashes)
Built Distribution
Close
Hashes for octodb-0.4.10-cp310-cp310-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b122e980911baf3590ca9962841f74f1b2fbb6760acaf2b50edea25a9f3672ca |
|
MD5 | dd4644c2ecef82a65574089c058ee396 |
|
BLAKE2b-256 | 39957850742fd00c049c449fb9523fb7adef16a3e1603d0cb4ddad170b39d45d |