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

SQLite on Git, Part II: Unlocking Zlib's Less Known Feature(blog.lysk.tech)

6 points by mlysk 42 days ago | 1 comment

mlysk 42 days ago |

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