Oddbean new post about | logout
 @de22920b 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)` 
 @7691a5af You probably need to index on id as well, keys can exist multiple times and only the last one is valid. I did it this way so there is a record.