SQLite on Git, Part II: Unlocking Zlib's Less Known Feature

Posted by mlysk on Monday April 06, 2026 @07:32AM
from the blog.lysk.tech dept.

https://blog.lysk.tech/sqlite-on-git-part-2/

( 1 comment | 3 points | on HN )

Re:SQLite on Git, Part II: Unlocking Zlib's Less Known Feature by mlysk on Monday April 06, 2026 @07:32AM (#47659556)

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

[ Parent | on HN ]