Mopidy-Local-SQLite is a Mopidy local library extension that uses an SQLite database for keeping track of your local media. This extension lets you browse your music collection by album, artist, composer and performer, and provides full-text search capabilities based on SQLite's FTS modules. It also notices updates via mopidy local scan
while Mopidy is running, so you can scan your media library periodically from a cron job, for example.
Mopidy-Local-SQLite can be installed using pip by running:
pip install Mopidy-Local-SQLite
Before starting Mopidy, you must change your configuration to switch to using Mopidy-Local-SQLite as your preferred local library. It is also recommended to change the default scan_flush_threshold
, to improve database access during a local scan:
[local]
library = sqlite
scan_flush_threshold = 100
Once this has been set you need to re-scan your library to populate the database:
mopidy local scan
This extension also provides some configuration settings of its own, but be aware that these are still subject to change:
[local-sqlite]
enabled = true
# top-level directories for browsing, as <name> <uri>
directories =
Albums local:directory?type=album
Artists local:directory?type=artist
Composers local:directory?type=artist&role=composer
Genres local:directory?type=genre
Performers local:directory?type=artist&role=performer
Release Years local:directory?type=date&format=%25Y
Tracks local:directory?type=track
Last Week's Updates local:directory?max-age=604800
Last Month's Updates local:directory?max-age=2592000
# database connection timeout in seconds
timeout = 10
# whether to use an album's musicbrainz_id for generating its URI
use_album_mbid_uri = true
# whether to use an artist's musicbrainz_id for generating its URI;
# disabled by default, since some taggers do not handle this well for
# multi-artist tracks [https://github.com/sampsyo/beets/issues/907]
use_artist_mbid_uri = false
# whether to use the sortname field for sorting artist browse results;
# set to false to sort according to displayed name only
use_artist_sortname = true
Copyright (c) 2014, 2015 Thomas Kemmer and contributors.
Licensed under the Apache License, Version 2.0.
The database schema does not support multiple artists, composers or performers for a single track or album. Look out for "Ignoring multiple artists" warnings during a local scan to see if you are affected by this.