Releases of SQL Tree

4.0.6 current version, released on: 2023-05-21

  • fixed: still wrong detection of legacy config files

4.0.5 released on: 2023-05-15

  • added: show a popup dialog for all not loaded icon bitmap files
  • fixed: another wrong detection of legacy config files
  • other: compiled with SDK-2023-05-10

4.0.4 released on: 2023-05-07

  • fixed: wrong legacy config file detection
  • changed: handle all relativ paths for additional icon bitmaps as relative to the profile folder

4.0.3 released on: 2023-05-01

  • fixed: missing dark mode support for all message boxes

4.0.2 released on: 2023-05-01

  • fixed: setting a target playlist for the query node with the name of a not existing playlist was not possible

4.0.1 released on: 2023-05-01

  • fixed: 32bit- and 64bit configurations were not interchangeable
  • fixed: missing dark mode support for the tree panel itself

4.0.0 released on: 2023-04-22

  • breaking change: replace "refresh on use" option by two separate options "refresh on library change" and "refresh on playlist change"
  • added: dark mode support
  • added: possibility to activate a new DUI popup panel from the library viewer preferences section
  • added: possibility to choose the panel edge style also for a DUI panel
  • added: more fine-grained control of the defined keyboard shortcuts
  • fixed: clicking on a query node didn't refresh the node when it had no child nodes and was refreshed before
  • fixed: crash after clicking on several query result nodes and aborting the playlist filling
  • fixed: The tree node limit counter was again not properly handled
  • fixed: the copy of a node with opened edit dialog had a wrong state
  • fixed: wrong setting of the default advanced refresh query node options
  • fixed: child nodes could remain as garbage in the database after deleting a parent node
  • fixed: drag and drop for a new tree panel could only be used after a program restart
  • fixed: the context menu entries "Refresh" and "Clear" were not initally available for the relevant nodes of the example nodes
  • fixed: suppress windows notification sounds if certain unknown keyboard shortcuts are used
  • other: foo_sqlite 3.0.0+ is required
  • other: foobar2000 2.0+ is now required
  • other: ColumnsUI 2.0.0+ is now required, if ColumnsUI is used
  • other: compiled with SDK-2023-04-18
  • other: 32bit and 64bit versions are available

3.0.7 released on: 2022-07-07

  • fixed: wrong behavior (crash / no reaction) when clicking on a query result node

3.0.6 released on: 2022-07-07

  • fixed: The focus was not set to the label anymore after opening a query node dialog
  • fixed: Applying an empty query after removing its previous content was not possible, if also batch statement existed
  • fixed: certain inconsistent behaviors while clicking on a query node
  • fixed: clearing a query node did not reduce the relevant node counters
  • other: at least foo_sqlite 2.1.5 is required

3.0.5 released on: 2022-05-08

  • fixed: crash during refreshing a query node in case of inconsistencies between the select list of a query node and the result node options
  • fixed: unicode characters for the filenames of the query node dialog weren't handled properly anymore
  • fixed: query nodes were not invalidated to be refreshed again after adding files to the library or a playlist
  • fixed: a query node with "refresh on use" didn't have an expansion button anymore after a refresh with no child nodes as a result
  • fixed: clicking on a query node didn't refresh the node when it had no child nodes
  • fixed: the tree could be used even if the wrong foo_sqlite version was installed
  • other: at least foo_sqlite 2.1.3 is required

3.0.4 released on: 2022-04-10

  • fixed: if a folder node was opened or closed with a double click, the click action for a query node, which was moved to the former position of the folder node, was executed
  • fixed: the position of the icon selection dialog was not saved after closing it
  • fixed: if a (middle-)click action was defined as "Send to library view selection playlist" the options "Activate playlist" / "Start playback" / "Select items" were not activated
  • changed: the query node dialog is now resizable and modeless

3.0.3 released on: 2022-03-27

  • fixed: external changes to linked files for the batch part of a query node were not recognized, if the click action was "Execute SQL" or "Execute SQL in background"

3.0.2 released on: 2022-03-25

  • fixed: Setting "Omit not existing files when sending to a playlist" for a query node didn't even send tracks with existing files to the playlist
  • fixed: CASE expressions where not properly handled without parenthesis and not followed by a whitespace in a node query

3.0.1 released on: 2022-03-20

  • maybe fixed: possible crash on shutting down the application
  • fixed: the current directory was changed, when opening a file dialog in the query node dialog
  • fixed: the initial folder of a file dialog in the query node dialog was not set to the proper path, if a filename was already set
  • fixed: the ok button wasn't activated in the query node dialog, if selecting a file and the relevant textbox was empty
  • fixed: wrong encoding was used when loading utf-8 files without BOM in the query node dialog
  • fixed: files in the query node dialog were made relativ to the component folder even if the file was not inside the profile folder
  • fixed: removing a file in the query node dialog was not possible

3.0.0 released on: 2022-03-13

  • 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

2.0.3 released on: 2017-08-09

  • fixed: rare crash during drag and drop operations
  • fixed: a query which contained parentheses inside a string were not properly parsed in a node query
  • other: at least foo_sqlite 1.1.0 is required


  • fixed: crash, if foo_sqlite was not installed
  • fixed: rare crash during opening the context menu of the tree
  • other: at least foo_sqlite 1.0.3 is required
  • other: at least ColumnsUI 0.5.1 is required now, if ColumnsUI is used


  • fixed: graphical glitches during node operations


  • fixed: the remove duplicates option when sending items to a playlist for a query node removed the duplicates in an arbitrary order, so they were not properly grouped in the playlist
  • fixed: in the node definition dialog an existing query with no batch definition could not be cleared even when a batch definition was created
  • fixed: the "Query active" box overlapped the scrollbars of the tree
  • fixed: The scrollbars were still not placed at the very edge of the panel, if the panel was resized
  • fixed: crash when pressing a key or a mouse button during the loading of the tree
  • changed: renamed "Query active" to "Database activity ..."
  • added: STRG-A selects the whole content in all multiline edit fields
  • added: set some default values for a query node in the advanced preferences section
  • added: support for DefaultUI
  • removed: SQL processing priority settings
  • other: extract the SQLite basic functionality and the tree console to foo_sqlite
  • other: compiled with SDK-2015-08-03
  • other: compiled with ColumnsUI SDK 6.5.7
  • other: at least ColumnsUI 0.5.0 is required now, if ColumnsUI is used
  • other: Enhanced performance for the automatic sorting after changing a query node label


  • other: compiled with SDK-2015-01-15
  • other: upgrade to SQLite
  • other: include SQLite extension functions from Liam Healy


  • fixed: node filter was not applied, when the node result was sent to the SQL Tree console
  • other: upgrade to SQLite


  • fixed: scrollbars were not placed to the very edge of the panel
  • fixed: inserting nodes at the beginning of an existing query definition results in random colors for the node
  • fixed: text background for an unselected node was drawn larger than for a selected node
  • fixed: parallel use of playist actions in the tree and querying of the column metadb_handle led to wrong results for the playlist action
  • fixed: cross joins didn't work for the virtual tables
  • fixed: parameters, which were used during the creation of a virtual table were ignored after a reconnect to the database
  • fixed: execution time in SQL Tree Console was not reset after close
  • changed: no action will be executed when left click on tree item when shift is pressed
  • changed: no action will be executed when middle click on tree item when shift or ctrl is pressed
  • changed: execute button actions on button up instead of button down
  • changed: use "SQL Tree playlist" as default name for target playlist actions, if target playlist name is empty
  • added: support undo for playlist changes
  • added: possibility to define context specific icons and colors for query result nodes
  • added: context menu entry "Properties" for queries.
  • added: action "Choose from menu"
  • added: action "Send to Library Viewer Selection playlist"
  • added: support for selection holder
  • added: possibility to cut/copy/paste (+ drag/drop) query+folder nodes
  • added: SQL functions playing_playlist(), active_playlist()
  • added: SQL functions tf_playing_item(tf_expression), tf_focus_item(playlist_index,tf_expression), tf_focus_item_pn(playlist_name,tf_expression)
  • added: SQL function file_exists(file)
  • added: predefined fields for the virtual Playlist table: item_is_playing, item_has_focus, item_is_selected
  • added: possibility to update tags with the SQL UPDATE statement
  • added: possibility to add or remove items from a playlist with the SQL INSERT or DELETE statement
  • added: use automatic index on all columns, which don't have the column type "Predefined" and also for the playlist column playlist_name, playlist_index and playlist_item.
  • added: the SQL Tree console remembers the last executed query after closing and reopening it
  • other: upgrade to SQLite 3.7.17


  • fixed: the tree got corrupted, when different layouts were used
  • other: upgrade to SQLite


  • fixed: the status for "Start playback" was not saved for "Middle click action"
  • fixed: keyboard shortcuts were not working when tree items were selected with the right mouse button
  • changed: some minor changes
  • !!!Note!!!
  • This update requires ColumnsUI to be installed before starting foobar2000. Otherwise you might loose your configurations


  • fixed: some minor issues
  • other: upgrade to SQLite 3.7.9


  • changed: Renamed <Default> node to <Examples> and Examples subnode to Library, to make it clear that all these nodes are only meant as examples
  • fixed: crash, when refreshing a query node, while only the batch part of a query node but not the query part was used
  • fixed: several minor issues


  • initial release