SQL: No Booleans in SQLite

Welcome to the No Booleans in SQLite lesson!

This lesson is shown as static text below. However, it's designed to be used interactively. Click the button below to start!

Most database systems support booleans natively. In the name of simplicity, SQLite doesn't support them. Instead, we use integer columns to represent boolean values: 0 means false and 1 means true.

exec(`CREATE TABLE cats (name TEXT, vaccinated INTEGER)`);
exec(`INSERT INTO cats (name, vaccinated) VALUES ('Ms. Fluff', 1)`);
exec(`INSERT INTO cats (name, vaccinated) VALUES ('Keanu', 0)`);

Result:

Note: this code example reuses elements (variables, etc.) defined in earlier examples.
>
exec(`SELECT name FROM cats WHERE vaccinated = 1`);
Result:
[{name: 'Ms. Fluff'}]
Note: this code example reuses elements (variables, etc.) defined in earlier examples.
>
exec(`SELECT name FROM cats WHERE vaccinated = 0`);
Result:
[{name: 'Keanu'}]