Can you elaborate on the metadata? Are the keys always the same, in which
case you could store them as columns?
There's also the https://sqlite.org/rtree.html extension which lets you
efficiently query multidimensional range data.
If there is truly no schema, what you propose is the only way
The following query causes a crash in fsdirNext on Windows 10.
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT name FROM fsdir('.') JOIN (VALUES(1),(2));
.
2 matches
Mail list logo