Column filters (instead of query input), support for big tables and maybe smaller size and sources. In the next small update I'll also improve performance to be extremely fast. (released)
Also it's extremely fast.
-DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_SHARED_CACHE - disable some SQLite features
No additional modules e.g. FullTextSearch (FTS3, 4, 5), geopoly and r-tree are included (but json1 does)
The result size can be reduced by excluding -static option (gcc overhead), but in this case the app will be require addition dll for Win10.
With extrenal sqlite3.dll the app size is about 75Kb.
I have many sqlite database where the only way to see data is to query joining multiple tables.
Does your plugins allow to have "virtual view" i.e to edit a real sql query and then use your plugin to have columns filtering ?
You can create a view and fetch data from it. The plugin is a basic tool to quick view and only.
If you need to run queries I'll recommend to use a special tools e.g. SQLite Studio, Database Browser for SQLite or my app sqlite-gui. They have many additional features.
Thanks,
I already use such tools i was just curious as the columns filtering can also be nice on top of dynamic query. Creating view must be done externally using another tool or command line sqlite3 before watching.