>_ IzzyLab

Topic breakdown

SQLite is an embedded DBMS that lives in a single ordinary file with no separate server: give the path to the sqlite3 utility and the database file is created on the very first operation. The rest is done with plain SQL: first the table is described via CREATE TABLE (each column with its own type), then rows are added via INSERT INTO. The SQL can be passed as an argument or in a batch via a heredoc, remembering the quoting: text in single quotes, numbers without.

What's checked

  1. the users table has at least 2 rows

What it looks like