DBD SQLite2 0.33

DBD SQLite2 is a public domain RDBMS database engine.
SQLite is a small fast embedded SQL database engine.

DBD::SQLite2 embeds that database engine into a DBD driver, so if you want a relational database for your project, but don't want to install a large RDBMS system like MySQL or PostgreSQL, then DBD::SQLite2 may be just what you need.

Note: DBD::SQLite2 is the u need. &on of DBD::SQLite, and embeds version 2.x.x of the sqlite library. The current version of DBD::SQLite embeds version 3 (or possibly later if I forget to update this file). This release is designed to allow you to have both versions installed on the same system.

SQLite supports quite a lot of features, such as transactions (atomic commit and rollback), indexes, DBA-free operation, a large subset of SQL92 supported, and more.

Installation requires a compiler.

The engine is very fast, but for updates/inserts/dml it does perform a global lock on the entire database. This, obviously, might not be good for multiple user systems. So beware. The database also appears to be significantly faster if your transactions are coarse. One performance benchmark I did was inserting 100_000 rows into the database - with AutoCommit on it was doing about 50 rows per second. When I turned AutoCommit off it went up to 1000 rows per second.

last updated on:
June 11th, 2007, 9:26 GMT
price:
FREE!
developed by:
Matt Sergeant
homepage:
cpan.uwinnipeg.ca
license type:
Other Free / Open Source License
operating system(s):
Windows / Linux / Mac OS / BSD / Solaris
category:
C: \ Modules

FREE!

In a hurry? Add it to your Download Basket!

user rating 18

4.1/5
 

0/5

Rate it!

Add your review!

SUBMIT