Package: libdbd-sqlite2-perl (2:0.38-1 and others)

Perl DBI driver with a self-contained RDBMS (SQLite2 version)

The DBD::SQLite2 module embeds a small fast embedded SQL database engine called SQLite into a DBI driver, 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::SQLite may be just what you need.

SQLite supports the following features:

 * Implements a large subset of SQL92
   See http://www.hwaci.com/sw/sqlite/lang.html for details.

 * A complete DB in a single disk file
   Everything for your database is stored in a single disk file, making it
   easier to move things around than with DBD::CSV.

 * Atomic commit and rollback

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.

Tags: Software Development: Perl Development, SQL, Függvény-könyvtárak, Implemented in: implemented-in::c, implemented-in::perl, Role: Development Library, Works with: Databases

This page is also available in the following languages (How to set the default document language):