Overview | News | Windows | macOS | Android | iOS | Audio Formats | Components | Encoder Pack | Screenshots | Help & Support | Developer | Old Versions | Other Projects
SQLite Utilities
By: fbuser
Version: 3.0.0, released on 2023-04-22 (archived)
Change log:
- added: dark mode support
- added: possibility to activate the SQLite console from the library viewer preferences section
- added: added file_created and file_attributes to the default columns for the virtual tables
- added: some maintenance scripts
- fixed: wrong row limit exceeded message in the console
- fixed: virtual table materialization needed an application restart after a database lock
- fixed: fallback/transform value was wrongly written as a lookup value in certain cases
- fixed: "Copy all" in the SQLite console didn't work properly after something was already copied before
- fixed: wrong handling of tag value fields for multivalue lookup fields
- fixed: The structure of the relevant lookup tables were not updated on changing the lookup table for a SQLite tag
- fixed: The values of a lookup table column got last after removing this column
- fixed: materializing the media library didn't properly work while moving files inside the library from one HDD to another in case user defined unique indexes were present
- fixed: unusued lookup values where not deleted anymore
- fixed: no default values for the virtual tables were added automatically on a fresh installation
- changed: metadb access optimizations for foobar2000 v2
- changed: the SQLite eval extension is now part of the define extension
- changed: using SQLite tags trailing empty tag values are not removed anymore for non-empty multivalue tags
- changed: define several extension functions as deterministic functions for allowing them to be used in indexes
- changed: when using the capitalize() SQL function roman numbers are now also properly detected inside parenthesis or other special characters
- other: foobar2000 2.0+ is now required
- other: upgraded SQLite to version 3.41.2
- other: upgraded some SQLite 3rdparty extensions to their latest version
- other: compiled with SDK-2023-04-18
- other: 32bit and 64bit versions are available
Supported systems: Windows 32-bit, Windows 64-bit.
Works with foobar2000 v2.0 and newer
Links
View version history
View latest version and component description
Documentation
Discussion