From: Kyle <kyle@actarg.com>
To: josh@agliodbs.com
Cc: pgsql-sql@postgresql.org
Subject: Project Development
Date: Thu, 05 Apr 2001 08:39:47 -0600
Message-ID: <3ACC83B3.E5D087@actarg.com> (raw)
Josh Berkus writes:
> That does bring up a related question: when are we gonna get
DROP
>COLUMN capability? Currently my tables are littered with unused
columns
>because I can't remove them without blowing my referential integrity
and
>views to heck.
Josh:
I've done some work on a solution to allow you to drop and rebuild your
db from scratch relatively painlessly. It enables you to munge portions
of the database, drop columns, undermine RI, clobber views, etc. and
then put the whole thing back together clean, fresh and perfect.
Pg_dump is focused on doing a drop/restore exactly. What is needed is a
way to drop/modify/restore. That's kind of what my tool enables you to
do (without the fear that you're going to lose some subtle detail of the
schema in the process).
It's a management tool that sits in between Postgres and your
application. You store chunks of SQL in a relational format that
describe your schema exactly. Then you can call those bits of SQL on
demand to destroy or build parts of the schema selectively. Because its
relational, you can store dependencies so the program knows which parts
of the DB to rebuild when you clobber something.
Right now, it is a handful of shell scripts and files, but we're using
it with good success at ATI. I have created an outline of how to do it
with a tcl/tk GUI and actually storing the SQL chunks in a Postgres
database.
I want to do some more development on it and then do a GPL release of
it. Problem is, I don't seem to find the time to get it all done. Are
you interested in collaborating on its development? Or do you know
someone who is?
BTW:
In addition to the management tool, I have also developed a complete
library that allows one to build an ERP around Postgres very quickly.
For example, a typical contact manager can be written in about 300-500
lines of code. A much more powerful version can be written in about
twice that much code.
Using the library, we have built a major chunk of our ERP which
includes: product design and specification, inventory management, order
entry, contact management, employee records, AP, payroll, purchasing,
shipping, etc.
Given the right conditions, I'd be willing to GPL this too. Anyone
interested in working on it?
Attachments:kyle.vcf (text/x-vcard, 184B) download
begin:vcard
n:Bateman;Kyle
x-mozilla-html:FALSE
org:Action Target Inc.
adr:;;;;;;
version:2.1
email;internet:kyle@actarg.com
title:President
x-mozilla-cpt:;0
fn:Kyle Bateman
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: kyle@actarg.com, josh@agliodbs.com
Subject: Re: Project Development
In-Reply-To: <3ACC83B3.E5D087@actarg.com>
References: <3ACC83B3.E5D087@actarg.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox