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?