PyDbLite

PyDbLite is:

• a fast, pure-Python, untyped, in-memory database engine, compatible with Python 2.3 and above, using Python syntax to manage data, instead of SQL
• a pythonic interface to SQLite (SQLite adapter) and MySQL, using the same syntax as the pure-Python engine for most operations (except database connection and table creation because of each database specificities)

To install the package, just download it and install it by running

python setup.py install

Compatibillity

Supported systems: Any

Supported Python versions: 2.6, 2.7, 3.3, 3.4

• Pure-Python engine
  • Create or open a database
  • Insert, update, delete a record
    • insert a new record
  • Selection
    • to iterate on all the records
    • Direct access
    • Simple selections
  • List comprehension
  • Index
  • Other attributes and methods
• SQLite adapter
  • Database
  • Table
    • Type conversion
    • cursor and commit
• API
  • PyDbLite.PyDbLite API
  • PyDbLite.SQLite API
  • PyDbLite.common API
• Example code
  • Pure Python
  • SQLite

Indices and tables

• Index
• Module Index
• Search Page