2022-10-04
🔗Implemented job insertion on Effectum today. I tried to be clever at first and prepare all the queries in advance when the Queue is created, but ran into issues where prepared rusqlite statements are not Send. That's ok though. The rusqlite prepared statement cache is close enough.
Links
- LibSQL is a new SQLite fork. Whereas SQLite famously does not accept outside contributions, LibSQL is approaching it from a more community-based open source viewpoint. They're aiming toward some more "modern" features such as support of io_uring and perhaps WASM user-defined functions. We'll have to see how this turns out. SQLite's strict development process has also lead to a famously stable product, and I expect that it will be difficult to keep that same level of rigor. Still, if this picks up steam it could be quite promising.