Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[TABJS-14] Support local fetch, diff, and upload of SQL tables #93

Open
dtbuchholz opened this issue Nov 21, 2023 · 0 comments
Open

[TABJS-14] Support local fetch, diff, and upload of SQL tables #93

dtbuchholz opened this issue Nov 21, 2023 · 0 comments
Labels
cli Created by Linear-GitHub Sync Feature Created by Linear-GitHub Sync

Comments

@dtbuchholz
Copy link
Contributor

dtbuchholz commented Nov 21, 2023

Is your feature request related to a problem? Please describe.

  • It would be very useful to be able to fetch a (set of) table(s) from tableland, and load them locally in an SQLite database
  • From here, users could mutate the database, calculate a diff from the original, and even normalize the statements
  • After this, users should be able to then "push" the diff to tableland as a set of SQL statements

Describe the solution you'd like

It would be fine if the above things happen less automagically. For instance, perhaps there is a download to SQLite command. Then editing is manual. They could use standard SQLite tools to diff. Then use a custom "check" command to normalize the SQL statements. Then use the previously mentioned run feature to send the new diff commands from a file.

--

See here, which describes "Enable starting a local only sqlite instance in browser"

Also see here, which describes "Use tableland WASM sql parser to ensure all SQL run on local only sqlite instance conforms to tableland sql spec"

From SyncLinear.com | TABJS-14

@dtbuchholz dtbuchholz added cli Created by Linear-GitHub Sync Feature Created by Linear-GitHub Sync labels Nov 21, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
cli Created by Linear-GitHub Sync Feature Created by Linear-GitHub Sync
Projects
None yet
Development

No branches or pull requests

1 participant