> On Oct 20, 2019, at 12:53 AM, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote: > > many "playground" gadgets keep being implemented (like virtual columns, > virtual tables, FTS3/4/5, ...),
I suspect you are used to database servers, and haven’t used SQLite as an embedded library inside an app (its primary use case.) Virtual tables and table-valued functions are extremely useful there, as are a bunch of other features that probably seem like “playground” to you, like C functions and pointer types. The product I work on would be impossible without these. As for FTS, I can’t see how anyone would consider it frivolous! Full text search is very common, something many apps with structured storage eventually need, and found in a lot of big database servers. (You didn’t mention geo-queries, but the same goes for those. And for obvious reasons they’re especially good to have in mobile apps.) I’m curious which extra SQL features you think should be added? And what your use case is? —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
