toolkitbox/sqlite repository overview

# Interactive mode with a database file
docker run -it --rm \
  -v $(pwd):/data \
  ghcr.io/pabpereza/toolkitbox/sqlite:latest \
  sqlite3 /data/mydatabase.db

# Execute single query
docker run --rm \
  -v $(pwd):/data \
  ghcr.io/pabpereza/toolkitbox/sqlite:latest \
  sqlite3 /data/mydatabase.db "SELECT * FROM users;"

# Create in-memory database for testing
docker run -it --rm \
  ghcr.io/pabpereza/toolkitbox/sqlite:latest \
  sqlite3 :memory:

apiVersion: v1
kind: Pod
metadata:
  name: sqlite-client
spec:
  containers:
  - name: sqlite-client
    image: ghcr.io/pabpereza/toolkitbox/sqlite:latest
    command: ["sleep", "infinity"]
    volumeMounts:
    - name: data
      mountPath: /data
  volumes:
  - name: data
    persistentVolumeClaim:
      claimName: sqlite-data

sqlite3 mydatabase.db

sqlite3 -readonly mydatabase.db

sqlite3 mydatabase.db "SELECT * FROM users;"

sqlite3 mydatabase.db < script.sql

sqlite3 :memory:

-- Create table
CREATE TABLE users (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT UNIQUE
);

-- Insert data
INSERT INTO users (name, email) VALUES ('John', '[email protected]');

-- Select data
SELECT * FROM users;

-- Update data
UPDATE users SET name = 'Jane' WHERE id = 1;

-- Delete data
DELETE FROM users WHERE id = 1;

-- Show all tables
.tables

-- Show table schema
.schema users

-- Describe table structure
PRAGMA table_info(users);

-- Show all indexes
.indexes

# Export to CSV
sqlite3 -header -csv mydatabase.db "SELECT * FROM users;" > users.csv

# Import from CSV
sqlite3 mydatabase.db
.mode csv
.import users.csv users

# Dump database to SQL
sqlite3 mydatabase.db .dump > backup.sql

# Restore from SQL dump
sqlite3 newdatabase.db < backup.sql

# Show help
.help

# Show tables
.tables

# Show schema
.schema

# Change output mode
.mode csv
.mode json
.mode column
.mode line

# Enable headers
.headers on

# Open another database
.open another.db

# Attach database
ATTACH DATABASE 'other.db' AS other;

# Show current settings
.show

# Exit
.exit

# CSV format
.mode csv
SELECT * FROM users;

# JSON format
.mode json
SELECT * FROM users;

# Column format (pretty table)
.mode column
.headers on
SELECT * FROM users;

# Line format (one value per line)
.mode line
SELECT * FROM users;