foobar2000

SQL Tree

By: fbuser

Version: 1.1.0 (archived)

Change log:

  • 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

Supported processor architecture: x86 32-bit.

Works with foobar2000 v1.3 and newer

Links

No download available.
View version history
View latest version and component description
Documentation
Discussion

How to install a component?