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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for stream_sqlite-0.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b9bca4d74efad24f507237af94b47dee8a23ac7809dd771fc517b020e3f924d0 |
|
MD5 | 344eb0fb8fafb85c2eabe42bf56ce8a0 |
|
BLAKE2b-256 | 49b58731eb116cbab399a0ce75ac8266ea9f132773f9463ea6712e1cfe9bfc68 |