Remix.run Logo
SQLite on Git, Part II: Unlocking Zlib's Less Known Feature(blog.lysk.tech)
4 points by mlysk 6 hours ago | 1 comments
mlysk 6 hours ago | parent [-]

Part 2 of my blog series on running SQLite databases directly on Git storage.

This post explores how to use zlib's Z_FULL_FLUSH flag to enable random access in Git's compressed objects, making it possible to read subsets of large files without decompressing the entire object.

Prologue: https://blog.lysk.tech/sqlite-on-git-prologue Part 1: https://blog.lysk.tech/sqlite-on-git-part-1

Github repo: https://github.com/martin-lysk/talepack