More SQLite!
Multithreading for Sqlite, plus expression composition
Multi-threaded Sqlite
This module wraps the sqlite3.connection with thread-safe traffic manager. Here is typical usage:
from mo_sqlite import Sqlite
db = Sqlite("mydb.sqlite")
with db.transaction() as t:
t.command("insert into mytable values (1, 2, 3)")
While you may have each thread own a sqlite3.connection to the same file, you will still get exceptions when another thread has the file locked.
Pull JSON out of database
This module includes a minimum experimental structure that can describe pulling deeply nested JSON documents out of a normalized database. The tactic is to shape a single query who's resultset can be easily converted to the desired JSON by Python. Read more on pulling json from a database
There are multiple normal forms, including domain key normal form, and columnar form; these have a multitude one-to-one relations, all represent the same logical schema, but differ in their access patterns to optimize for particular use cases. This module intends to hide the particular database schema from the caller; exposing just the logical schema.
This experiment compliments the mo-columns experiment, which is about pushing JSON into a database.
1 maintainer
Metadata
1 maintainer
Release files for mo-sqlite 2.673.25037
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| mo_sqlite-2.673.25037.tar.gz | 26.4 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| mo_sqlite-2.673.25037-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 66.6 kB
Release files / mo_sqlite-2.673.25037.tar.gz
| Download URL | mo_sqlite-2.673.25037.tar.gz |
|---|---|
| Size | 26.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
4452f95870a4be77dec5555516fdc37f7a2fd98f0d73fb434af3654d119cccd0
|
|
BLAKE2b-256 checksum How to use checksums |
bcf8a64b14785c93e209d7a5b5adaec503eebcef337c2587e2f7515c068d0c36
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.0.0 CPython/3.9.6
|
Release files / mo_sqlite-2.673.25037-py3-none-any.whl
| Download URL | mo_sqlite-2.673.25037-py3-none-any.whl |
|---|---|
| Size | 40.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
2df50b947b0bb096dd0ef9c1969d193c4ad04ddcf7ffd3dbdd2ac9a9a87d9ae2
|
|
BLAKE2b-256 checksum How to use checksums |
aab1ce277ca1e8684124209f14b45adce0417d9c782f8cd98fea0835a31c6af7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.0.0 CPython/3.9.6
|
Security for mo-sqlite 2.673.25037
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
