movq

Wherein I Move A Lot of Words Around

Sqlite

SQLite, Python, and Transactions

I’m working an intermediary library in Python that turns a fair number of normal databases and database-like stores into simple key-value stores. There’s a long story of why, but it does it have an actual use case outside of “because I can” (though, the symlink backend is pure, unadulterated “because I can”).

For the SQLite store I was running into transaction issues here and there. At seemingly-random times data wouldn’t save or I’d get an error saying a transaction hadn’t been started when I tried to commit. So, I did some research.