Overview | News | Windows | macOS | Android | iOS | Audio Formats | Components | Encoder Pack | Screenshots | Help & Support | Developer | Old Versions | Other Projects

Releases of SQLite Utilities

3.0.4 current version, released on: 2023-05-01

fixed: missing dark mode support for all message boxes

3.0.3 released on: 2023-05-01

fixed: possible crash while using the SQLite extension "define" - by disabling its caching and removing the relevant cache handling functions
fixed: crash while querying the virtual playlist table, after the number of playlists were changed
fixed: after changing the media library table or the playlist table in the preferences, the OK button needed to be pressed twice
fixed: adding a new column to the playlist table was not handled properly in certain cases
fixed: cutting the preferences pages for media library table and playlist table with DPI scales > 100%

3.0.2 released on: 2023-04-22

fixed: Wrong null value handling for certain numeric fields

3.0.1 released on: 2023-04-22

fixed: Possible crash during reading meta data.

3.0.0 released on: 2023-04-22

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

2.1.5 released on: 2022-07-07

fixed: crash when trying to open a corrupt user database
fixed: Changing the advanced option for roman numbers below a defined value was reset to default after application restart
fixed: possible crashes in certain cases
fixed: The row limit exceeded message was not shown in the console anymore
fixed: A transformed overwritten lookup value was written to the lookup table on subsequent unrelated tag updates
changed: Minor status message adjustments in the SQLite console
changed: set default value for the advanced option for roman numbers below a defined value to 50
other: upgraded SQLite to version 3.39.0

2.1.4 released on: 2022-05-09

fixed: Roman numbers were not processed properly anymore by the capitalize() db function

2.1.3 released on: 2022-05-08

fixed: wrong original tag values were shown on the details tab of the properties dialog after applying "Undo last SQLite tag change"
fixed: adding a column defnition for the virtual tables screwed up the column order on the preferences page
other: changed component display name to "SQLite Utilities"
other: upgraded SQLite to version 3.38.5

2.1.1 released on: 2022-03-24

fixed: possible crash on shutting down the application
fixed: all but the first column header were missing, if the whole result content in the SQLite console is copied
changed: move the initializationo of some database tables to the application start to avoid issues with running the initialization later

2.1.0 released on: 2022-03-20

maybe fixed: possible crash on shutting down the application
fixed: add missing column header for the first column, if the whole result content in the SQLite console is copied
fixed: the current directory was changed, when opening a file dialog SQLite console dialog
fixed: the relevant help pages couldn't be opened from the preferences dialog
fixed: wrong encoding was used when loading utf-8 files without BOM in the query node dialog
fixed: add missing uint extension description in the documentation
fixed: after showing an error dialog in the SQLite console, closing the error dialog and then the SQL console, causes foobar2000 to be not the active window anymore
fixed: the headers in the SQLite console were not updated, if the number of columns for two consecutive queries were the same
changed: the value of a cell in the result list of the SQLite console is not limited to 64k anymore
changed: adjust logging output
added: advanced options to disable the shipped SQLite extensions individually
added: additional sqlite extensions: array, besttype, closure, crypto, dbdump, define, envfuncs, isodate, math_funcs, math2, memstat, more_str_funcs, pivot_vtab, stats, stats2, stmt, text, vsv, xml_to_json
other: added missing license information for rapidjson
other: fix documentation

2.0.0 released on: 2022-03-13

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

1.1.0 released on: 2017-08-09

fixed: the strpos function caused an endless loop, if the search pattern was longer than the searched string
added: the modules csv, eval, fileio, series and totype from the sqlite source tree as autoloaded modules
added: the module md5 as autoloaded module
added: the module unicode as autoloaded module
added: the module uuid as autoloaded module
added: the modules damerau_levenshtein, levenshtein and metaphone as autoloaded modules
added: the custom functions regexp (which also implements the REGEXP operator of SQLite), regexp_replace, regexp_replace_first and regexp_search
added: the custom function strsortgroup
other: upgrade to SQLite 3.20.0

1.0.3

fixed: Using the round() function didn't work properly anymore
fixed: crash, if a column in a filter condition had a null value
other: upgrade to SQLite 3.19.1

1.0.2

fixed: a query on the MediaLibrary or Playlist virtual table, using colum entries containing double quotes in the where clause returned a wrong result
fixed: creating a new playlist with INSERT INTO for an updatable virtual table, didn't work after the playlist with the relevant name was deleted
fixed: links in the documentation where not relative
changed: use "SQLite Viewer playlist" instead of "SQL Tree playlist" as the default for inserting entries into a playlist
other: upgrade to SQLite 3.15.2

1.0.1

fixed: open the SQLite console from external didn't set the relevant SQL in the SQLite console, if the SQLite console was newly opened
fixed: subsequent calls of an SQL update statement caused a partial rerun of previous update statements

1.0

initial version, SQL functionality extracted from SQL Tree
fixed: two or more update statements on the virtual tables in a batch were executed in parallel instead of one after another in autocommit mode (outside transaction)
fixed: tracknumber was missing as default column for the virtual tables
added: STRG-A selects the whole content in the SQLite console
changed: Don't show an error anymore in the SQLite console, if the error code is "not an error"
other: upgrade to SQLite 3.13.0