[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Good front end for small postgress dtabases?

> On Mon, Dec 29, 2003 at 04:23:26PM -0500 or thereabouts, Bob Billson wrote:
> > On Fri, Dec 26, 2003 at 01:15:54PM -0500, Paul Morgan penned:
[I don't have the original post -- not sure who quoted what]
> > > > I need to create some small databses in postgress (christmas card list,
> > > > household inventory). What choices do I have for creating user input forms,
> > > > and reports in Debian?
> > > 
> > > pgaccess

I keep some simple lists: dates, tasks, books I read/want/own, account 
details.  In the spirit of Unix, my first intuition was just created a 
file named "data" and add one "record" per line in a reasonably 
structured way.  I parsed it with perl and printed it with a2ps.

Then, I tried 4000 ways in Debian to do it better: I tried all the 
postgres/mysql front-ends, outlook knockoffs, console-only things 
written in ruby, &c.  I hated all of them.

So I spent most of 2003 writing my own in my spare time.
Here's a screenshot:

It stores data in XML, is intended for small databases, single user, but 
it's indexed and has referential integrity.  There's keyboard shortcuts 
for everything.  It starts fast, it's fast to navigate and slam in some 
data, hit save and get out.

It's my own build system: all you start with is some C files, no 
makefiles at all.  One file is called proj.c: type "gcc proj.c; ./a.out; 
./proj" and it does all the automakish stuff.  Type "./proj c" and it 
deletes that crap and you just have a flat list of C files.  It's pretty 
cheasy but I like it.

Over the course of the year I started over 20 times, but around October 
I got inspired and got something that works.  I guess I have to open the 
kimino now so y'all can tell me how much it sucks before I can get to 
the "next level":

Here it is.  Be nice with your comments please.  It meets its design 
goals -- they are probably not the design goals you expect -- I'm a 
pretty wierd guy, you'll probably think it's super-wierd:


Reply to: