Oddbean new post about | logout
 nostr:npub1mc3fyzafm6shv38mesf05vapyg3dxhxm34u3heqqn7jrze9hlqfqk4nkdg I'm not too familiar with SQLite. Let's see.

`INSERT INTO kv_store (project, key, value, time) VALUES (?, ?, ?, datetime()) ON CONFLICT (project,key) DO UPDATE SET value=value+?,time=datetime() RETURNING VALUE`

With a unique index on `(project, key)`