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 a 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
    • SimpleSQLite
      • SimpleSQLite.check_connection()
      • SimpleSQLite.close()
      • SimpleSQLite.commit()
      • SimpleSQLite.connect()
      • SimpleSQLite.connection
      • SimpleSQLite.create_index()
      • SimpleSQLite.create_index_list()
      • SimpleSQLite.create_table()
      • SimpleSQLite.create_table_from_csv()
      • SimpleSQLite.create_table_from_data_matrix()
      • SimpleSQLite.create_table_from_dataframe()
      • SimpleSQLite.create_table_from_json()
      • SimpleSQLite.create_table_from_tabledata()
      • SimpleSQLite.database_path
      • SimpleSQLite.delete()
      • SimpleSQLite.drop_table()
      • SimpleSQLite.execute_query()
      • SimpleSQLite.fetch_attr_names()
      • SimpleSQLite.fetch_attr_type()
      • SimpleSQLite.fetch_num_records()
      • SimpleSQLite.fetch_sqlite_master()
      • SimpleSQLite.fetch_table_names()
      • SimpleSQLite.fetch_value()
      • SimpleSQLite.fetch_view_names()
      • SimpleSQLite.get_profile()
      • SimpleSQLite.has_attr()
      • SimpleSQLite.has_attrs()
      • SimpleSQLite.has_table()
      • SimpleSQLite.has_view()
      • SimpleSQLite.insert()
      • SimpleSQLite.insert_many()
      • SimpleSQLite.is_connected()
      • SimpleSQLite.mode
      • SimpleSQLite.rollback()
      • SimpleSQLite.select()
      • SimpleSQLite.select_as_dataframe()
      • SimpleSQLite.select_as_dict()
      • SimpleSQLite.select_as_memdb()
      • SimpleSQLite.select_as_tabledata()
      • SimpleSQLite.set_row_factory()
      • SimpleSQLite.total_changes
      • SimpleSQLite.update()
      • SimpleSQLite.validate_access_permission()
      • SimpleSQLite.verify_attr_existence()
      • SimpleSQLite.verify_table_existence()
  • 5.2. Query classes
    • Table
      • Table.to_query()
    • Attr
      • Attr.sanitize()
      • Attr.to_query()
    • AttrList
      • AttrList.append()
      • AttrList.sanitize()
      • AttrList.to_query()
    • Value
      • Value.to_query()
    • Where
      • Where.key
      • Where.to_query()
      • Where.value
    • Select
      • Select.to_query()
    • And
      • And.to_query()
    • Or
      • Or.to_query()
  • 5.3. Functions
    • append_table()
    • copy_table()
    • connect_memdb()
  • 5.4. Errors
    • DatabaseError
    • NullDatabaseConnectionError
    • TableNotFoundError
    • AttributeNotFoundError
    • SqlSyntaxError
    • OperationalError
• 6. Changelog
• 7. Sponsors
• 8. Indices and tables
• 9. Links
  • 9.1. Related project

Indices and tables

• Index