With that said, PHP has sqlite support built in since 5.0 and sqlite3 since 5.3 so I see no reason to use this over that. Maybe the author can elaborate.
I remember writing code to do stuff like this in C way back when because there were literally no other choices.
Also, why is this on Hacker News?
Edit: I do, however, applaud any effort to contribute to the open source community. However, for anyone to trust this they would need unit tests and a composer package on Packagist.
Well, not great, but usable. The write method is not reliable for asynchronous operations.
Aside from that, I'm leery of Hacker News being a place where brand new open source contributions gets submitted (regardless of quality). There are other places for that.