Skip to main content

Python function to extract all the rows from a SQLite database, without loading the entire file into memory or disk

Project description

stream-sqlite

It can read a table from sqlite page(s) Hardcoded database path for convenience

Missing: Parsing sql in sqlite_master to identify the table name and the starting page no checks for consistency between record size and space allocated to the record record overflow handling of NO ROWID tables. For the moment, I always output the row index at the beginning of the record TESTS

Inefficient: use recursion to read a page several useless seek and read in the routines

Wrong: reading of varint using more than 2 bytes (?) use hardcoded page size

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

stream-sqlite-0.0.0.tar.gz (2.2 kB view hashes)

Uploaded Source

Built Distribution

stream_sqlite-0.0.0-py3-none-any.whl (2.4 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