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 <m...@msys.ch > <mailto:m...@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 _______________________________________________ Koha-devel mailing list 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/
