At 5:02 PM -0800 11/29/05, John Armstrong wrote:
Hi - I'm soon to be doing a Perl app on the Internet, that'll need
database. We want the db to be as "free" as possible, but still fully
multi-user (web-based). Would the best route be MySql on Linux? Random
access files? Something else? We want no licensing obligations (no Oracle,
Sequal Server, etc.). We want to go with Perl because it's the best
programming language invented by humans.
If you want something that's trivially easy to use, try SQLite.
The database manager is embedded in the DBD::SQLite module itself,
and you have no separate server processes to maintain, and you can
specify a database's storage location like an ordinary file.
Its also faster than anything else for some types of usage, and
unlike many typical MySQL setups, it is fully transactional, ACID
compliant, and safe.
Certain kinds of usage with many writing processes may be slow,
though, since only one active writer can access a SQLite database at
once.
SQLite is also public domain, which is about as liberty as you can get.
-- Darren Duncan
