Tutorials

• Overview
  • Installation
  • Standard SQLite3 Usage
  • Equivalent metro_db usage
    • Benefits
    • MetroDB
• Database Structure
  • SQL Limitations
  • Datatypes
    • Example
    • Custom Data Types
• Return Types
  • Rows
  • Flexible Iterators
• Queries & Commands
  • Raw SQL
    • Query One
    • Query
    • Execute
    • Execute Many
  • Errors
  • Python Powered SQL
    • Lookup
    • Generating Clauses
    • Lookup All
    • Select
    • Insert
    • Bulk Insert
    • Update
    • Unique Insert
    • Delete
  • Even Fancier SQL
    • Count
    • Dictionaries
    • Unique Counts
    • Sum
    • Delete Duplicates
• URI Tricks
  • Read Only
  • No Creation