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.
Exercise
Answer
    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
    Open the integrated terminal with (Cmd/Ctrl + `)
    Move to the root directly of the container
1
cd /
Copied!
    Create a folder called "data"
1
mkdir data
Copied!
    Move into that new folder
1
cd data
Copied!
    Create a new SQLite database called "lamp"
1
sqlite3 lamp.db
Copied!
    Display the database that was created with the ".databases" command
1
.databases
Copied!
    Type .quit to exit the SQLite prompt
    Open the Command Prompt (Cmd/Ctrl + Shift + P)
    Select "SQLite: Open Database"
    Select "Choose database from file" in the prompt
    Type "/data/lamp.db" in the prompt
    Open the Explorer view (Cmd/Ctrl + Shift + E)
    Notice there is now a "SQLite Explorer" view
    Right-click the lamp.db database and select "New Query"
    Use the commands found in "sqlite.sql" in the project to...
      Create a table
      Insert a color
      Select a record
1
-- SQLite
2
CREATE TABLE colors (
3
id INTEGER PRIMARY KEY,
4
color TEXT NOT NULL
5
);
6
7
INSERT INTO colors (id, color) VALUES (1, 'Blue')
8
9
SELECT * FROM colors
Copied!
    Each block must be run by itself. Highlight the block to run.
    Open the Command Palette and select "SQLite: Run Selected Query"
    View the query results in split pane mode
Last modified 2yr ago
Copy link