this repo has no description
edavis.dev
1-- name: InsertPost :exec
2insert or ignore into posts (uri, create_ts, likes) values (?, ?, ?);
3
4-- name: InsertLang :exec
5insert or ignore into langs (uri, lang) values (?, ?);
6
7-- name: UpdateLikes :exec
8update posts set likes = likes + 1 where uri = ?;
9
10-- name: TrimPosts :exec
11delete from posts where create_ts < unixepoch('now', '-24 hours');