foobar2000

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?