On 2005-11-29 18:13:04 -0800, Darren Duncan wrote: > 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. > > If you want something that's trivially easy to use, try SQLite. [...] > 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.
Even worse, when a table is locked by one process, attempts to access it
from another result in an error. So it is entirely possible that an
application works fine during testing but bombs out spectacularly with a
higher workload. There are ways around that, but that default behaviour is
surprising for anyone who's used other RDBMSs before.
hp
--
_ | Peter J. Holzer | In our modern say,learn,know in a day
|_|_) | Sysadmin WSR | world, perhaps being an expert is an
| | | [EMAIL PROTECTED] | outdated concept.
__/ | http://www.hjp.at/ | -- Catharine Drozdowski on dbi-users.
pgpvb0THgf0gK.pgp
Description: PGP signature
