Hi all, I have been working on porting Koha to run over PostgreSQL. (We run Postgres on our backside with several apps currently and will be adding others, so you know something of my motive here.) In the process of the port, I have needed to distinguish between sql files for MySQL and PostgreSQL. I have been doing this by renaming sql files after this method: foo_mysql.sql foo_pg.sql This allows me to do things like '~ /_mysql\.sql/' etc. and import the correct flavor of sql. Since such a change would require cooperation, I thought I would submit it here to see what others think. I have no corner on the market, and I'm certainly open to anything that works with relative ease. -- Chris Nighswonger Faculty Member Network & Systems Director Foundations Bible College & Seminary www.foundations.edu www.fbcradio.org
Hi, On 11/8/07, Chris Nighswonger <cnighswonger@foundations.edu> wrote: [snip]
In the process of the port, I have needed to distinguish between sql files for MySQL and PostgreSQL. I have been doing this by renaming sql files after this method:
foo_mysql.sql foo_pg.sql
This allows me to do things like '~ /_mysql\.sql/' etc. and import the correct flavor of sql.
I would suggest setting up a directory tree for each DB engine, e.g., installer/data/mysql [../en/mandatory/..., e.g.] installer/data/postgres That way, install.pl only needs to point to the correct directory, instead of munging each file name, and we don't have to rename the existing SQL scripts, just move them. Regards, Galen -- Galen Charlton Koha Application Developer LibLime galen.charlton@liblime.com p: 1-888-564-2457
On 11/8/07, Galen Charlton <galen.charlton@liblime.com> wrote:
I would suggest setting up a directory tree for each DB engine, e.g.,
installer/data/mysql [../en/mandatory/..., e.g.] installer/data/postgres
Here's what I'm planning: installer/data/$info{dbms}/.... any objections/improvements/better ways/etc... ? tnx -- Chris Nighswonger Faculty Member Network & Systems Director Foundations Bible College & Seminary www.foundations.edu www.fbcradio.org
Hi, On 11/9/07, Chris Nighswonger <cnighswonger@foundations.edu> wrote:
Here's what I'm planning:
installer/data/$info{dbms}/....
any objections/improvements/better ways/etc... ?
Along with this, kohastructure.sql will need to be copied/moved, e.g., installer/$info{dbms}/kohastructure.sql, along with updatedatabase. Regards, Galen -- Galen Charlton Koha Application Developer LibLime galen.charlton@liblime.com p: 1-888-564-2457
On 11/9/07, Galen Charlton <galen.charlton@liblime.com> wrote:
Hi,
On 11/9/07, Chris Nighswonger <cnighswonger@foundations.edu> wrote:
Here's what I'm planning:
installer/data/$info{dbms}/....
any objections/improvements/better ways/etc... ?
Along with this, kohastructure.sql will need to be copied/moved, e.g., installer/$info{dbms}/kohastructure.sql, along with updatedatabase.
Does sample_only_param_tables.sql have any relevance to updating db? -- Chris Nighswonger Faculty Member Network & Systems Director Foundations Bible College & Seminary www.foundations.edu www.fbcradio.org
participants (2)
-
Chris Nighswonger -
Galen Charlton