Re: [cgiapp] Re: "Best free DB for a web-based Perl app"response results...

Robert Hicks wrote:

> "... if i only needed MySQL, i'd use SQL Lite."
>
> Really? I think that would be a poor choice and I like SQLite. ; )

SQLite is an embedded database or at least that is how it is primarily used.
Both Apple and RealBasic are using SQLite as a part of there latest
persistence engines and I'm sure there are more companies solving client
side data issue that have done the same.

At a recent previous job, we created a web based system that installed both
the web server and database on a desktop/laptop. The system requirements
for the system needed to be low enough to run on a windows 95 box with 64 MB
of RAM. The system was a derivative of another complete system that ran on
top of MS SQL and I was able to port it to SQLite with little effort to
greatly reduce installation and licensing issues along with system
requirements.

If you are planning on creating a system that will have low concurrent usage
you will be well served by SQLite but if you plan on making something that
will be hit hard then you will likely need to move to a bigger database
package.

--
David Steinbrunner