Complete Intro to SQLite

Watch on Frontend Masters

Complete Intro to SQLite

A quick and complete intro to building on SQLite

author image
Brian Holt
Neon
course icon
Watch on Frontend Masters

Table of Contents

  1. Welcome

    1. Intro
    2. What is SQLite?

  2. Running SQLite

    1. Installing SQLite
    2. Getting Started

  3. Basic SQL

    1. SELECT
    2. INSERT
    3. Tables

  4. Intermediate SQL

    1. Relational Data
    2. Other Types of Joins
    3. Foreign Keys
    4. Aggregation
    5. Subqueries

  5. Build a Project with Node.js and SQLite

    1. The Example App
    2. sqlite3
    3. Project
    4. Alternatives to sqlite3

  6. What is Unique to SQLite

    1. Flexible Typing
    2. Limits of SQLite
    3. Views

  7. Performance and Search

    1. EXPLAIN
    2. Indexes
    3. Full Text Search

  8. JSON

    1. SQLite Extensions
    2. JSON
    3. jsonb
    4. More Advance Queries

  9. Scaling SQLite

    1. Backups
    2. Replication
    3. libSQL
    4. Local First

  10. Conclusion

    1. Recap