search

sqlitebrowser / dbhub.io

A "Cloud" for SQLite databases. Collaborative development for your data. 😊
https://dbhub.io
GNU Affero General Public License v3.0
372 stars 39 forks source link

Insert new record using query method #149

Closed hhaydar closed 3 years ago

hhaydar commented 3 years ago

is it possible to insert new record on tables?...

curl -F apikey="API_KEY" -F dbowner="jdoe" -F dbname="mydata_file" -F sql="SU5TRVJUIElOVE8gc29uZ" https://api.dbhub.io/v1/q

Error:

error": "not authorized (INSERT INTO song_list VALUES('DkDjEr3opt0',0,'','')) (authorization denied)"

Note:

sql decode: INSERT INTO table VALUES('A',0);

justinclift commented 3 years ago

At the moment, no. :frowning: Uploaded databases are read-only.

So, to add new info, you need to do it to a local copy (eg using DB Browser for SQLite), then upload the new version.

That being said, yeah it's a huge pain in the butt for a lot of use cases. So, we'll need to figure out a way to make this work properly for people. It won't be in the next few days, but may be possible in a few weeks. :smile:

hhaydar commented 3 years ago

Thank you Justin,