Live data from Hacker News

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

drawdb.app

21–30 of 62 posts

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

#22
Failed to import a Postgres export with all of this errors:

- "missing_fields" _text NOT NULL DEFAULT ARRAY[]::text[]

- "status" text NOT NULL DEFAULT 'RUNNING' ::text CHECK (status = ANY (ARRAY['RUNNING'::text, 'PAUSED'::text, 'STOPPED'::text, 'SUCCESS'::text]))

- DROP TYPE IF EXISTS "script_trigger_event";

- CREATE UNIQUE INDEX name ON table_name USING btree(unique_key, environment_id, deleted_at) NULLS NOT DISTINCT;

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

#23

This looks a lot like ChartDB[0]. Is that correct? If so, how would you compare the two tools, or better yet, distinguish yours from theirs? [0] https://github.com/chartdb/chartdb

hehe mine was up and running way before theirs. but we have diverged quite a bit. might be biased but i think mine is easier to jump right in. mine is more like the draw.io of database editors while theirs is the miro, yk?

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

#24
post #14

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.

that's really impressive.

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

#25
post #13
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

If you wanted to commercialise this, then you could do it on a feature basis.

Create a paid version where you add more features, like support for views.

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

#29
Hey! This is awesome! Great job :-)

I make Beekeeper Studio, another open source db tool (although v different), we started charging for a pro version 2 years ago. Would be cool to connect! I can tell you what we did and what did and didn't work - Matthew (at) beekeeperstudio (dot) io

Post reply on HN