Using SQL Maestro as a MM3 DB editor

[petr.vanek]

It's a sqlite API call - sqlite3_create_collation() and its cousins sqlite3_create_collation_v2() and sqlite3_create_collation16() - see http://www.sqlite.org/c3ref/create_collation.html for the docs.

It's also what I used in my Python example earlier in this thread. What would be really cool is if you could integrate SpiderMonkey (or whatever ECMAScript engine QT3 recommends), or whatever scripting language you prefer, and allow your end-users to do this sort of thing themselves. (A tall order, I admit! )

sure. I know this sqlite API call. I just wanted to know if it's in some monkey's library or compiled into exe binary itself.

At last - I'm afraid I'm lost if it's in the final exe file - users cannot load it on demand in my app. I don't like to see this 3rd party collation hardcoded into Sqliteman so I'm searching for any "pluggable" solution.

[MoDementia]

sure. I know this sqlite API call. I just wanted to know if it's in some monkey's library or compiled into exe binary itself.

At last - I'm afraid I'm lost if it's in the final exe file - users cannot load it on demand in my app. I don't like to see this 3rd party collation hardcoded into Sqliteman so I'm searching for any "pluggable" solution.

I think I now have an understanding of the problem. I'm sorry that the issue is more MM related than Sqliteman. I was under the impression that Iunicode collation support was generic i.e. you turned it on or off.

I too am afraid that you are correct and that the information is in the final exe.

If thats the case then
1. MM Devs need to include a separate libray for the way MM implemented IUNICODE collation that can be accessed by external database programs
2. Sqliteman provide an easy option to include/load such libraries when opening MM databases.

[Sproaticus]

1. MM Devs need to include a separate libray for the way MM implemented IUNICODE collation that can be accessed by external database programs
2. Sqliteman provide an easy option to include/load such libraries when opening MM databases.

The less obvious choice - but my favorite which is why I keep repeating it - is to open up the Sqliteman API to scripting. Let the end-user decide how the custom collation is implemented. (In addition to a whole bunch of other major benefits.)

Javascript via Spidermonkey would be fine, but involves bit of work to embed into an app. Python 2.5 includes Sqlite support automatically, and (IMHO) is easier to integrate into a C app using SWIG (or even a C++ app using the Boost libs.)