by Barry4679 » Thu Jun 03, 2021 7:14 am
pah68 wrote: ↑Thu Jun 03, 2021 5:24 am
Renaming it to "" in the node is the same as deleting it.
That's good.
pah68 wrote: ↑Thu Jun 03, 2021 5:24 am
Do you recommend a SQL browser for any future tweaks?
I don't recommend doing tweaks really.
I only mentioned it in this case because there is facility in the MM5 Classification node where you could check that the Tempo was not in use anywhere, and you sounded like the typo was going to do your head in
The Sql Editor from MM5's Tools|Addons menu would be best, but you should really only use it for non-update queries, unless you are very certain of what you are doing.
I use the open source DB Browser for SQLite ... get the 32 bit version, because that version can load the SQLite3MMExt.dll that MiPi has hidden in the MM web site somewhere ... the dll supplies the IUNICODE collation that the Devs have baked into MediaMonkey database.
Using the MM5 addon mentioned above handles the IUNICIDE issue without you having to do anything, but has no UI to speak of. ... DB Browser for SQLite has a more functional UI for table browsing and filtering, and database structure browsing. etc
[quote=pah68 post_id=482401 time=1622715845 user_id=667]
Renaming it to "" in the node is the same as deleting it. :wink:
[/quote]
That's good.
[quote=pah68 post_id=482401 time=1622715845 user_id=667]
Do you recommend a SQL browser for any future tweaks?
[/quote]
I don't recommend doing tweaks really.
I only mentioned it in this case because there is facility in the MM5 Classification node where you could check that the Tempo was not in use anywhere, and you sounded like the typo was going to do your head in :)
The Sql Editor from MM5's Tools|Addons menu would be best, but you should really only use it for non-update queries, unless you are very certain of what you are doing.
I use the open source DB Browser for SQLite ... get the 32 bit version, because that version can load the SQLite3MMExt.dll that MiPi has hidden in the MM web site somewhere ... the dll supplies the IUNICODE collation that the Devs have baked into MediaMonkey database.
Using the MM5 addon mentioned above handles the IUNICIDE issue without you having to do anything, but has no UI to speak of. ... DB Browser for SQLite has a more functional UI for table browsing and filtering, and database structure browsing. etc