search

xo / usql

Universal command-line interface for SQL databases
MIT License
8.82k stars 346 forks source link

replicating data between databases #386

Closed ghost closed 1 year ago

ghost commented 1 year ago

Hi everyone.

concept

  1. I want to know what you all think about the idea of using usql as a backend for git-bug.
  2. I would like to talk here about a killer application that could promote usql that would be git-bug. I believe that both projects have points in common: distribution, data/platform decentralization.

context

  1. "You would not need to rely on one or more issue and database vendors with git-bug and usql."
  2. "Lately protocols like IPFS, Matrix, ActivityPub have been popular... part of that is that they are federated protocols. I believe git-bug could benefit from usql."
  3. "We can use usql as a technical specification about a synchronization protocol, mirroring, sharing databases like matrix."
  4. "We can use git-bug as a technical specification about a synchronization protocol, mirroring, sharing for issues like matrix."

feedback/question

nineinchnick commented 1 year ago

I don't understand at all how usql which is a CLI client for multiple databases is related to git-bug which is an issue tracker. I can't think of any reasons to integrate these two apps and I don't see them in the issue description here either.

ghost commented 1 year ago

Hi nineinchnick, thank you for feedback.

I don't understand at all how usql which is a CLI client for multiple databases is related to git-bug which is an issue tracker. I can't think of any reasons to integrate these two apps and I don't see them in the issue description here either.

git-bug is a decentralized, distributed bugtracker... for example, you can synchronize issues in different platforms like GitHub and Gitlab for example... an... something usql(CLI client for multiple databases) can help to replicate issues of git-bug in different databases...

so... if one of these platforms goes down, as I distribute issues in different databases, I'm sure there is a process similar to what happens in protocols like matrix: interoperability, that is, git-bug doesn't stop working because there are bridges that communicate with different bases data or platforms - this would only be possible with a client like usql for different databases and a git-bug client that synchronizes some problems on different platforms

nineinchnick commented 1 year ago

Replicating data between databases is out of the scope of usql.

ghost commented 1 year ago

Hi nineinchnick.

Replicating data between databases is out of the scope of usql.

thank you for feedback.