Python logo

Table of Contents

  • sqlite3 — DB-API 2.0 interface for SQLite databases
    • Tutorial
    • Reference
      • Module functions
      • Module constants
      • Connection objects
      • Cursor objects
      • Row objects
      • Blob objects
      • PrepareProtocol objects
      • Exceptions
      • SQLite and Python types
      • Default adapters and converters (deprecated)
      • Command-line interface
    • How-to guides
      • How to use placeholders to bind values in SQL queries
      • How to adapt custom Python types to SQLite values
        • How to write adaptable objects
        • How to register adapter callables
      • How to convert SQLite values to custom Python types
      • Adapter and converter recipes
      • How to use connection shortcut methods
      • How to use the connection context manager
      • How to work with SQLite URIs
      • How to create and use row factories
      • How to handle non-UTF-8 text encodings
    • Explanation
      • Transaction control
        • Transaction control via the autocommit attribute
        • Transaction control via the isolation_level attribute

Previous topic

dbm — Interfaces to Unix “databases”

Next topic

Data Compression and Archiving