SQLite Forum

Query to make timestamp to readable date
Please also note that declaring

"_id" INTEGER, … PRIMARY_KEY("_id")

does NOT invoke the magic INTEGER PRIMARY KEY (access to the internal rowid) feature, which may cause foreign keys to be slower.

Consider using either above magic or adding WITHOUT ROWID to the table declaration, which would make "_id" the real primary key.