skdb icon indicating copy to clipboard operation
skdb copied to clipboard

`read-only` `INSERT` forbidden?

Open ltique opened this issue 1 year ago • 1 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?

ltique avatar Feb 18 '24 13:02 ltique

read-only is only really useful for server-side virtual views.

gregsexton avatar Feb 19 '24 10:02 gregsexton

Closing skdb-specific issues as skdb in its current form is being deprecated.

beauby avatar Sep 30 '24 18:09 beauby