db

Overview

Use db as a short, session-scoped mirror over an installed database driver: choose MySQL/MariaDB, PostgreSQL, Redis, SQLite or MongoDB once, then reuse the same compact prefix for inspection, export, backups and native engine commands.

One prefix, different engines

db is a common entry point for installed database drivers, not a database engine of its own. It remembers the selected driver and exposes its shared operations, while text after : stays in the database’s native language. This keeps routine work short without pretending that SQL, Redis data structures and MongoDB documents are the same model.

Syntax

db [driver] [options]

Reference

What it does

db is a shortcut to a database driver, not a database and not a translator between SQL, Redis and MongoDB. Choose db sqlite for a database stored in a file or db mysql for a MySQL/MariaDB server. You can still call sqlite and mysql directly; the same driver performs the operation.

Practical steps

Select the driver first, then connect: db sqlite -c \sandbox\db\shop.sqlite. Inspect tables with db -t, look at a few records with db -n products 2, and search with db -f products "shoe". The native command after db : belongs to the selected engine. db mariadb selects mysql; it does not install a missing driver.

Limits and safety

The chosen driver and an ordinary connection remain in the PHP session. -m [name] explicitly saves a connection profile to the sensitive .lil.key file; -k lists it, -K reconnects and -M removes it. Prefer limited database accounts, back up before -a/-w/-d, load or arbitrary native commands, and check that both the driver and its PHP extension are available. Examples use isolated data, not your live database.

Install and manage

Install the current compatible version. Choose Base for the complete feature set or Minimum for the reduced package; use upgrade to update a module that is already installed.

Base and Minimum are two packages of the same current module release, not separate command versions.

Examples

Examples are copyable command lines, not actions executed by this website. Review paths, permissions and destructive flags before running them on a real project.

No database driver selected
mysql       MySQL / MariaDB · installed
postgresql  PostgreSQL · installed
redis       Redis · installed
sqlite      SQLite · installed
mongodb     MongoDB · installed

Database driver selected: sqlite

Database driver selected: mysql

Unknown database driver: oracle

Status  connected
File    sandbox/db/shop.sqlite
SQLite  (version depends on the host)

Status  connected
File    sandbox/db/shop.sqlite
SQLite  (version depends on the host)

name	type
orders	table
products	table

cid	name	type	notnull	dflt_value	pk
0	id	INTEGER	0	NULL	1
1	sku	TEXT	1	NULL	0
2	name	TEXT	1	NULL	0
3	category	TEXT	1	NULL	0
4	price	REAL	1	NULL	0
5	active	INTEGER	1	1	0

id	sku	name	category	price	active
1	SHOE-1	City shoe	shoes	79.9	1
2	SHOE-2	Trail shoe	shoes	109.0	1

id	sku	name	category	price	active
1	SHOE-1	City shoe	shoes	79.9	1
2	SHOE-2	Trail shoe	shoes	109.0	1

seq	name	file
0	main	sandbox/db/shop.sqlite

total
4
Time  (varies) ms

[
  {
    "id": 1,
    "sku": "SHOE-1",
    "name": "City shoe",
    "category": "shoes",
    "price": 79.9,
    "active": 1
  },
  {
    "id": 2,
    "sku": "SHOE-2",
    "name": "Trail shoe",
    "category": "shoes",
    "price": 109.0,
    "active": 1
  },
  {
    "id": 3,
    "sku": "BAG-1",
    "name": "Canvas bag",
    "category": "bags",
    "price": 44.5,
    "active": 1
  },
  {
    "id": 4,
    "sku": "HAT-1",
    "name": "Summer hat",
    "category": "accessories",
    "price": 25.0,
    "active": 0
  }
]

Inserted  1
ID        5

Updated  1

Deleted  1

Saved  demo

No saved connections

Saved connection not found: absent

Saved connection not found: absent

+

Saved  sandbox/tmp/sample-db.sql

SQLite error: table products already exists

CREATE TABLE products (
  id INTEGER PRIMARY KEY,
  sku TEXT UNIQUE NOT NULL,
  name TEXT NOT NULL,
  category TEXT NOT NULL,
  price REAL NOT NULL,
  active INTEGER NOT NULL DEFAULT 1
);
INSERT INTO products (sku,name,category,price,active) VALUES
('SHOE-1','City shoe','shoes',79.90,1),
('SHOE-2','Trail shoe','shoes',109.00,1),
('BAG-1','Canvas bag','bags',44.50,1);

Related documentation