[plug] Writing a web based front end to a DB

[Denis Brown]

At 14:11 27/03/2003 +0800, Derek wrote:
> > If you've not done so already you might want to take a look at MRBS
> > (mrbs.sourceforge.net) which is quite a nice example, IMHO, of the sort of
> > thing you're talking about (PHP4 + MySQL or PostgreSQL).   Implements a
> > Meeting Room Booking System, but may give you some food for thought about
> > the pros / cons of the choice of language.
>
>Thanks for the link. I'd never even heard of that. Very interesting in
>relation to what I want to do.

Glad it was of interest :-)

There's quite a bit of web-accessible DB stuff which I have found handy as 
"tutorial" material when looking at various ideas for projects.  Some, like 
MRBS and Webcalendar*, are ready-made and sufficiently "round wheels" that 
I would not want to re-invent them.   Others, such as Notepad provide 
easily-digestible "recipes" upon which experimentation can be 
based.   Heck, there's even a fully-fledged psychiatric clinic suite -- 
billing, patient notes, payroll, medications, etc, etc -- that I came 
across one day, all web-accessible.   That used Perl and PostgreSQL, IIRC.

This was a thread or two last year some time on this list.  A check of the 
archives may turn up other links and advice.

Cheers,
Denis

* there are at least two "webcalendar" projects.  One on Sourceforge 
(version 0.9.something) uses PHP and MySQL / PostgreSQL.  Another (version 
2.8.5) comes from University of Texas and uses a flatfile structure and 
Perl.   A colleague who uses it, tell me it is heaps faster than the one on 
Sourceforge.   URL is www.ma.utexas.edu/users/mzou/webCal/