Hi again, Unicode collation sequences for default Kexi (SQLite databases) is what defines _distinction_ between 1. ease of use and ease of deployment desktop db solutions and 2. complexity of server solutions (powerfull but tuned by hand, fragile to changes).
I invested into a small research first at [http://community.kde.org/Kexi/KexiDB/KexiDB_Drivers/SQLite] and now I am closer to a final solution to fix bug [https://bugs.kde.org/show_bug.cgi?id=278411]. Since it's a bugfix, I'd like to have allowed for 2.4. For your information (and comments) I'd like to openly note things relevant to the deployment side. If you are interested, please read sections 'Ensuring Kexi is built with capable version of libsqlite3' and 'How to deal with incapable libsqlite3 versions?'. http://community.kde.org/Kexi/KexiDB/KexiDB_Drivers/SQLite#Ensuring_Kexi_is_built_with_capable_version_of_libsqlite3 http://community.kde.org/Kexi/KexiDB/KexiDB_Drivers/SQLite#How_to_deal_with_incapable_libsqlite3_versions.3F After I commit the solution let's be aware that on 'noncapable' libsqlite3 cmake can refuse kexi from building 'thanks to' the detailed checks I am adding. So looking in advance the 'Alternative solution' for some distros (and their versions) is to deliver copy of 'capable' libsqlite3, non-conflicting with the 'system' one, before the distros catch up. I am considering having a fallback copy of libsqlite3 code properly configured in a 3rdparty/ directory of kexi, which would be compiled _only_ if libsqlite3 is found in a proper version but is not 'capable' to handle unicode collations. Dedicated warning would be displayed too. This effort also prepares ground for introducing other features that require extensions, e.g. engine-side scripting or custom types. The same will be done in Predicate libs [http://community.kde.org/Predicate] that sooner or later will replace KexiDB. On the other hand it would be interesting to know from Roger (CC'd) or other sqlite people what they think about enabling extensions by default in libsqlite3. Some people building libsqlite3 may overlook the fact that this option is disabled by default and thus any extensions are also disabled. -- regards / pozdrawiam, Jaroslaw Staniek http://www.linkedin.com/in/jstaniek Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) KDE Software Development Platform on MS Windows (windows.kde.org) _______________________________________________ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
