Overview | News | Windows | macOS | Android | iOS | Audio Formats | Components | Encoder Pack | Screenshots | Help & Support | Developer | Old Versions | Other Projects
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 system: Windows 32-bit.
Works with foobar2000 v1.5 and newer
Links
View version history
View latest version and component description
Documentation
Discussion