SQLite cheat sheet

Keep this list of common SQLite commands nearby.

SQLite is an infinitely useful self-contained, portable, open source database. Using SQLite makes it easy to create, parse, query, modify, and transport data. Learning to use it interactively is a great first step toward managing it for web applications or using it through programming language libraries.