Overview | News | Windows | macOS | Android | iOS | Audio Formats | Components | Encoder Pack | Screenshots | Help & Support | Developer | Old Versions | Other Projects
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 system: Windows 32-bit.
Works with foobar2000 v1.5 and newer
Links
View version history
View latest version and component description
Documentation
Discussion