What's Next?

Congratulations

You have completed all 15 lessons. You now understand SQLite's fundamentals: querying, filtering, sorting, schema management, CRUD operations, joins, aggregations, CTEs, window functions, and JSON.

What to Explore Next

• Full-text search -- SQLite's FTS5 extension for fast text search.
• Virtual tables -- Custom table implementations (CSV files, R-tree spatial indexes).
• WAL mode -- Write-Ahead Logging for better concurrent read performance.
• Transactions -- BEGIN/COMMIT/ROLLBACK and SAVEPOINT for atomicity.
• Indexes -- CREATE INDEX, covering indexes, and EXPLAIN QUERY PLAN.

Use SQLite in Your Projects

• Bun -- import { Database } from "bun:sqlite" — the fastest SQLite API in any runtime.
• Python -- import sqlite3 — in the standard library, zero install.
• Node.js -- better-sqlite3 or @libsql/client for async remote SQLite (Turso).
• Go -- github.com/mattn/go-sqlite3 or the pure-Go modernc.org/sqlite.

References

• SQLite Official Documentation — thorough and well-organized.
• SQLite Tutorial — practical examples.
• Bun SQLite docs — fastest SQLite API in JS/TS.