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

2012-02-22 Thread Paul Poulain
Le 22/02/2012 00:49, Chris Nighswonger a écrit : > I also agree with Colin. Lets go with invoices and work from there > toward ridding the db of prefixed table names. Colin, Galen, Chris_n, i've added your voice to "Remove all prefix" option. It seems we have almost reached a consensus, only Zeno w

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

2012-02-21 Thread Chris Nighswonger
On Tue, Feb 21, 2012 at 10:09 AM, Colin Campbell < colin.campb...@ptfs-europe.com> wrote: > On Tue, Feb 21, 2012 at 02:08:07PM +0100, Paul Poulain wrote: > > > > My proposal is that we should go the easiest way: > > * for now, the table should be called "aqinvoices", to be consistent > > with othe

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

2012-02-21 Thread Galen Charlton
Hi, On Feb 21, 2012, at 10:09 AM, Colin Campbell wrote: > Why not just invoices, I think the prefixes are superfluous ( orders > invoices etc are relevant objects outside of acquisition, serials uses > them for instance and we dont need to distinguish them from some other > type of order ) But jus

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

2012-02-21 Thread Colin Campbell
On Tue, Feb 21, 2012 at 02:08:07PM +0100, Paul Poulain wrote: > > > My proposal is that we should go the easiest way: > > * for now, the table

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

2012-02-21 Thread tajoli
Hi to all, >- Messaggio originale - >Da: "Paul Poulain" >Oggetto: Re: [Koha-devel] [Discussion tech] database table naming Le 10/02/2012 11:44, Paul Poulain a écrit : > The possible options are on > http://wiki.koha-community.org/wiki/Table_naming, let's s

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

2012-02-21 Thread Owen Leonard
> My proposal is that we should go the easiest way: > * for now, the table should be called "aqinvoices", to be consistent > with other acquisitions related tables. > * in the medium/long term, get rid of any prefix, and rename "aq*" tables. I think this is a good plan. While the other "aq" prefix

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

2012-02-21 Thread Paul Poulain
Le 21/02/2012 14:40, Marcel de Rooy a écrit : > Why not call it invoices, and be not consistent with an inconsistency? The 1st patch was without the "aq" and some noticed this inconsistency... Overall I think it's more consistent to have the "aq" for now. > Renaming all aq tables is theoretically

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

2012-02-21 Thread Marcel de Rooy
] namens Paul Poulain [paul.poul...@biblibre.com] Verzonden: dinsdag 21 februari 2012 14:08 To: koha-devel@lists.koha-community.org Onderwerp: Re: [Koha-devel] [Discussion tech] database table naming Le 10/02/2012 11:44, Paul Poulain a écrit : > The possible options are on > http://wik

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

2012-02-21 Thread Paul Poulain
Le 10/02/2012 11:44, Paul Poulain a écrit : > The possible options are on > http://wiki.koha-community.org/wiki/Table_naming, let's start the > discussion ! Back to this thread... as it seems that no-one want to start the discussion. My proposal is that we should go the easiest way: * for now, th

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

2012-02-14 Thread Robin Sheat
Op 15-02-12 08:46, Marc Balmer schreef: > Oh, I was not suggesting using MySQL databases like PostgreSQL schemas, > I was merely pointing out the similarity. Oh good :) from the SQL level, they are reasonably similar. Robin. signature.asc Description: OpenPGP digital signature

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

2012-02-14 Thread Marc Balmer
Am 14.02.12 20:41, schrieb Robin Sheat: > Op 15-02-12 08:37, Marc Balmer schreef: >> Turns out that MySQL indeed has no schema support. But it supports >> cross-database-queries. >> >> A "database" in MySQL is very similar, if not the same, as a "schema" in >> PostgreSQL. > > Noo, not quite. I me

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

2012-02-14 Thread Robin Sheat
Op 15-02-12 08:37, Marc Balmer schreef: > Turns out that MySQL indeed has no schema support. But it supports > cross-database-queries. > > A "database" in MySQL is very similar, if not the same, as a "schema" in > PostgreSQL. Noo, not quite. I mean, they can be used like that, but I would be str

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

2012-02-14 Thread Marc Balmer
Am 14.02.12 20:34, schrieb Marc Balmer: > Am 14.02.12 15:10, schrieb Paul Poulain: >> Le 10/02/2012 12:14, Marc Balmer a écrit : >>> afaik, both MySQL and PostgreSQL support schemas. >> I couldn't find how it works on mySQL. Does anyone have a link with some >> explanation ? > > I will try to find

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

2012-02-14 Thread Marc Balmer
Am 14.02.12 15:10, schrieb Paul Poulain: > Le 10/02/2012 12:14, Marc Balmer a écrit : >> afaik, both MySQL and PostgreSQL support schemas. > I couldn't find how it works on mySQL. Does anyone have a link with some > explanation ? I will try to find out. Maybe a topic for discussions in Marseille.

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

2012-02-14 Thread Paul Poulain
Le 10/02/2012 12:14, Marc Balmer a écrit : > afaik, both MySQL and PostgreSQL support schemas. I couldn't find how it works on mySQL. Does anyone have a link with some explanation ? -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 ___

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

2012-02-10 Thread 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 journe

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

2012-02-10 Thread Marc Balmer
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 sta

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

2012-02-10 Thread 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