SQLite SRFI Lassi Kortela 29 Aug 2019 06:08 UTC

> 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.