[dev] Do we need database scripts?

[Rich Lafferty]

On Sat, Dec 22, 2001 at 10:10:26PM -0500, Chuck Hagenbuch (chuck@horde.org) wrote:
> Quoting Rich Lafferty <rich@horde.org>:
> 
> > That I'm encountering much difficulty documenting the
> > database-creation steps of Horde suggests to me that 
> > there's something missing.
> > 
> > What shall we do? Right now, the bits in scripts/db/
> > are written for developers. :-) I like having scripts available, but I
> > think we need more duplication -- instead of separate files for auth
> > and prefs and so on, I'd like to provide scripts that do everything
> > for a particular database -- i.e., a "mysql-create.sql" and a
> > "pgsql-create.sql" and so on, instead of "prefs.sql" and friends.
> > 
> > Does that seem like a good approach? 
> 
> Alright, this is slightly more work-intensive, but:
> 
> What about every app that uses SQL includes scripts for the table
> creation that a generic Horde tool can use to create those tables?
> We're not going to write ourselves phpMyAdmin, but something to
> manage tables could be really useful...

I don't know that I like telling users to give their administrative
database password to a Web application. It works for the MySQL users
but not the Oracle users, in other words. :-)

More practically, I don't think it works with the release schedule,
unless you see a quick way to get it working.

  -Rich

-- 
Rich Lafferty --------------+-----------------------------------------------
 Ottawa, Ontario, Canada    |  Save the Pacific Northwest Tree Octopus!
 http://www.lafferty.ca/    |    http://zapatopi.net/treeoctopus.html
rich@lafferty.ca -----------+-----------------------------------------------