Python function to extract all the rows from a SQLite database, without loading the entire file into memory or disk
Project description
stream-sqlite 
Work in progress. This README serves as a rough design spec
Usage
from stream_sqlite import stream_sqlite
import httpx
def sqlite_bytes():
# Iterable that yields the bytes of a sqlite file
with httpx.stream('GET', 'https://www.example.com/my.sqlite') as r:
yield from r.iter_bytes(chunk_size=65536)
# A table is not guarenteed to be contiguous in a sqlite file, so can appear
# multiple times while iterating
for table_name, table_info, rows in stream_sqlite(sqlite_bytes()):
for row in rows:
print(row)
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
stream-sqlite-0.0.2.tar.gz
(4.7 kB
view hashes)
Built Distribution
Close
Hashes for stream_sqlite-0.0.2-py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | f07967fa36151a7185496d4b2a3dc9b65ebf74ab962dc5d0e6e1ca28f5accc73 |
|
| MD5 | 836d0e74cb66a92144746e5eca488e0b |
|
| BLAKE2b-256 | 99d419298a848bb83b061147d40cfa4f58288bf77fa52b46f95cf3fd3a252767 |
