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@msys.ch <mailto:marc@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@lists.koha-community.org <mailto:Koha-devel@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