Thank you Jason. Since I am new to WebWare I may be ignorant. I am planning
to develop an intranet that will be used by at lease 75-100 employees to use
a number of databases on MySQL. I would like to have the security,
flexibility and performance when developing this application.
Are there tutorials that will show me how to use WebWare with Apache,
Python, and MySQL. I am just reading and trying to configure WebWare at the
moment. Any help would be very much appreciated.
----- Original Message -----
From: "Jason Hildebrand" <jason@...>
To: "Mulugeta Maru" <mmaru@...>
Sent: Sunday, March 14, 2004 7:08 PM
Subject: Re: [Webware-discuss] Database Support
> On Sun, 2004-03-14 at 18:43, Mulugeta Maru wrote:
> > I am using MySQL and have installed MySQL Python API. I am not sure how
> > will work with Webware. Probably I am ahead of myself. I just want to
> > understand from the get go the Architecture clearly:
> > 1. Browser or XML-RPC
> > 2. Apache - Web Server
> > 3. WebKit - Application Server
> > 4. Servlets or PSPs - File System
> > Where does the database fit in the above architecture?
> Hi Maru,
> You have a several options for using MySQL with Webware:
> 1. You can access MySQL (using the python API) directly from a servlet or
> PSP to generate dynamic pages. This is probably your quickest and easiest
> option, but may not be as convenient or powerful in the long term.
> 2. You can make use of an object-relational mapping (ORM) to make
> your database objects easier, and/or to add logic to your database
> Webware includes an ORM called MiddleKit which I have been happy with,
> although it requires that you design your schema using MiddleKit.
> SQLObjects (http://sqlobject.org/) by Ian Bicking is also popular, and I
> believe it gives you more flexibility with respect to how you design your
> (I have not used it myself).
> Which option makes the most sense for you will depend on what kind of site
> you are developing -- we can probably give you better advice if you tell
> us what your plans are.