Welcome to SimpleSQLite’s documentation!

Table of Contents

• 1. SimpleSQLite
  • 1.1. Summary
  • 1.2. Features
• 2. Installation
  • 2.1. Install from PyPI
  • 2.2. Install from PPA (for Ubuntu)
• 3. Dependencies
  • 3.1. Optional Dependencies
• 4. Examples
  • 4.1. Create table
    • 4.1.1. Create a table from data matrix
    • 4.1.2. Create a table from CSV
    • 4.1.3. Create table(s) from JSON
    • 4.1.4. Create a table from pandas DataFrame
    • 4.1.5. Create table(s) from Excel
    • 4.1.6. Create table(s) from Google Sheets
  • 4.2. Insert records into a table
    • 4.2.1. Insert dictionary
    • 4.2.2. Insert list/tuple/namedtuple
  • 4.3. Update a record in a table
  • 4.4. Get Data from a Table
    • 4.4.1. Get Data from a table as OrderedDict
    • 4.4.2. Get Data from a table as pandas DataFrame
  • 4.5. ORM functionality
  • 4.6. Profiling
  • 4.7. Make an in-memory database
• 5. Reference
  • 5.1. SimpleSQLite class
  • 5.2. Query classes
  • 5.3. Functions
  • 5.4. Errors
• 6. Changelog
• 7. Sponsors
• 8. Indices and tables
• 9. Links
  • 9.1. Related project

Indices and tables

• Index