search

LeMoussel / pydbhub

A Python library for accessing and using SQLite databases on DBHub.io
MIT License
32 stars 5 forks source link

API version 0.3 now available :) #5

Open justinclift opened 1 year ago

justinclift commented 1 year ago

As a data point, the DBHub.io API has been updated to version 0.2 in order to support our new (experimental) "Live" databases.

These "Live" ones aren't version controlled like the existing "Standard" databases, and can have write queries executed on them. eg INSERT, UPDATE, DELETE (etc)

The main differences in the API are:

  1. The Databases() call now has an optional live boolean parameter. If that's set to true, it'll return a list of "Live" databases in the user account. If that's any other value, or missing, it'll return the list of "Standard" databases in the user account.

  2. The Upload() call has the same optional live boolean parameter. If it's set to true then the uploaded database goes into a new backend system (not version controlled, allows write queries). If that boolean parameter is any other value (or missing), then the uploaded database will be a "Standard" database upload.

  3. There's a new Execute() function, so people can run write queries against their Live databases.

In theory, it should be simple to update pydbhub to support the new version. If anything does turn out to be non-obvious or weird though, please let me know so it can be looked at / fixed. :smile:

justinclift commented 1 year ago

There's now a reasonable "Changelog" page on the API server, which will hopefully make things easier for people. :smile: