Basic SQLite operations

Backup

Before we make things worse.

sqlite3 "database.db" ".backup 'database_backup.db'"

Open database

Open sesame.

sqlite3 database.db

or:

sqlite3
sqlite> .open database.db

List tables

What has it got in its database?

sqlite> .tables
admin_settings      gists               migration_versions  users
gist_languages      invitations         ssh_keys            webauthn
gist_topics         likes               totps

View table schema

How is it organized?

sqlite> .schema admin_settings
CREATE TABLE `admin_settings` (`key` text,`value` text);
CREATE UNIQUE INDEX `idx_admin_settings_key` ON `admin_settings`(`key`);

View rows

Show me the data.

sqlite> SELECT * FROM admin_settings;
disable-login-form|1
disable-gravatar|0
disable-signup|1
require-login|0
allow-gists-without-login|1

Alter data

Just a little tweak.

sqlite> UPDATE admin_settings SET value = 0 WHERE key = "disable-login-form";