Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: DrawDB – open-source online database diagram editor (a retro)

drawdb.app

Post reply on HN
Print view View original

11–20 of 62 posts

Re: Show HN: DrawDB – open-source online database diagram editor (a retro)

#13

Post by 1ilit »

andrewl wrote: post #5

I experimented with this for five minutes, and so far it looks great. The one thing missing, or that I didn't see in five minutes, is that when I uploaded the schema for one of our SQLite databases, the tables came out perfectly, but the views were ignored. There are a lot of views, and we would want them in the diagram. I will definitely be coming back to it. As I say, what I saw was great.

Thank you! Yeah we don't have views yet, but will

Re: Show HN: DrawDB – open-source online database diagram editor (a retro)

#14

Post by 1ilit »

ptodorov wrote: post #12

Awesome work! We've been searching for something to switch away from MySQL Workbench for years, but the one feature we need is the automatic generation of SQL migration based on a current and a new schema.

Coming... https://imgur.com/a/U8cbJ5Y. Working on versioning, based on which migrations will be generated.

Re: Show HN: DrawDB – open-source online database diagram editor (a retro)

#15

Post by 1ilit »

mubou wrote: post #10

It can even export as Mermaid? That's awesome. I could see that being super useful as a way to take a db schema and turn it into a chart for a github readme. Definitely bookmarking this. Btw, the SQL import doesn't seem to work for an sqlite `.schema` dump; it breaks on the PRIMARY KEY here: CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" ( "MigrationId" TEXT NOT NULL CONSTRAINT "PK___EFMigrationsHistory" PRIMARY…

thank you!

regarding the sql import, it breaks because of the parser. i'm using a 3rd party parser to parse sql and pull out everything needed for the diagram. i'll report it to them, thanks for letting me know

Re: Show HN: DrawDB – open-source online database diagram editor (a retro)

#16

Post by 1ilit »

nrjames wrote: post #4

Not everything has to be monetized. You will have other ideas or maybe you’ll take this further. It’s a ton of work to build a thriving business, and you may lose some of your joy and pride along the way. You created a useful tool and have the support of the community! That’s pretty cool. Congrats!

appreciate it!

Re: Show HN: DrawDB – open-source online database diagram editor (a retro)

#18

Post by hliyan »

A suggestion based on an idea that I've been trying to implement for a while: consider replacing the left panel's form editing experience with an assistive command line at the bottom.

E.g. rather than clicking table, "add field", clicking the name, typing, clicking the type drop down etc., just start writing something like:

    : users.add_column
    name: email
    type: varchar
    length: 200
etc., with some assistive auto complete

or, if you're inclined to using an LLM:

   add column email to users table, varchar(200)
or, for those who want strict sql:

   alter table add column...

Re: Show HN: DrawDB – open-source online database diagram editor (a retro)

#19

Post by 1ilit »

flashgordon wrote: post #2

As someone who is afraid to release personal projects I think what you have done is amazing. Id love to learn From your experience. You are being too humble but this kind of growth is very hardly an accident! I'm not a monetization expert by any means so take all this with a pinch to salt. If money is not an urgent factor for you you can see how far you can take it especially towards "other verticals". If you can dis…

appreciate it!
Post reply on HN