Comments (9)
What an interesting feature!
It wasn't on the roadmap.
I'll add it.
Thanks for letting me know.
from erd-editor.
It's easy for anyone to use it
It's a standard web interface.
It was the use case I thought.
An example of that was vscode extension.
But I think it's not enough if you don't fully support reverse engineering with SQL DDL.
The https://github.com/mWater/jsonql you told me about
I'll refer to it when I develop it. Thank you!
from erd-editor.
Sorry, this may be OT, but I thought, I use this issue to link interesting stuff related to this here.
https://github.com/danielrearden/sqlmancer
Sqlmancer is a Node.js library that empowers you to effortlessly and efficiently translate GraphQL queries into SQL statements.
Multiple dialect support. Sqlmancer supports Postgres, MySQL, MariaDB and SQLite, enabling you to incorporate it into existing projects regardless of what flavor of SQL you’re using.
Performance. Avoid the N+1 problem by building a single SQL…
I do not want to distract you from your current great work, quite on the contrary, keep it up :-)
from erd-editor.
Intermediate json format does not exist
The conversion pipeline may be implemented externally.
What I'm thinking right now is...
sql-ddl-to-json-schema contributing
or
syntax-parser use
Or to take advantage of the existing grammar.
WebAssembly is thinking, too.
I haven't thought about this yet, so I think it'll be clear when it's developed.
from erd-editor.
https://github.com/xnuinside/simple-ddl-parser also defines a DDL dialect agnostic json schema
from erd-editor.
A possible use case I was thinking about was to use it in superset https://github.com/apache/incubator-superset instead of or in addition to e.g: https://superset.apache.org/sqllab.html
from erd-editor.
Do you know of https://github.com/mWater/jsonql? This seems to be a nice intermediate format/API specification (alternatives may be available, that is just the only one I could find)
from erd-editor.
But I think it's not enough if you don't fully support reverse engineering with SQL DDL.
Is there an intermediate JSON format?
Does the full DDL to VUERD conversion pipeline have to be implemented here?
I can think of existing introspection tools that may be adopted to spit out some well-defined JSON.
from erd-editor.
The 'SQL DDL to JSON Schema converter' looks promising, I like the compact format. Another pro for a format like this would be that the target could also be an ORM like SQLalchemy, Hibernate or typeorm.io - many others are also available
from erd-editor.
Related Issues (20)
- Git status change issue when scrolling on the screen HOT 3
- Comments column re-size in Diagram HOT 1
- An exception occurred when I was packaging the vuerd-vscode project HOT 1
- The primary key must require autoIncrement when generating sql HOT 1
- Roadmap v3 HOT 4
- Extension does not always save automatically HOT 3
- Pressing enter on selected dataType suggestion does nothing HOT 2
- How can we import external DDL HOT 1
- Diagram relationship paths have unnecessary cross overs HOT 3
- Unable to zoom more than 100%
- Tree and table views in v3 HOT 4
- many to many? HOT 2
- Automatic similarity between primary key and foreign key makes the foreign key adopt the extra fluff of the primary key. HOT 1
- There is no grid view HOT 1
- Allow hiding sidebar in erd-editor.io HOT 1
- Hope to support copy and paste table HOT 3
- How to AUTO_INCREMENT on mysql HOT 1
- Links from a table to itself are displayed incorrectly
- Make table names more distinguishable from column names
- Thinner links would reduce clutter and improve readability of diagrams
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from erd-editor.