foobar2000

SQLite Utilities

By: fbuser

Version: 2.0.0, released on 2022-03-13 (archived)

Change log:

  • breaking change: the usage of the metadb_handle pseudo column has been replaced by the actual file path and subsong index, which affects the following functionalities:
    • the function tf requires path and optionally subsong as the first parameter(s) instead of metadb_handle as the first parameter and it's not restricted anymore to be used only with a virtual table.
    • inserting entries into the virtual playlist table requires now also the path and optionally subsong to be used instead of the metadb_handle column
  • breaking change: the default for LIKE comparisons is now case sensitive
  • added: a column "playlist_id" for the Playlist table, which identifies a playlist uniquely independent from the playlist index
  • added: support for materializing the media library and the playlist virtual tables
  • added: support for reading and writing tags into the database in addition to or instead of the file
  • added: show a placeholder for null values in the result of the SQLite console
  • added: advanced option to set an interval after which a long running background query is reported and can be aborted
  • added: advanced option to set an interval after which a query is interrupted to allow UI refreshes and other checks
  • added: advanced option to set an interval after which a lock conflict is reported and the relevant query can be aborted
  • added: advanced option to set an interval after which a query will try to continue because of a lock conflict
  • added: advanced option to set the meta value separator
  • added: capitalize() function
  • added: json_find() function
  • added: fb2k_profile_path() function
  • added: console_log() function
  • added: updatable virtual tables (MediaLibraryUpdatable and PlaylistUpdatable) are now automatically created
  • added: uint collation
  • added: utf8 support for the regexp functions
  • added: support for updating replaygain values by using the updatable virtual tables
  • added: support for ORDER BY and LIMIT clauses for DELETE and UPDATE statements
  • added: possibility to copy a whole column from the SQLite console result
  • added: support for multiple instances of the SQLite console
  • added: support to minimize and maximize the SQLite console
  • added: argument type and range check for all internal custom SQL functions
  • changed: replaced the advanced option for showing execution times by different other options to control the logging behavior
  • changed: include the column headers, if the whole result content in the SQLite console is copied
  • changed: replaced the uuid extension from Ralph Schleicher by the one, which is provided by the SQLite source repository
  • changed: autosize columns in the result of the SQLite console
  • changed: remove the 30000 character limit for the SQLite console input
  • fixed: long running queries were not aborted on shutdown of foobar2000, which caused the program to hang until the query was finished
  • fixed: possible issues with improper handling of the multivalue separator for a tag
  • fixed: disallow some tag names and ignore invalid tag names when adding them as defaults to avoid issues with the creation of the virtual tables
  • fixed: when a query was running in the sql tree no query could've been executed in the sqlite console
  • fixed: clicking on "Configure" in the "Installed media library viewers" section of the "Media Library" preferences didn't work
  • fixed: queries with more than one occurance of the Playlist table returned incorrect results
  • fixed: deleting items from the virtual updatable playlist table by using a tag based filter removed arbitrary items.
  • fixed: the virtual playlist table column "item_has_focus" returned the wrong result
  • fixed: added missing check for invalid column names
  • fixed: possible crash during file operation from the SQLite console
  • other: enhance performance for updating the virtual tables
  • other: upgraded SQLite to version 3.38.1
  • other: upgraded all external extensions to their latest version, if available
  • 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
  • other: fix documentation

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?