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

Shell command for remote repo interaction #39

Closed justinclift closed 1 year ago

justinclift commented 7 years ago

As a thought for the future, should we create some kind of shell command for interacting we the DBHub.io server remotely? eg create branches, push/pull/sync databases, etc?

MKleusberg commented 7 years ago

For starters this might be as simple as writing a shell script that's nothing more than a simple frontend for curl or wget.

Personally I think a FUSE driver would be nice to have, too :smiley:

justinclift commented 7 years ago

Yep, I'm thinking the curl option too for starters. :smile:

justinclift commented 7 years ago

While thinking about the new backend data model, I realised having some kind of CLI to perform operations on a remote DBHub.io API server would be very useful for testing.

... so I've created an initial API server (using the new backend data model concept), and am currently hooking up an CLI "dio" to that. The API server doesn't do any input validation yet, so it's not something we'd run publicly "as is". But it's seems like a decent start in the right direction for me to get some experience with what'll be needed + also have something I can test the new data model with in depth.

justinclift commented 7 years ago

Ahhh, this issue is pretty old. As an update for it, I wrote an initial proof of concept cli called dio as mentioned above. It turned out pretty good, and was useful for working out the new data model now used for DBHub.io.

It wouldn't take too much effort to update it to work with DBHub.io itself, as probably 80% of the code could probably be used as-is. It would need to some kind of auth mechanism added, perhaps using a client cert in the same way that DB4S does, or perhaps even the same cert to keep things easy for now.

It's probably a few days of effort to get it done properly, and I'll probably get it done either later this month or early next.

justinclift commented 1 year ago

Closing this, as dio is the cli we implemented for this.