Schema verifier fails in setting DatabaseConfig.doubleQuotedStringLiterals about drift HOT 4 CLOSED

The documentation page about testing does specify that you need to download the binaries yourself https://drift.simonbinder.eu/docs/testing/ but it also doesn't provide any guidance on a minimum version

from drift.

It's extremely reasonable for Drift to rely on SQLite features from 2019. It'd be good for that to be explicit, though.

At the moment we don't have an official minimal sqlite3 version we support for package:sqlite3 and drift's tooling. I think it would be great to pick a stable minimum version (and run tests against that as well). Since tests are currently running against either a fixed sqlite3 or the one shipping with the GitHub Actions Ubuntu runner, I can't reliably say which sqlite3 version is the lowest we can support.

I completely agree about having a clear error message as well, in this case I simply didn't consider that the database option may not have always been available - another thing that would be caught by tests.

from drift.

It looks like this is probably caused by my having an old version of libsqlite3.so. The relevant SQLite feature looks to have been introduced in 3.29.0:
https://www.sqlite.org/changes.html#version_3_29_0

which is fairly old, from 2019. My local libsqlite3.so is a bit older than that, 3.27.2.

It's extremely reasonable for Drift to rely on SQLite features from 2019. It'd be good for that to be explicit, though.

Is there a minimum SQLite version documented somewhere? I'm not immediately finding one. Possibly https://drift.simonbinder.eu/docs/platforms/#desktop is the most relevant spot for that information.

Better yet, it would be great to get a clear error message to that effect, rather than a traceback when a particular operation that Drift tries to do turns out not to be supported.

from drift.

Sounds great — thank you!

from drift.