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 processor architectures: x86 32-bit, x86 64-bit.
Works with foobar2000 v2.0 and newer
Links
Download
View version history
View latest version and component description
Documentation
Discussion
How to install a component?