[SQLite](https://www.sqlite.org/cli.html) is a lightweight, file-based database solution. ## Installation SQLite is distributed as [[sqlite3]], a core library with [[Python]], so there is no need to install anything. To use SQLite as a [[command line application]], download it [here](https://www.sqlite.org/download.html). ## Getting Started Before starting, set up a directory for your project using a [[project organization for databases]]. 1. Open [[Bash]] from the project folder. 2. Create a new database. ``` sqlite <databasename> ``` 3. The prompt will now show `sqlite >` to indicate you are in a SQLite interactive session. Use [[SQL]] commands to create tables, insert data, and make edits. See SQLite's [SQL documentation](https://www.sqlite.org/lang.html). See the [Getting Started guide](https://www.sqlite.org/cli.html) for more.