Possible open source project for PostgreSQL
I'm interested in starting an open source project to build a nice
server management interface for PostgreSQL using LispWorks and CAPI.
PostgreSQL is an excellent database, but setup and operation can be
pretty daunting. The first Windows native version of PostgreSQL 8.0 was
released a few days ago and people are still having problems getting
started despite a standard Windows installer.
In addition to being something very useful, I think a project like this
would bring some nice visibility to Lisp and LispWorks. Send me an
email (or to the list) if you might be interested in participating.
Include what LispWorks OS platform(s) you work with and perhaps what
aspects of the project you would be interested in. If you would like to
contribute financially or in some other way to the project, that would
be nice too :).
I have included an outline below which summarizes my thinking on
building a PostgreSQL server interface.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
=====
+ Summary
+ 1 minute installation (PostgreSQL included with application)
- drag single application/folder to the hard drive (installer on
Windows since it is expected)
- launch application
- specify database cluster folder
- create a database
- ready for local connection
+ basic features
- start/stop server
- database configuration (postgresql.conf)
- monitor logs and server status
- backup/restore
- run periodic tasks
- access control (users/groups, pg_hba.conf)
- feature to assist with application upgrades when dump/reload is
needed
+ tasks
+ parse conf files and build interfaces
- so many options, we probably want basic and expert interfaces
+ build Lisp interfaces for PostgreSQL tools
- pg_dump, pg_restore, initdb, createdb, etc.
- design a nice interfaces to tie everything together
+ other features and (way out) ideas
- integration with Portable AllegroServe or other Lisp web server
(separate build)
+ perform installation as a service without GUI
- could still use console version of LispWorks for monitoring,
backup, etc.
+ Lisp as server PL programming language
- maybe ECL or some other Lisp would be better suited for this
- autonomic computing features (see
http://www.research.ibm.com/autonomic/overview/)
+ license
- LLGPL like AllegroServe