Skip to content

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

Description

@dtbuchholz

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    FeatureCreated by Linear-GitHub SynccliCreated by Linear-GitHub Sync

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions