SkipLabs/skip

[skdb] `read-only` `INSERT` forbidden?

Closed this issue · 2 comments

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.