themactep.com

A home of miscellaneous projects by Paul Philippov.

Notes

How to add a constraint to an existing SQLite table

CREATE UNIQUE INDEX table_i ON table(id, type);