Lisp HUG Maillist Archive

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 


Updated at: 2020-12-10 08:53 UTC