SQLite7

SQLite7 is a DB-API 2.0 style interface for SQLite databases backed directly by the SQLite C library, with both synchronous and asynchronous APIs.

This documentation is organized into four main sections:

• Tutorial teaches the core workflow for opening a database, creating tables, inserting data, and querying rows.

• Reference describes the classes, functions, constants, and exceptions provided by sqlite7.

• How-to guides show how to perform focused tasks such as binding placeholders, working with row factories, and using transactions.

• Explanation provides background on the native backend design and transaction behavior.

Tutorial

• Tutorial
  • Open a database
  • Create a table
  • Insert rows
  • Query rows
  • Use table helpers
  • Work with transactions
  • Close the database
  • Async example

Reference

• Module reference
  • Connection helpers
  • SQL parsing helper
  • Main classes
  • Constants
• Top-level helpers
  • open_db(path, **kwargs)
  • connect(path, **kwargs)
  • open_async(path, **kwargs)
  • connect_async(path, **kwargs)
• Database
  • Constructor
  • Connection and lifecycle
  • Running SQL directly
  • Fetching data from raw SQL
  • High-level query helpers
  • Transactions and durability
  • Introspection and advanced features
  • State and metadata
• Table
  • Lifecycle and shared connection behavior
  • Advanced pass-through methods
  • Raw SQL helpers
  • Table-oriented read helpers
  • Table-oriented write helpers
  • State and metadata
• Result Types
  • StatementResult
  • RowDict
• Exceptions
  • Base exceptions
  • SQLite-like subclasses
  • sqlite7-specific subclasses
  • Example
• SQLite Compatibility Exports
  • Example
• Conflict Policies
  • Example

How-to guides

• How to use placeholders to bind values in SQL queries
• How to create and use row factories
• How to use transactions

Explanation

• Transaction control
• How sqlite7 Works
• Features
• Best Practices
• Installation
• License