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 --
Attachment:
signature.asc
Description: Digital signature