We’ve been working hard developing DBHub.io. One of the most requested features is the ability to perform INSERT, UPDATE and DELETE commands on a database. That now has an experimental implementation available via our API, and everyone is encouraged to try it out.
One excellent benefit of DBHub.io has always been performing queries on a SQLite database stored in the cloud. Together with creating snapshots and full version control, it has been a benefit to many users. However, databases were read-only. You couldn’t perform any changes on them. Now you can.
When you upload a database, click the ‘Advanced’ link to reveal the advanced options panel.
Scroll down and you’ll see an ‘Experimental’ area where you can toggle between ‘Standard’ and ‘Live’ databases.
Standard is the default option where databases are read-only, but have the advantage of being version controlled.
If you switch to Live mode, you can use our API to make database changes - insert new rows, update existing rows or delete rows. Please note though that in this mode, databases are not version controlled.
In related news, we have also updated our Go library (go-dbhub) to access and control live databases. You can read more about that here.
To view details about our API, please visit our API page.