Program to edit MM SQLite DB?

Get answers about using the current release of MediaMonkey for Windows.

Moderator: Gurus

dtsig
Posts: 3218
Joined: Mon Jan 24, 2011 6:34 pm

Re: Program to edit MM SQLite DB?

Post by dtsig » Mon Aug 18, 2014 10:08 pm

Peke wrote:I Escalated http://www.ventismedia.com/mantis/view.php?id=11083 as MMuser2011 solution will work on Numerical but not on Strings (eg. song title).
Wouldn't moving away from sqlite be overall a better solution? Lots of work but in the long term .. ?
Thanks
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

MMuser2011
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Program to edit MM SQLite DB?

Post by MMuser2011 » Tue Aug 19, 2014 1:57 am

Or at least using some 'standard' extensions like the one from http://site.icu-project.org/

Readme: http://www.sqlite.org/cgi/src/tree?name=ext/icu (Feature 1.3)
icu.c for sqlite: http://www.sqlite.org/cgi/src/raw/ext/i ... f53aedfc43
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

dtsig
Posts: 3218
Joined: Mon Jan 24, 2011 6:34 pm

Re: Program to edit MM SQLite DB?

Post by dtsig » Tue Aug 19, 2014 8:07 am

MMuser2011 wrote:Or at least using some 'standard' extensions like the one from http://site.icu-project.org/

Readme: http://www.sqlite.org/cgi/src/tree?name=ext/icu (Feature 1.3)
icu.c for sqlite: http://www.sqlite.org/cgi/src/raw/ext/i ... f53aedfc43
Specifically for the unicode/collation issue this would probably be a less HAMMER fix :).
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

chrisjj
Posts: 4933
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

Re: Program to edit MM SQLite DB?

Post by chrisjj » Tue Aug 19, 2014 4:51 pm

dtsig wrote:Wouldn't moving away from sqlite be overall a better solution? Lots of work but in the long term .. ?
You could be right, but it is only two versions since MM moved to SQLite. And a move away would (again) break many addins.
Chris

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Program to edit MM SQLite DB?

Post by trixmoto » Wed Aug 20, 2014 7:19 am

I would cry! :cry: I don't think I've finished converting all of my scripts to SQLite yet. It's definitely better than what came before.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.

PetrCBR
Posts: 1680
Joined: Tue Mar 07, 2006 5:31 pm
Location: Czech
Contact:

Re: Program to edit MM SQLite DB?

Post by PetrCBR » Fri Sep 05, 2014 10:48 am

When your SQLite editor supports SQLite Extensions (like SQLite Maestro, Database Browser for SQLite), you can download our extension from here to support IUNICODE.

chrisjj
Posts: 4933
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

Re: Program to edit MM SQLite DB?

Post by chrisjj » Fri Sep 05, 2014 11:22 am

PetrCBR wrote:you can download our extension from here to support IUNICODE.
Good to know. Thanks.

Does that (SQLite3MMExt.dll) also solve SongsText "unknown tokeniser" problem http://i.imgur.com/buAlBnd.png ?
Chris

MMuser2011
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Program to edit MM SQLite DB?

Post by MMuser2011 » Fri Sep 05, 2014 1:10 pm

No, I don't think so.
Because no one has published how this tokenizer works. Or do YOU know, what command is used?

BTW: SQLite Maestro (single non-commercial license) starts at $79. SQLiteSpy is free for personal and educational use and includes a similar extension.
Last edited by MMuser2011 on Fri Sep 05, 2014 1:18 pm, edited 2 times in total.
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

chrisjj
Posts: 4933
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

Re: Program to edit MM SQLite DB?

Post by chrisjj » Fri Sep 05, 2014 1:16 pm

MMuser2011 wrote:No, I don't think so.
Because no one has published how this tokenizer works. Or do YOU know, what command is used?
I don't but I think PetrCBR, an MM Dev, may do.
Chris

MMuser2011
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Program to edit MM SQLite DB?

Post by MMuser2011 » Fri Sep 05, 2014 1:18 pm

Would be interesting to know what exactly is the 'magic' behind this song text tokenizer.
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

PetrCBR
Posts: 1680
Joined: Tue Mar 07, 2006 5:31 pm
Location: Czech
Contact:

Re: Program to edit MM SQLite DB?

Post by PetrCBR » Fri Sep 05, 2014 1:27 pm

Try to replace sqlite.dll from the app with SQlite3MM.dll from MM folder.

MMuser2011
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Program to edit MM SQLite DB?

Post by MMuser2011 » Sat Sep 06, 2014 5:01 am

If I load your extension with the free SQLite Database Browser I don't get any result in the tab "Browse data" for the virtual table 'SongsText'. Should there be any visible entry?

@PetrCBR: Can you please tell us, whats behind the unknown tokenizer 'mm' in

Code: Select all

CREATE VIRTUAL TABLE SongsText USING FTS3(TOKENIZE mm ,artist,album,albumartist,songtitle,genre,songpath,author,lyricist,conductor,groupdesc,subtitle,lyrics,comment,custom1,custom2,custom3,custom4,custom5,origartist,origtitle,origlyricist,publisher,encoder,copyright,mood,tempo,occasion,quality,involvedpeople,producer,actors)
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

PetrCBR
Posts: 1680
Joined: Tue Mar 07, 2006 5:31 pm
Location: Czech
Contact:

Re: Program to edit MM SQLite DB?

Post by PetrCBR » Sun Sep 07, 2014 5:04 am

We're using our tokenizer for better search results.

MMuser2011
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Program to edit MM SQLite DB?

Post by MMuser2011 » Sun Sep 07, 2014 5:13 am

Yes, I believe it. :wink:
But how do you do that? How exactly your "mm tokenizer" works?
('mm' is the only part that seems not to be a field of any table).

Should the table "SongText" contain data or not?
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

MMuser2011
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Program to edit MM SQLite DB?

Post by MMuser2011 » Mon Oct 06, 2014 4:18 am

PetrCBR wrote:When your SQLite editor supports SQLite Extensions (like SQLite Maestro, Database Browser for SQLite), you can download our extension from here to support IUNICODE.
Unfortunately your extension doesn't work with Database Browser for SQLite.

If you try an UPDATE command on the 'Songs' table like this:

Code: Select all

UPDATE Songs SET IDMedia=9 WHERE IDMedia=7 AND SongPath LIKE '%mp3\M\%'
you get the error "unknown tokenizer: mm".

Therefore I kindly ask you again to answer my question:
What exactly should your tokenizer do?

Can you please fix your extension (attached to the above ticket 11083) in a way to enable commands like UPDATE?
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

Post Reply