[Koha] MySQL and foreign keys

[paul POULAIN]

Marco Gaiarin a écrit:

>I hope that koha will be, sooner or later, a full db-indipendent
>project, so i can use my favourite DBMS, Postgres, but at the same
>time, and with more strenght ;), the DB schema have to be rewritten to
>be fully normalized and relational.
>[could just be this, i've simple not seen FOREIGN KEY statement in .sql
>file, i don't want to flame ;) ]
>
i've bad news for you Marco...

we have decided recently to go ... to a deepest mySQL dependency.
mySQL has a feature that doesn't exist in ANSI-SQL92 : full-text indexing.
It's a VERY usefull feature to seach into a biblio : you search "sun 
moon" and the db auto-search for title that could correspond. It's a 
VERY complicated thing to do manually *and* with indexed search.
(see : http://www.mysql.com/doc/en/Fulltext_Search.html)

If you know an ACID & free db doing this, don't hesitate to tell us, it 
would be a great news !
i worked with Interbase/Firebird 2 years ago, and don't remember such a 
feature.

-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)