SQLite

Summary:

• What is SQLite?
• Operations
• Joins vs Subqueries
• Flexive Types
• Limits of SQLite
• View
• EXPLAIN
• Indexes
• Full Text Search
• Working with JSON
• Scaling SQLite
  • Backups with Litestream
  • Replication with LiteFS
  • Sharding with Dqlite
• SQLite in the Client