- Check it's already there
sqlite3 --versionmacOS comes with SQLite. For the newest version, run brew install sqlite.
- Create a database and try it
sqlite3 test.db "CREATE TABLE notes(id INTEGER PRIMARY KEY, text TEXT); INSERT INTO notes(text) VALUES ('hello'); SELECT * FROM notes;"
Check it worked
- Check the version
sqlite3 --version
- Install SQLiteNeeds sudo
sudo apt install -y sqlite3 - Create a database and try it
sqlite3 test.db "CREATE TABLE notes(id INTEGER PRIMARY KEY, text TEXT); INSERT INTO notes(text) VALUES ('hello'); SELECT * FROM notes;"
Check it worked
- Check the version
sqlite3 --version
Undo it
- Uninstall SQLiteNeeds sudo
sudo apt remove -y sqlite3
- Install SQLite
winget install SQLite.SQLiteClose and reopen PowerShell afterwards.
- Create a database and try it
sqlite3 test.db "CREATE TABLE notes(id INTEGER PRIMARY KEY, text TEXT); INSERT INTO notes(text) VALUES ('hello'); SELECT * FROM notes;"
Check it worked
- Check the version
sqlite3 --version
Undo it
- Uninstall SQLite
winget uninstall SQLite.SQLite