[Koha-devel] [Discussion tech] database table naming

[Marc Balmer]

Am 10.02.12 23:15, schrieb David Schuster:
> Where you the one working on getting Koha to work with postgres SQL? 

Yes.

> The School district I work for wants to see about making Koha work with
> SequelSQL(Microsoft)...

A bad choice.  Consider PostgreSQL.

> 
> What have you found in your journey that we should be aware of and
> thinking about to make Koha database agnostic?

Some shim layer in Perl will be needed to make Koha DB agnostic.  I plan
to work on this during the Marseille hackathon,

> 
> We did work with Moodle to make it agnostic in regards to DB storage.
> 
> On Fri, Feb 10, 2012 at 5:14 AM, Marc Balmer <marc at msys.ch
> <mailto:marc at msys.ch>> wrote:
> 
>     Am 10.02.12 11:44, schrieb Paul Poulain:
>     > Continuing with open discussion for the future of Koha:
>     >
>     > On the page http://wiki.koha-community.org/wiki/DB_schema_bugs, we
>     have
>     > referenced some inconsistencies on the database.
>     > One of them is about table naming : acquisition related tables all
>     start
>     > by aq, other tables don't have any prefix.
>     >
>     > OTOH, Julian has submitted a bug
>     > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5339 that
>     adds
>     > an "invoice" table, related to acquisitions, but don't has a aq
>     prefix.
>     >
>     > The possible options are on
>     > http://wiki.koha-community.org/wiki/Table_naming, let's start the
>     > discussion !
> 
>     A better (imo) move than prefixes would be to use DB schemas.  This way
>     related tables can be grouped in a schema, and default security can be
>     defined at the schema level (at least on PostgreSQL).
> 
>     afaik, both MySQL and PostgreSQL support schemas.
> 
>     _______________________________________________
>     Koha-devel mailing list
>     Koha-devel at lists.koha-community.org
>     <mailto:Koha-devel at lists.koha-community.org>
>     http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>     website : http://www.koha-community.org/
>     git : http://git.koha-community.org/
>     bugs : http://bugs.koha-community.org/
> 
> 
> 
> 
> -- 
> David Schuster
> Plano ISD
> Library Technology Coordinator