HN user

mlysk

117 karma
Posts5
Comments21
View on HN

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

Author here: I use mermaid lot as well and for some things like process flows, and to model interactions it it outrules excalidraw and posts will follow where i need exactly that. but to visualize things high level i find excalidraw way nicer.

I created this out of the frustration that non techies can't collaborate in markdown - and even when collab with techies - i missed annotations, discussions and realtime collab and often switched to googledocs.

Little neat trick. If you like clever tricks and going to get-colibir.com, copy paste the url and press a button is still to cumbersome:

replace the g in any github.com url with TUNE:

https://github.com/Legit-Control/get-colibri/ -> https://TUNEithub.com/Legit-Control/get-colibri/

I was thinking about something like that a lot. The anchoring is the hard part. One direction i was thinking in: store the commit sha within the anchor. this could allow "reanchor" based on changes in some sense. For get-colibri.com (project i am working on) I am currently considering inline html comments ai <-> human communication.