Skip to content

Database commands and queries


rescan

rescan <|playlists|onlinelibrary|external|full singlefolder|?>

The rescan command causes the server to rescan the entire music library, reloading the music file information.

  • If playlists is indicated (rescan playlists), only the playlist directory is rescanned.
  • If onlinelibrary is indicated (rescan onlinelibrary), only the import from online music services is run.
  • If external is requested, the rescan will be performed using the external scanner process instead of the in-process scanner.
  • If full file://some/path is defined, then only this path will be scanned. Issued with a ?, rescan ? returns if the server is currently scanning.

Scanning occurs when the server starts and following rescan and wipecache commands.

Examples:

Request: "rescan<LF>"
Response: "rescan<LF>"

Request: "rescan ?<LF>"
Response: "rescan 1<LF>"


rescanprogress

rescanprogress

The rescanprogress query returns details on the scanning progress. This query does not take any parameters.

Returned tagged parameters:

Tag Description
rescan Returned with value 1 if the server is still scanning the database, otherwise returned with value 0 and the fields below are not returned.
totaltime Total elapsed time since the start of the scan, format hh:mm:ss.
importer A completion percentage for each importer. Importers include:-
directory (Music folder),
playlist(Playlist folder),
iTunes (iTunes),
musicip (MusicIP),

as well as more technical ones such as
mergeva (Various Artists merging) and
dboptimize (Database optimization).

The type, quantity and order of importers is determined dynamically as rescan progresses.
info Additional information about the current scanning step, like eg. the currently scanned file name.
steps Scanning steps in the order they've been executed.
lastscanfailed Information about a possible failure in case a scan has not finished in an attended manner.

Example:

Request: "rescanprogress<LF>"
Response: "rescanprogress rescan:1 totaltime:00:00:07 directory:100 playlist:100 itunes:15 <LF>"

Request: "rescanprogress<LF>"
Response: "rescanprogress rescan:1 totaltime:00:01:04 directory:100 playlist:100 itunes:100 itunes_playlists:100 mergeva:100 cleanup1:100 cleanup2:100 dboptimize:47 <LF>"


abortscan

abortscan

The abortscan command causes the server to cancel a running scan. Please note that after stopping a scan this way you'll have to fully rescan your music collection to get consistent data.

Examples:

Request: "abortscan<LF>"
Response: "abortscan<LF>"


wipecache

wipecache

The wipecache command allows the caller to have the server rescan its music library, reloading the music file information. This differs from the rescan command in that it first clears the tag database. During a rescan triggered by wipecache, rescan ? returns true.

Examples:

Request: "wipecache<LF>"
Response: "wipecache<LF>"


libraries

libraries

The libraries query returns a list of known library views with their ID to the caller.

Examples:

Request: "libraries<LF>"
Response: "libraries id:8c7ee510 name:FLAC%20files%20only<LF>"


libraries getid

<playerid> libraries getid

The libraries getid query returns the ID and the name of library set to be used by the given player. Returns id:0 and no name if no library is active.

Examples:

Request: "04:20:00:12:23:45 libraries getid<LF>"
Request: "04:20:00:12:23:45 libraries getid id:8c7ee510 name:FLAC%20files%20only<LF>"


info total genres

info total genres ?

The info total genres ? query returns the number of unique genres in the server music database.

Examples:

Request: "info total genres ?<LF>"
Response: "info total genres 18<LF>"


info total artists

info total artists ?

The info total artists ? query returns the number of unique artists in the server music database. The Composer, band and orchestra in artists preference (Server Settings, Behavior) determines which contributors are considered artists.

Examples:

Request: "info total artists ?<LF>"
Response: "info total artists 18<LF>"


info total albums

info total albums ?

The info total albums ? query returns the number of unique albums in the server music database.

Examples:

Request: "info total albums ?<LF>"
Response: "info total albums 18<LF>"


info total songs

info total songs ?

The info total songs ? query returns the number of unique songs in the server music database.

Examples:

Request: "info total songs ?<LF>"
Response: "info total songs 18<LF>"


info total duration

info total duration ?

The info total duration ? query returns the number of seconds playtime in the server music database.

Examples:

Request: "info total duration ?<LF>"
Response: "info total duration 66109<LF>"


genres

genres <start> <itemsPerResponse> <taggedParameters>

The genres query returns all genres known by the server.

Note that the server supports multiple genres per track, depending on the Multiple items in tags preference (Server Settings, Behavior).

Accepted tagged parameters:

Tag Description
search Search string. The search is case insensitive and obeys the Search Within Words server parameter.
artist_id Limit results to those genres proposed by the artist identified by artist_id.
album_id Limit results to those genres available on the album identified by album_id.
track_id Limit results to the genres of the track identified by track_id. If present, other filters are ignored.
genre_id Limit results to the genre identified by genre_id. The genre_id may be a list of comma separated IDs. If present, other filters are ignored.
library_id Virtual library ID, to restrict the results to a virtual library view.
year Limit results to the genres of the tracks of the given year.
tags Determines which tags are returned. Each returned tag is identified by a letter (see below). The default value is empty.

Returned tagged parameters:

Block Tag Description
First block:
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
count Number of results returned by the query. If no filter parameter is present, this is the same value as returned by info total genres ?.
CC count - Only return the number of results, but not the results themselves.
Z indexList An array of arrays indicating how many items start with each key letter.
For each genre:
id Genre ID. Item delimiter.
genre Genre name.
s textkey

The genre's textkey is the first letter of the sorting key.

Example:

Request: "genres 0 5<LF>"
Response: "genres 0 5 rescan:1 count:6 id:3 genre:Acid%20Jazz id:4 genre:Alternative%20&%20Punk id:5 genre:French id:6 genre:No%20Genre id:7 genre:Pop <LF>"

Request: "genres 0 5 search:unk<LF>"
Response: "genres 0 5 search:unk count:1 id:4 genre:Alternative%20&%20Punk<LF>"


artists

artists <start> <itemsPerResponse> <taggedParameters>

The artists query returns all artists known by the server. The results of this query depend in part on the Compilations preference (Server Settings, Behavior). The Various Artists pseudo-artist appears if the server groups compilations.

Accepted tagged parameters:

Tag Description
search Search substring. The search is case insensitive and obeys the Search Within Words server parameter.
genre_id Genre ID, to restrict the results to those artists with songs of that genre. The genre_id may be a list of comma separated IDs.
album_id Album ID, to restrict the results to those artists with songs of that album.
track_id Track ID, to restrict the results to the artist of track_id. If specified, all other filters are ignored.
artist_id Artist ID, to restrict the results to a single artist. If specified, all other filters are ignored.
role_id Contributor role ID, to restrict the results to the artist of role_id. This parameter must be a comma separated list of role IDs, or a comma separated list of role tokens (eg. ALBUMARTIST, ARTIST)
library_id Virtual library ID, to restrict the results to a virtual library view.
include_online_only_artists Include external artists from music services, even if they don't have any track or album in the current collection. This allows callers to browse those artists on the external service.

Please note that this parmeter would be ignored if some kind of filtering argument was given which didn't apply to artists without related tracks (eg. genre_id, album_id etc.).
tags Determines which tags are returned. Each returned tag is identified by a letter (see below). The default value is empty.

Returned tagged parameters:

Block Tag Description
First block:
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
count Number of results returned by the query. If no search string is present, this is the same value as returned by info total artists ?
CC count Only return the number of results, but not the results themselves.
Z indexList An array of arrays indicating how many items start with each key letter.
For each artist:
id Artist ID. Item delimiter.
artist Artist name.
s textkey The artist's textkey is the first letter of the sorting key. CLARIFICATION-NEEDED
E extid The contributor's external ID, if it is eg. from an online music service. CLARIFICATION-NEEDED

Example:

Request: "artists 0 5<LF>"
Response: "artists 0 5 count:7 id:2 artist:Anastacia id:3 artist:Calogero id:4 artist:Evanescence id:5 artist:Leftfield%20%26%20Lydon id:18 artist:Llorca <LF>"

Request: "artists 0 5 genre_id:7<LF>"
Response: "artists 0 5 genre_id:7 count:2 id:2 artist:Anastacia id:19 artist:Sarah%20Connor <LF>"


albums

albums <start> <itemsPerResponse> <taggedParameters>

The albums query returns all albums known by the server. The results of this query depend in part on the Group discs preference (Server Settings, Behavior).

Accepted tagged parameters:

Tag Description
search Search substring. The search is case insensitive and obeys the Search Within Words server parameter.
genre_id Genre ID, to restrict the results to those albums with songs of that genre. The genre_id may be a list of comma separated IDs.
artist_id Artist ID, to restrict the results to those albums by artist_id.
track_id Track ID, to restrict the results to the album of track_id. If specified, all other filters are ignored.
album_id Album ID, to restrict the results to a single album. Or a comma sparated list of album IDs, to restrict the results to a specific list of albums. If specified, all other filters are ignored.
role_id Contributor role ID, to restrict the results to those albums by artist of role role_id. This parameter must be a comma separated list of role IDs, or a comma separated list of role tokens (eg. ALBUMARTIST, ARTIST)
library_id Virtual library ID, to restrict the results to a virtual library view.
year Year, to restrict the results to those albums of that year.
compilation Compilation, to restrict the results to those albums that are (1) or aren't (0) compilations.
sort Sort order of the returned list of albums. One of:
album, (the default),
new (sort by change date in descending order),
artflow which sorts by artist, year, album for use with artwork-centric interfaces,
artistalbum,
yearalbum,
yearartistalbum,
random.
tags Determines which tags are returned. Each returned tag is identified by a letter (see below). The default value is l.

Returned tagged parameters:

Block Tag Description
First block:
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
count Number of results returned by the query. If no filter is present, this is the same value as returned by info total albums ?
CC count Only return the number of results, but not the results themselves. CLARIFICATION-NEEDED
Z indexList An array of arrays indicating how many items start with each key letter (or year for a year-dominated sort order). CLARIFICATION-NEEDED
For each album:
id Album ID. Item delimiter.
l album Album name, including the server's added (N of M) if the server is set to group multi disc albums together. See tag title for the unmodified value. CLARIFICATION-NEEDED
y year Album year. This is determined by the server based on the album tracks.
j artwork_track_id Identifier of one of the album tracks, used by the server to display the album's artwork.
t title Raw album title as found in the album tracks ID3 tags, as opposed to album. Note that title and album are identical if the server is set to group discs together.
i disc Disc number of this album. Only if the server is not set to group multi-disc albums together.
q disccount Number of discs for this album. Only if known.
w compilation 1 if this album is a compilation.
W release_type The release type of an album, eg. album, ep, etc.
a artist The album artist (depends on server configuration).
aa artists A comma separated list of album artists (depends on server configuration).
S artist_id The album artist id (depends on server configuration).
SS artist_ids A comma separated list of album artist ids (depends on server configuration).
s textkey The album's textkey is the first letter of the sorting key.
E extid The album's external ID, if it is eg. from an online music service.
R role_ids A comma separated list of role ids for the album.
X album_replay_gain The album's replay-gain.

Examples:

Request: "albums 0 4<LF>"
Response: "albums 0 4 count:14 id:1 album:Amadeus%20(Disc%201%20of%202) id:4 album:Anastacia id:5 album:Bounce%20[Single] id:6 album:Fallen<LF>"

Request: "albums 0 5 genre_id:7<LF>"
Response: "albums 0 5 genre_id:7 count:2 id:4 album:Anastacia id:5 album:Bounce%20[Single]<LF>"

Request: "albums 0 5 artist_id:19<LF>"
Response: "albums 0 5 artist_id:19 count:1 id:5 album:Bounce%20[Single]<LF>"


years

years <start> <itemsPerResponse> <taggedParameters>

The years query returns all years known by the server.

Accepted tagged parameters:

Tag Description
year Return only the specified year.
hasAlbums:1 Return only years which are valid for albums.

Returned tagged parameters:

Block Tag Description
First block:
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
For each year:
year Year. Item delimiter.

Example:

Request: "years 0 5<LF>"
Response: "years 0 5 rescan:1 count:6 year:1985 year:1987 year:1988 year:2002 year:2003 year:2004 <LF>"


musicfolder

musicfolder <start> <itemsPerResponse> <taggedParameters>

The musicfolder query returns the content of a given music folder, starting from the top level directory configured in the server.

mediafolder is an alias to musicfolder.

Accepted tagged parameters:

Tag Description
folder_id Browses the folder identified by folder_id.
return_top If set to 1, and folder_id is provided, will return the data about the listed folder instead of the child folders.
url Browses the folder identified by url. If the content of url did not happen to be in the server database, it is added to it.

url has precedence over folder_id if both are provided.
type One of audio, or list. Select the media type you want to browse in the given folder.
tags Determines which tags are returned. Each returned tag is identified by a letter (see below). The default value is empty.
recursive If set to 1, the query will return information about the requested folder and it's sub-folders, and all files in there.

Returned tagged parameters:

Block Tag Description
First block:
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
count Number of results returned by the query.
For each item in the folder:
id Track, playlist or folder ID. Item delimiter.
type One of track, folder, playlist, or unknown.
c coverid coverid to use when constructing an artwork URL, such as /music/$coverid/cover.jpg
d duration Song duration in seconds.
s textkey The item's textkey is the first letter of the sorting key.
u url The item's full URL.

Example:

Request: "musicfolder 0 10<LF>"
Response: "musicfolder 0 10 count:26 id:1 title:03%20Barbie%20Girl.mp3 type:audio id:2 title:12%20-%20If%20I%20Had%20You.mp3 type:audio id:313 title:A-Ha type:dir id:50 title:Test.m3u type:playlist<LF>"

Request: "musicfolder 0 10 folder_id:313<LF>"
Response: "musicfolder 0 10 folder_id:313 count:2 id:335 title:Lifelines type:dir id:336 title:Minor%20Earth%20Major%20Sky type:dir<LF>"

mediafolder

mediafolder is an alias of musicfolder


playlists

playlists <start> <itemsPerResponse> <taggedParameters>

The playlists query returns all playlists known by the server.

Accepted tagged parameters:

Tag Description
search Search substring. The search is case insensitive and obeys the Search Within Words server parameter.
tags Determines which tags are returned. Each returned tag is identified by a letter (see below). The default value is empty.

Returned tagged parameters:

Block Tag Description
First block:
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
count Number of results returned by the query.
For each playlist:
id Playlist ID. Item delimiter.
playlist Playlist name
u url Playlist file url
s textkey The playlist's textkey is the first letter of the sorting key.
u url The playlist's url.
E extid The playlist's external ID, if it is eg. from an online music service.
x remote If 1, this is a remote playlist.

Example:

Request: "playlists 0 2<LF>"
Response: "playlists 0 2 count:5 id:37 name:Funky%20Beats id:57 name:SUPER<LF>"

Request: "playlists 0 2 search:SUPER tags:u<LF>"
Response: "playlists 0 2 search:SUPER tags:u count:1 id:57 name:SUPER url:playlist:///Volume/path/file.m3u<LF>"


playlists tracks

playlists tracks <start> <itemsPerResponse> <taggedParameters>

The playlists tracks query returns the tracks of a given playlist.

Accepted tagged parameters:

Tag Description
playlist_id Playlist ID as returned by the playlists query. This is a mandatory parameter.
tags Determines which tags are returned. Each returned tag is identified by a letter (see command songinfo for a list of possible fields and their identifying letter). The default tags value for this command is gald.

Returned tagged parameters:

Block Tag Description
First block:
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
count Number of tracks in the playlist.
For each track:
playlist index Index (first item is 0) of the track in the playlist. The first returned instance of this field is equal to start. Item seperator.
Tags Same tags as defined in command songinfo.

playlists rename

playlists rename <taggedParameters>

This command renames a saved playlist.

Accepted tagged parameters:

Tag Description
playlist_id The id of the playlist to rename.
newname The new name of the playlist (without .m3u).
dry_run Used to check if the new name is already used by another playlist. The command performs the name check but does not overwrite the existing playlist. If a name conflict occurs, the command will return a overwritten_playlist_id parameter.

Returned tagged parameters:

Tag Description
overwritten_playlist_id This returns the playlist id of the playlist overwritten (if dry_run is 0 or not present) by renaming the playlist. Only present if a playlist is overwritten.

Examples:

Request: "playlists rename playlist_id:22 newname:Hello<LF>"
Response: "playlists rename playlist_id:22 newname:Hello<LF>"


playlists new

playlists new <taggedParameters>

This command creates an empty saved playlist, to be further manipulated by other commands.

Accepted tagged parameters:

Tag Description
name The name of the playlist (without .m3u).

Returned tagged parameters:

Tag Description
playlist_id This returns the playlist id of the created playlist.
overwritten_playlist_id This returns the playlist id of an existing playlist with the same name. The new playlist is not created.

Examples:

Request: "playlists new name:Hello<LF>"
Response: "playlists new name:Hello playlist_id:345<LF>"


playlists delete

playlists delete <taggedParameters>

This command deletes a saved playlist.

Accepted tagged parameters:

Tag Description
playlist_id The id of the playlist to delete.

Examples:

Request: "playlists delete playlist_id:22<LF>"
Response: "playlists delete playlist_id:22<LF>"


playlists edit

playlists edit <taggedParameters>

This command manipulates the track content of a saved playlist.

Accepted tagged parameters:

Tag Description
playlist_id The id of the playlist to manipulate.
cmd One of up, down, move, delete or add, in order to move up, down, delete or add a track.
index For cmd:up, cmd:down, cmd:move and cmd:delete the index of the track to edit.
toindex For cmd:move the new index of the track to be moved.
title For cmd:add, the title of the track to add.
url For cmd:add, the url of the track to add.

Examples:

Request: "playlists edit cmd:up playlist_id:22 index:3<LF>"
Response: "playlists edit cmd:up playlist_id:22 index:3<LF>"

Request: "playlists edit cmd:add playlist_id:22 title:Song url:file://...<LF>"
Response: "playlists edit cmd:add playlist_id:22 title:Song url:file://...<LF>"


songinfo

songinfo <start> <itemsPerResponse> <taggedParameters>

The songinfo command returns all the information on a song known by the server. Please note that the and parameters apply to the individual data fields below and not, as they do in other extended CLI queries, to the number of songs (or artists, genres, etc.) returned; the songinfo only ever returns information about a single song.

Accepted tagged parameters:

Tag Description
url Song path as returned by other CLI commands. This is a mandatory parameter, except if track_id is provided.
track_id Track ID as returned by other CLI commands. This is a mandatory parameter, except if url is provided.
tags Determines which tags are returned. Each returned tag is identified by a letter (see below). The default value is all info except the url (u) and the multi-valued tags for genre(s) (G & P) and artists (A & S)

Returned tagged parameters:

Tag Description
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
count Number of results returned by the query, that is, total number of elements to return for this song.
id Track ID.
title Song title
a artist Artist name.
A <role> For every artist role (one of artist, composer, conductor, band, albumartist or trackartist), a comma and space (', ') separated list of names.
AA <role> This is like A, but without the space after the comma. This should simplify parsing/splitting when required.
B buttons A hash with button definitions. Only available for certain plugins such as Pandora.
c coverid coverid to use when constructing an artwork URL, such as /music/$coverid/cover.jpg
C compilation 1 if the album this track belongs to is a compilation
K artwork_url A full URL to remote artwork. Only available for certain online music services.
W release_type The release type of the track's album, eg. album, ep, etc.
d duration Song duration in seconds.
e album_id Album ID. Only if known.
f filesize Song file length in bytes. Only if known.
g genre Genre name. Only if known.
G genres Genre names, separated by commas (only useful if the server is set to handle multiple items in tags).
i disc Disc number. Only if known.
I samplesize Song sample size (in bits)
j coverart 1 if coverart is available for this song. Not listed otherwise.
J artwork_track_id Identifier of the album track used by the server to display the album's artwork. Not listed if artwork is not available for this album.
k comment Song comments, if any.
K artwork_url A full URL to remote artwork. Only available for certain online music services.
l album Album name. Only if known.
L info_link A custom link to use for trackinfo. Only available for certain online music services.
m bpm Beats per minute. Only if known.
M musicmagic_mixable 1 if track is mixable, otherwise 0.
n modificationTime Date and time song file was last changed on disk.
N remote_title Title of the internet radio station.
o type Content type. Only if known.
Q lossless 1 if track is lossless, otherwise 0.
p genre_id Genre ID. Only if known.
P genre_ids Genre IDs, separated by commas (only useful if the server is set to handle multiple items in tags).
D addedTime Date and time song file was first added to the database.
U lastUpdated Date and time song file was last updated in the database.
q disccount Number of discs. Only if known.
r bitrate Song bitrate. Only if known.
R rating Song rating, if known and greater than 0.
O playcount Song play count.
s artist_id Artist ID.
S <role>_ids For each role as defined above, the list of ids (comma separated).
t tracknum Track number. Only if known.
T samplerate Song sample rate (in KHz)
u url Song file url.
v tagversion Version of tag information in song file. Only if known.
w lyrics Lyrics. Only if known.
x remote If 1, this is a remote track.
E extid Some tracks have an external identifier (eg. from an online music service).
X album_replay_gain Replay gain of the album (in dB), if any
y year Song year. Only if known.
Y replay_gain Replay gain (in dB), if any
V live_edge The Live edge of a remote stream. -1 is not live, 0 is live at the edge, >0 is number of seconds from the live edge.

Example:

Request: "songinfo 0 100 track_id:2<LF>"
Response: "songinfo 0 100 track_id:2 count:26 id:2 title:If%20I%20Had%20You artist:Diana%20Krall duration:297.117 album_id:2 filesize:5952369 genre:Vocal comment:Pianist%2Fvocalist%20Diana%20Krall%20pays%20tribute%20to%20the%20Nat%20King%20Cole%20Trio.... album:All%20for%20You modificationTime:Thursday%2C%20March%201%2C%202007%2C%209:21:58%20PM type:mp3 genre_id:2 bitrate:160kbps%20VBR artist_id:3 tracknum:12 tagversion:ID3v2.3.0 year:1995 samplerate:44100 url:file:%2F%2F%2FUsers%2Ffred%2FPrograms%2FLyrion Music Server%2FMusic%2F12%2520-%2520If%2520I%2520Had%2520You.mp3 <LF>"


titles|songs|tracks

titles|songs|tracks <start> <itemsPerResponse> <taggedParameters>

The titles command returns all titles known by the server.

songs and tracks are aliases for titles

Accepted tagged parameters:

Tag Description
genre_id Genre ID, to restrict the results to the titles of that genre.
artist_id Artist ID, to restrict the results to the titles of that artist.
album_id Album ID, to restrict the results to the titles of that album.
track_id Track ID, to restrict the results to a single track.
role_id Contributor role ID, to restrict the results to the artist of role role_id. This parameter must be a comma separated list of role IDs, or a comma separated list of role tokens (eg. ALBUMARTIST, ARTIST)
release_type The release type of the track's album, eg. album, ep, etc.
library_id Virtual library ID, to restrict the results to a virtual library view.
year Year, to restrict the results to the titles of that year.
search Search substring. The search is case insensitive and obeys the Search Within Words server parameter.
tags Determines which tags are returned. Each returned tag is identified by a letter (see command songinfo for a list of possible fields and their identifying letter). The default tags value for this command is gald.
CC Only return the number of results, but not the results themselves.
sort Sorting, one of:-
title (the default),
tracknum (in which case the track field (t) is added automatically to the response) or
albumtrack (in which case the track and album-title fields (l and t) are added automatically to the response).

Sorting by tracks is possible only if tracks are defined and for a single album.

Returned tagged parameters:

Block Tag Description
First block:
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
count Number of results returned by the query. If no search string or album/artist/genre filter is present, this is the same value as returned by info total songs ?.
For each title:
Tags Same tags as defined in command songinfo.

Example:

Request: "titles 0 2<LF>"
Response: "titles 0 2 count:100 id:55 title:Ancestral%20Aid genre:Soundtrack artist:Various%20Artists album:The%20Hunt%20For%20Red%20October duration:136.93387755102 disc:1 track:5 year:1990 url:file://Disk | he%20Hunt%20For%20Red%20October/Ancestral%20Aid.mp3 id:1 title:Any%20How genre:Acid%20Jazz artist:Llorca album:New%20Comer duration:340.297142857143 track:5 year:2001 url:...<LF>"

Request: "titles 0 12 album:Anastacia tags:p<LF>"
Response: "titles 0 12 album:Anastacia tags:p count:12 id:4 title:Heavy%20On%20My%20Heart url:... id:1 title:I%20Do url:... id:2 title:Left%20Outside%20Alone url:...<LF>"


search <start> <itemsPerResponse> <taggedParameters>

The search command returns artists, albums and tracks matching a search string.

Please note that start and itemsPerResponse are calculated per category. If you eg. have genres and tracks with the search term in them, you'll get itemsPerResponse number of each of them. The total number of items returned therefore can be a multiple of itemsPerResponse.

Accepted tagged parameters:

Tag Description
term Search string

Returned tagged parameters:

Block Tag Description
First block:
rescan Returned with value 1 if the server is still scanning the database. The results may therefore be incomplete. Not returned if no scan is in progress.
count Total number of results returned by the query. This is the sum of artists_count, albums_count and tracks_count.
artists_count Total number of artists found.
albums_count Total number of albums found.
genres_count Total number of genres found.
tracks_count Total number of tracks found.
For each artist:
artist_id Artist ID.
artist Artist name.
For each album:
album_id Album ID.
albu Album title
For each genre:
genre_id Genre ID.
genre Genre title.
For each track:
track_id Track ID.
track Track title.

Example:

Request: "search 0 20 term:al<LF>"
Response: "search 0 20 term:al count:9 artists_count:2 albums_count:1 tracks_count:6 artist_id:2 artist:Alanis%20Morissette artist_id:37 artist:Alphaville album_id:10 album:All%20Time%20Greatest%20Hits%20%5BBarry%20White%5D%20MMM track_id:11 track:All%20I%20Really%20Want track_id:68 track:The%20Sun%20Always%20Shines%20On%20TV track_id:185 track:All%20Around%20The%20World track_id:189 track:Give%20Me%20All%20Your%20Love%20%5BSingle%20Cut%5D track_id:245 track:Better%20All%20The%20Time


pragma

pragma <pragma string>

The pragma command executes the given pragma string against the SQLite database engine. If using MySQL, this command has no effect. For a list of available pragmas, see sqlite.org. Warning: Do not use this function unless you know what you are doing!

Example:

pragma locking_mode = NORMAL