Re: [Koha-devel] full text search

[Francisco M. Marzoa Alonso]

On Tuesday 10 December 2002 11:23, Chris Cormack wrote:

>
> When you distribute a non-GPL application that only works with the MySQL
> software and ship it with the MySQL software. This type of solution is
> actually considered to be linking even if it's done over a network.
>
> Since we neither ship Koha with MySQL, nor is Koha non-GPL. The license is
> not an issue. And Koha and MySQL being GPLd prevents it from ever becoming
> one.
>
> The technical constraint is the actual issue, and im not against binding
> koha to specific db in principle.
> If the benefits gained are such to warrant the disadvantages.

I think there's still a chance to mantain koha indepedent from a database 
engine while using specific database engine optimizations: A new abstraction 
layer may be created in places where optimizations are used. This layer could 
be implemented as a class. Something like this:

package Koha::Search

...

sub new {
        ...
}

sub search {
        $dbeng = shift;
        $keywords = shift;

        if (lc($dbeng) eq 'mysql') {
                # Perform search with mysql optimizations
        } elsif (lc ($dbeng) eq 'postgresql') {
                # Perform search with postgresql optimizations
        } elsif ...
                # Perform search with X database engine optimizations
        } else {
                # Use standard SQL
        }
}