typedb / typedb-studio

TypeDB Studio (IDE)
https://typedb.com
Mozilla Public License 2.0
191 stars 44 forks source link

Export data in TypeQL (simple text format) from TypeDB Studio #671

Open izmalk opened 1 year ago

izmalk commented 1 year ago

Problem to Solve

We do have schema export in text format. And we have the ability to paste queries as text and run them against DB. Would be cool to have the ability to export data (or at least some part of it, maybe an option to limit (the first 100 things) or divide files by size (10 files 100 MB each)) as a TypeQL queries text.

That way it would be easier to export/import data and demonstrate the process, and the syntax. Easier to comprehend exported format when you can read it. Even if it's not optimal storage-wise.

Current Workaround

We have binary export/import.

Proposed Solution

Add a button to Export data in TypeQL text format. We then should be able to run exported text as a query in the correct mode to import the data.

Additional Information

This way we can export and import both schema and data as typeQL. Maybe not as main or recommended scenario but very useful for examples and onboarding.

jamesreprise commented 1 year ago

This would be nice, but we need this functionality in TypeDB client java first before we can add this to Studio.