skdb
skdb copied to clipboard
`read-only` `INSERT` forbidden?
I was a bit surprised that I can't insert a row with skdb_access set to read-only:
INSERT INTO messages (username, message, skdb_access) VALUES ('user2', 'msg3', 'read-only');
Could not eval query. Try `.help`
SkRuntimeExit [Error]: INSERT INTO messages (username, message, skdb_access) VALUES ('user2', 'msg3', 'read-only');
^
|
----- ERROR
Error: line 1, character 0:
cannot insert with skdb_access set to read-only (user f8b7WiJln5Scgj-T5inTJcn7Fi)
...
What are the valid values of skdb_access? Are they: user ID; group ID; read-write; and that's it? Or are there are other valid predefined groups one can use?
read-only is only really useful for server-side virtual views.
Closing skdb-specific issues as skdb in its current form is being deprecated.