Hi,
My pleasure. I am curious what you will think of as I had no time to play around much with MM5 API lately.

Thanks Peke! That is very helpful.

Simply Use Sample Script "SQLeditor" eg. copy from Sample scripts to Scripts.

You can also use that Script to cannibalize what you need for your APP.

Only difference is taht you do not open SQLite Connection but rather thru https://www.mediamonkey.com/webhelp/MM5 ... es/DB.html

There have been a couple of threads where people reported having issues writing to the database (see here and here), so external tool access might not be a thing atm.

As the regexp script does not seem forthcoming, I wanted to see if I could do db updates in VS using SQL calls.

I stumbled past the collation thing for WHERE statements in SELECTs using COLLATE NOCASE for strings, but have had no luck doing UPDATES:
using (SQLiteConnection connection = new SQLiteConnection(constr))
{
string updateQuery = @"UPDATE main.Songs SET SongTitle = @SongTitle WHERE ID = @ID";
var result = connection.Execute(updateQuery, new
{
ID = 320923,
SongTitle = "A different song title"
});
}

This yields a collate error and I can't guess what it wants.
Does anyone know a way to do an SQL UPDATE to the Songs DB? Entity framework? Dapper?