SQLite callbacks John Cowan (16 Sep 2019 01:34 UTC)
Re: SQLite callbacks Peter Bex (16 Sep 2019 06:42 UTC)
Re: SQLite callbacks John Cowan (16 Sep 2019 13:51 UTC)
Re: SQLite callbacks Lassi Kortela (16 Sep 2019 13:56 UTC)
Re: SQLite callbacks hga@xxxxxx (16 Sep 2019 15:27 UTC)
Re: SQLite callbacks John Cowan (16 Sep 2019 19:31 UTC)

Re: SQLite callbacks Lassi Kortela 16 Sep 2019 13:56 UTC

> This is part of an argument that an in-process, single-file, zero-admin SQL
> database is a completely different animal from an interface to SQL database
> servers, and deserves its own API, though it should not be *gratuituously*
> different.  The existence of sql-de-lite and APSW (Python) seemed to
> confirm this.  Once you exclude the proprietary, the JVM, and the .NET
> databases, only SQLite and Firebird Embedded are left, and SQLite is far
> more lightweight.
>
> My actual pre-SRFI isn't particularly SQLite-specific, but it's what I
> think of as the MVP; other SQLite-specific features can be added in a later
> SRFI.  If it's useful as a skeleton for a general database server API,
> that's certainly a Good Thing.

I'm sympathetic to John's approach. Are there other SQL databases
besides SQLite that have a similar "dynamic typing" approach (column
types are advisory rather than enforced)?