DrawSQL
79 posts

DrawSQL
@drawSQL
Create beautiful database schemas for your relational databases
Australia Katılım Mayıs 2018
13 Takip Edilen731 Takipçiler

what if a schema is just a URL?
#ddl=CREATE%20TABLE%20operatives%20%28%0A%20%20id%20serial%20PRIMARY%20KEY%2C%0A%20%20codename%20varchar%28100%29%2C%0A%20%20status%20varchar%2820%29%20DEFAULT%20%27active%27%2C%0A%20%20handler_id%20int%20REFERENCES%20operatives%28id%29%0A%29%3B%0A%0ACREATE%20TABLE%20missions%20%28%0A%20%20id%20serial%20PRIMARY%20KEY%2C%0A%20%20lead_id%20int%20REFERENCES%20operatives%28id%29%2C%0A%20%20objective%20text%2C%0A%20%20status%20varchar%2820%29%20DEFAULT%20%27pending%27%0A%29%3B%0A%0ACREATE%20TABLE%20dead_drops%20%28%0A%20%20id%20serial%20PRIMARY%20KEY%2C%0A%20%20operative_id%20int%20REFERENCES%20operatives%28id%29%2C%0A%20%20coordinates%20text%2C%0A%20%20retrieved%20boolean%20DEFAULT%20false%0A%29%3B%0A%0ACREATE%20TABLE%20intercepts%20%28%0A%20%20id%20serial%20PRIMARY%20KEY%2C%0A%20%20source_id%20int%20REFERENCES%20operatives%28id%29%2C%0A%20%20mission_id%20int%20REFERENCES%20missions%28id%29%2C%0A%20%20content%20text%2C%0A%20%20decoded%20boolean%20DEFAULT%20false%0A%29%3B" target="_blank" rel="nofollow noopener">drawsql.app/draw#ddl=CREAT…
English

@ssmusoke @Akintola_steve Thanks for the rec, Stephen. Good to hear the UI is earning its keep!
English

@Akintola_steve You could also take a look at @drawSQL love the UI and SQL schema generation
English

There’s a roadmap change guys:
So I had a proper draft of how we are to go about it and this is it.
I’m very sure this would be very self sufficient.
So for the 90-Day Backend Roadmap, the summary of everything to be covered is this (Relational DB + Auth + RBAC + Payments + Redis + Queues).
But still, down below is the detailed path of how everything will be covered step by step across the phases.
Before you continue looking through the whole roadmap ensure you share this so those people also get a hold of it.
English

@jasontheadams Good point though it's def not obvious. We used to have drag icons but they were cluttering the limited space there. We'll work something else out :)
English

@jasontheadams Yup it's possible to reorder (though not obvious). You can drag-drop from any empty space in the left sidebar for that column
English

@drawSQL I'm getting the following error when I try to reach out. Also, do you know the answer to the question? 😃

English
DrawSQL retweetledi

I wrote a thing about some ways of dealing with hierarchical content in relational databases👩💻
aleksandra.codes/comments-db-mo…
English
DrawSQL retweetledi

👇Quick update 👇
Adonis v5 support is now shipped!
If you're building on the latest @adonisframework preview version, try generating your migrations directly using @drawSQL

English

Only v4 for now, Support for the AdonisJS v5 preview release is already in the works, and should be launched next!
More info here: announcekit.app/drawsql/change…
English

🔺⃤ New export type - Export your DrawSQL database diagrams to @adonisframework Migrations.
Thanks to @AmanVirk1 for kickstarting this and being a great help!

English

Thanks for sharing DrawSQL, def keen to chat further about your experience, will reach out!
Dennis Ivy@dennisivy11
Just started using @drawSQL. @dennisongkj you should hit me up so we can talk about this awesome database design platform you have.
English
DrawSQL retweetledi

But it's DB schema is still quite similar to non-billing parks of SPARK, so it *should* be possible to migrate an existing Spark app, gonna try that out next.
Jetstream: drawsql.app/templates/lara…
Spark: drawsql.app/templates/lara…
English





