Working with SQLite

SQLite is a lightweight file based database that supports SQL queries. Create a new SQLite database in the container and execute some commands against it.

  • Open the integrated terminal and browse to "/"

  • Create a folder called "data"

  • Move into that folder and create a new SQLite database with sqlite3 lamp.db

  • Connect to the database with the SQLite Extension

  • Create a new table called "colors"

  • Insert a few records

  • Select the records back out

Last updated