hi andreas, On Thu, Dec 02, 2004 at 10:32:50PM +0100, Andreas Tille wrote: > More questions on your version 0.7: > > - I asked in previous mail what to do for PostgreSQL support. While > having a quick view on the code I wonder if just using a variable > for the database server most of the code could be shared between > databases servers. Is this to naive?
most of the script stuff could be shared in between the two, yeah. i
designed the system such that it could eventually handle supporting
multiple database types, as well as packages that support multiple
database types themselves. then, i proceeded to start with what i know :)
currently, i'm using code from wwwconfig-common for doing the actual
db stuff, and there is pgsql support in that package, so i don't think
implementing pgsql support would be initially too hard.
> - The application I want to package (GnuMed) has a bootstrapping
> script using a configuration file which cares for installation
> of several SQL code files in the correct sequence. This
> bootstrap script has to know the database administrator password.
> Formerly I did this the following way
so dbconfig-common provides two hooks for running
install/bootstrap/upgrade code. the first is just a plain sql file,
the second is a shell script that can effectively do anything. i
have not tested the latter at all, but have written code that i
think will work. the dbconfig-common-using.html document provides
the details. however, in both cases i don't have it set up to run as
the database administrator, that was really a design choice and not a
limitation, and if it turns out it's not worth it i could have it run
as administrator instead.
> ...
> db_get gnumed/pgsql/admin-pass
> insert_passwd_into_temporary_config_file $RET
> bootstrap_gnumed_database --config temporary_config_file
> rm temporary_config_file
>
> My problem is now: How to address gnumed/pgsql/admin-pass in
> your dbconfig-common framework?
the big question in my mind is what about the package needs
administrative access? this might stem from my not understanding
differences between mysql and postgresql.
sean
--
signature.asc
Description: Digital signature
