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.583.24095.tar.gz (26.0 kB view hashes)

Uploaded Source

Built Distribution

mo_sqlite-2.583.24095-py3-none-any.whl (39.2 kB view hashes)

Uploaded Python 3

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