[Koha] MySQL and foreign keys

Marco Gaiarin gaio at sv.lnf.it
Fri Jan 17 02:09:23 NZDT 2003

Mandi! paul POULAIN
  In chel di` si favelave...

> 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.


No, but pg, as often in GNU programs, have regexp. ;)

I think it is not the case to fight against one or other DBMS, simply
wrote down a correct relational database schema in normal form, and put
inside as standard as possible SQL instructions, for the rest using
specialized instructions case()ing on the DBMS type.

As suggested.

dott. Marco Gaiarin				    GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  gaio(at)sv.lnf.it		tel +39-0434-842711    fax +39-0434-842797

			  Difendiamo PeaceLink!
     Campagna di solidarietà per la tutela legale di una voce scomoda.

More information about the Koha mailing list