How can I prevent accidental deletion of records in QuestDB?

user_14962228 0
Viewed 134

I want to expose a QuestDB instance publicly with the web interface so that users and visitors can make queries against the data. How can I make sure data won't be deleted from this dataset? Is there a way to prevent malicious queries?

questdb
1 Answers

One approach that's possible here is to set the server configuration to be readonly via HTTP. This can be set in the server.conf file with the following key:

http.security.readonly=true

This will disable commands which modify or delete data. For info on the available keys, see the HTTP server configuration documentation

user_88362650
Related