foobar2000

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?