SQL Tree
By: fbuser
Version: 3.0.0, released on 2022-03-13 (archived)
Change log:
-
added: support for WITH clauses in query nodes
-
added: option to send a node query to the console on click action without executing it
-
added: abortable execute SQL query node action
-
added: query node option to omit not existing files when sending to a playlist
-
added: buttons to validate the query part of a query node or to send it to the SQLite console
-
added: option to include a query node in refreshing all nodes
-
added: menu entry to just remove the entries of a query node
-
added: possibility to specify a file name for the query and batch sql statements
-
removed: execute button from the batch tab of the query node dialog
-
changed: remove the 30000 character limit for the SQL query and batch inputs
-
changed: show now a dialog, if one of the query node limits is exceeded
-
changed: running queries don't block the sql tree anymore
-
changed: removed option to show execution times in the console in favour of using the extended logging option from foo_sqlite
-
changed: rename the query node action "Send to SQLite console" to "Execute in SQLite console"
-
changed: show different context menus for a tree node and the tree itself
-
fixed: crash if the batch part of a query node contained a query, which returned a query result
-
fixed: CASE expressions where not properly handled without parenthesis in a node query
-
fixed: crash during drag and drop operation, while a query is running
-
fixed: child nodes for a query nodes were not removed, if query relevant parameters were changed
-
fixed: changes of colors and icons for a query node where not applied to existing query result nodes, if these attributes where inherited from the query node
-
fixed: The tree node limit counter was not properly handled after exceeding
-
fixed: changed tree panel options were only applied after a restart of the program
-
fixed: changing "refresh on use" for a query not did not add or remove the expansion button
-
fixed: the expansion status of a newly inserted node was always expanded after an application restart
-
fixed: prevent accidently deleting the whole tree, if the DELETE key is pressed, when no node is selected
-
fixed: the connection between the tree panel and the database was lost in rare cases
-
other: at least foo_sqlite 2.0.0 is now required
-
other: at least ColumnsUI 1.7.0 is now required, if ColumnsUI is used
-
other: compiled with SDK-2022-01-04
-
other: foobar2000 1.5+ is now required
-
other: windows runtime libraries need to be installed (automatically provided by foobar2000 1.4+)
-
other: Windows XP and Windows Vista are not supported anymore
Supported processor architecture: x86 32-bit.
Works with foobar2000 v1.5 and newer
Links
Download
View version history
View latest version and component description
Documentation
Discussion
How to install a component?