Program to edit MM SQLite DB?

[dtsig]

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

[MMuser2011]

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

[dtsig]

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 .

[chrisjj]

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.

[trixmoto]

I would cry! I don't think I've finished converting all of my scripts to SQLite yet. It's definitely better than what came before.

[PetrCBR]

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]

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 ?

[MMuser2011]

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.

[chrisjj]

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.

[MMuser2011]

Would be interesting to know what exactly is the 'magic' behind this song text tokenizer.

[PetrCBR]

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

[MMuser2011]

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)

[PetrCBR]

We're using our tokenizer for better search results.

[MMuser2011]

Yes, I believe it.
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?

[MMuser2011]

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?