@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.