> I continue to believe that a SQLite-specific SRFI, independent of any
> database-independent SRFI, is a Good Thing. Simple and straightforward
> local ACIDity is something every Scheme programmer shoulc have access
> to
I agree.
Another fortuitous quality of SQLite for Schemers is that it's not
strict about data types. Table rows store dynamically typed values, and
the column's SQL type is just a hint for implicit type conversions.
> and it has virtual-table plugins for a whole bunch of other formats
> as well.
<https://sqlite.org/vtab.html>
Had no idea about that. They've added a lot of features.
There's now a "server-process edition" as well:
<https://sqlite.org/src/artifact/0c6bc6f55191b690>
Not quite sure what that means specifically but people are raving about
it: <https://news.ycombinator.com/item?id=17766799>
Also, more fsync() goodness in that thread :) I'm so glad it's not our
problem anymore.