Hey all! I released drawDB about a month ago and now it's open source. I hope you find it useful.<p>If you want to check out the app you can go to <a href="https://drawdb.vercel.app/" rel="nofollow">https://drawdb.vercel.app/</a> .<p>Thank you:)
Are there any advantages that could come from encouraging a tool like this to emit both SQL and strongly-typed classes representing the data in say TypeScript and C#?
Having spent fair amount of time on inf.architectural position, I’d really love these tools to also adapt some sort of markup. Sequencediagram.org being perfect example (and others alike) where it takes seconds to put a diagram that otherwise takes hours to prepare. Sadly I know of no standard and lightweight markup for E/R modelling…<p>Mermaid is good for flowcharts, but we still lack reasonably good one for BPMN and enterprise diagrams. (BPMN.io is great but lacks its own lang)
Fantastic. I was literally <i>just</i> looking for something like this. I'm using it now.<p>One thing that may be me getting my brain reversed, but when you set the "cardinality" of a relationship the "1" and "n" markings on the connecting line seem to be reversed?
Looks very nice! A few things I'd like to see to make it more useful:<p>- Let me pick a database when I start so the data types are restricted to that particular database. This can help down the line with other quirks and particularities of each db.<p>- I'd love to be able to use this and convert it to a model for my ORM (I'm currently using Prisma, but depending on your vision this could expand to other languages and ORMs such as, for example, Django). This would be helpful because I'd be able to jump from design to implementation without rewriting everything as models in my ORM.<p>- The nodes to establish relationships are difficult to click, and several times I ended up dragging the table instead. Consider making them easier to grab.<p>- If I delete a property from the table (in the grid) there's no quick way to undo. A toast message with an undo link would be helpful.<p>- The "delete diagram" option didn't ask me for confirmation and even if I saved my diagram before, it's gone. And this option is dangerously close to "Rename"!
Looks real nice!<p>Clean for sure.<p>First feedback I have is, when you click "Settings" > "Flush Storage" there is no "Hey this button will delete everything you have been working on are you sure you want to do this?" type message to confirm if someone wants to actually flush the storage.<p>I was about 6 or 7 tables deep messing around with it and was looking at settings and kind of absent mindedly clicked that without thinking and everything was gone :D
This looks great! However, a pet peeve of mine that I always share with my students is that ER diagrams do not have foreign keys. ER diagrams represent relationships with a diamond connected by lines to the related entities. It looks like what this is producing is not really an ER diagram.
At first I thought this was drawio: <a href="https://www.drawio.com/" rel="nofollow">https://www.drawio.com/</a> with which you can generate a schema diagram from SQL. Is this the other way around.
What's up with projects using "-io"/".io" in their name but not actually using a .io domain?<p>drawio.com brands itself as "draw.io" but uses .com.<p>OP, why is it "drawdb-io"?<p>Cool project btw :)
Honestly, what I'm looking for is a tool that generates the docs and diagrams for a database from the database schema itself and lays it out cleanly. So far I've found tools that will try to generate a diagram naively even if there are a hundred tables, and I've found tools that make you recreate your structure twice: once in DDL and the second time in docs/diagramming.<p>I want Javadoc with scoped diagrams for relational databases.
Cool project. Your website is much more detailed than your Github so I'd like to share this for visibility: <a href="https://drawdb.vercel.app/" rel="nofollow">https://drawdb.vercel.app/</a><p>Any updates on PostgreSQL import support?
You might want to mention that it is a "data modelling tool" somewhere in the description text, as some of your target users will definitely use that term to search for such a solution...
For tools like these, I need the ability to save locally to my own device and not have anything saved/sent to the cloud. draw.io is the best example of this.