tools for MySQL-based web sites

am 10.06.2003 14:36:16 von Dave Howorth

I'm building a MySQL database that will be published to a website, and
I'm looking for good ways to (a) publish it and (b) enter the
information and maintain it. The rest of the system is in Perl, hence my
posting the question here. Here's some more information:

data structure
--------------
- mostly text based
- most data entered by hand, some automatically loaded
- links between items (mostly a tree but a DAG when inspected closely)
- enumerated types (with extensible enumerations)

requirements
-------------
- build HTML pages from db (main method of use).
- output XML documents from db (dumps of subsets of the content).
- enter and maintain via simple user interface, with as much of the
interface derived from the db content as possible. Could be HTML forms
or something else (e.g. X-based GUI)

other
-----
I'm running on Linux with Apache.
Not wedded to Perl if there are better solutions elsewhere.
I'd prefer free software (in both senses of free).

I'd welcome any thoughts anybody has.

Thanks and regards,
Dave

--
Dave Howorth
MRC Centre for Protein Engineering
Hills Road, Cambridge, CB2 2QH
01223 252960

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: tools for MySQL-based web sites

am 10.06.2003 15:05:14 von Martin Vernooij

Well it's not XML, but your other requirements might pretty well be
fullfilled with WebGUI. It's GPL licensed CMS and has many (active)
users. I use it myself to build websites for customers and haven't found
limitations which could not be solved.
You can find WebGUI at http://www.plainblack.com.

HTH,

Martin.

> -----Original Message-----
> From: Dave Howorth [mailto:dhoworth@mrc-lmb.cam.ac.uk]
> Sent: dinsdag 10 juni 2003 14:36
> To: perl@lists.mysql.com
> Subject: tools for MySQL-based web sites
>
>
> I'm building a MySQL database that will be published to a
> website, and
> I'm looking for good ways to (a) publish it and (b) enter the
> information and maintain it. The rest of the system is in
> Perl, hence my
> posting the question here. Here's some more information:
>
> data structure
> --------------
> - mostly text based
> - most data entered by hand, some automatically loaded
> - links between items (mostly a tree but a DAG when inspected closely)
> - enumerated types (with extensible enumerations)
>
> requirements
> -------------
> - build HTML pages from db (main method of use).
> - output XML documents from db (dumps of subsets of the content).
> - enter and maintain via simple user interface, with as much of the
> interface derived from the db content as possible. Could be
> HTML forms
> or something else (e.g. X-based GUI)
>
> other
> -----
> I'm running on Linux with Apache.
> Not wedded to Perl if there are better solutions elsewhere.
> I'd prefer free software (in both senses of free).
>
> I'd welcome any thoughts anybody has.
>
> Thanks and regards,
> Dave
>
> --
> Dave Howorth
> MRC Centre for Protein Engineering
> Hills Road, Cambridge, CB2 2QH
> 01223 252960
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
> http://lists.mysql.com/perl?unsub=martin.vernooij@tiempo.nl
>
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: tools for MySQL-based web sites

am 10.06.2003 15:05:14 von Martin Vernooij