I pretty much always store date/times as Unix epoch integers. Also use STRICT ta...

		packetlost 5 months ago \| parent \| context \| favorite \| on: SQLite as an Application File Format I pretty much always store date/times as Unix epoch integers. Also use STRICT tables and set the PRAGMA to enforce foreign key constraints.