Dominique Devienne wrote: > On Thu, Jul 6, 2017 at 12:54 PM, Clemens Ladisch wrote: >> You could put kcounts into a temporary table. > > I could it in a table, but then who updates kcounts when keys (or keys_tab) > changes?
I did not say "table" but "temporary table": BEGIN; CREATE TEMPORARY TABLE kcounts AS SELECT ...; SELECT ... FROM kcounts ...; DROP TABLE kcounts; COMMIT; > "Users" just "view" these views in any SQLite clients, typically a GUI one. > And they should remain "dynamic" > into case the table contents are modified with DMLs. SQLite is designed as an embedded database, and expects that additional logic, if needed, can be provided by the application. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
