Skip to main content

Multithreading for Sqlite, plus expression composition

Project description

More SQLite!

Multithreading for Sqlite, plus expression composition

PyPI Latest Release Build Status Coverage Status Downloads

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.

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

mo_sqlite-2.626.24125.tar.gz (26.0 kB view details)

Uploaded Source

Built Distribution

mo_sqlite-2.626.24125-py3-none-any.whl (39.2 kB view details)

Uploaded Python 3

File details

Details for the file mo_sqlite-2.626.24125.tar.gz.

File metadata

  • Download URL: mo_sqlite-2.626.24125.tar.gz
  • Upload date:
  • Size: 26.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.0.0 CPython/3.9.6

File hashes

Hashes for mo_sqlite-2.626.24125.tar.gz
Algorithm Hash digest
SHA256 d29e568e8e6a9a3d8d5b2aee8094b53e7f36c7a157f16695da34cbbfcf6beeda
MD5 7b8d23f016868f97ff7c509445ec080a
BLAKE2b-256 4dd1ae33a2a71e8cf8cea447905efc43290a279a0dff6483a500c7e3524ddcfd

See more details on using hashes here.

File details

Details for the file mo_sqlite-2.626.24125-py3-none-any.whl.

File metadata

File hashes

Hashes for mo_sqlite-2.626.24125-py3-none-any.whl
Algorithm Hash digest
SHA256 6192fbbbea03449349ccabebcae72ac62f545e454fd42127d10d664ecc1a7f02
MD5 16b0b1c1df73aa6dcba03ce9489810a8
BLAKE2b-256 c371d646b8961c2c7ea05bc23040599e6390e74cec704f4d53a3d4878202fcb5

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page