1ilit

6 ms·

1. 31.▲
   by 1ilit 2y ago

   I'm working on https://github.com/drawdb-io/drawdb trying to optimize the editor and have it lag less when the number of tables increases. Also have some highly requested features I'd like to implement before
2. 32.▲
   by 1ilit 2y ago

   +1
3. 33.▲
   Ask HN: What's something you wish there was a software solution for?

   4 points by 1ilit 2y ago|6 comments
4. 34.▲
   Ask HN: Is clean code worth sacrificing performance?

   3 points by 1ilit 2y ago|6 comments
5. 35.▲
   by 1ilit 2y ago

   have to add tsoding to the already mentioned channels
6. 36.▲
   by 1ilit 2y ago

   Hello! I recently released an app to design database diagrams and export them to SQL. The app has only a limited set of datatypes which can be inconvenient so I've been thinking of making the diagrams DBMS specific. I need opinions on
7. 37.▲
   Ask HN: DB diagrams for specific DBMS or generic diagrams for multiple DBMS-s?(github.com)

   1 points by 1ilit 2y ago|2 comments
8. 38.▲
   by 1ilit 2y ago

   thanks! yep it's definitely coming. can't promise anything for the coming week but i'll try my best to have it out asap
9. 39.▲
   by 1ilit 2y ago

   thanks! i'm planning to buy drawdb.io once i'm able to
10. 40.▲
    by 1ilit 3y ago

    I'll look into it, thanks for the suggestion
11. 41.▲
    by 1ilit 3y ago

    thanks! will do
12. 42.▲
    by 1ilit 3y ago

    thank you!
13. 43.▲
    by 1ilit 3y ago

    yep, this or as json
14. 44.▲
    by 1ilit 3y ago

    Nothing gets sent to the cloud, everything is in your browser in IndexedDB. If you go to Inspect>Application>IndexedDB in the storage section you'll see exactly what gets saved and where
15. 45.▲
    by 1ilit 3y ago

    At first it was mostly for myself just as a learning experience and a project that would go on my resume. I wasn't even planning to open source it until people started expressing interest in it. Now that it's out and there's
16. 46.▲
    by 1ilit 3y ago

    It's meant to support both ways, plus additional finer control over the tables, custom types, and error checking
17. 47.▲
    by 1ilit 3y ago

    Can see it happening for sure. Perhaps porting it to electron and taking in dbms type and host url for the connection will do it
18. 48.▲
    by 1ilit 3y ago

    This was in the plans when i was just starting out until i realized how much longer it was gonna take just to finish the web app. Can't say anytime soon but i'd love to make this happen
19. 49.▲
    by 1ilit 3y ago

    I tried to have the diagrams be independent of the DBMS that's why types that are not supported in one DBMS get mapped to their closest match in another. For example SET gets mapped to an array of ENUM values in Postgres. So money, poi
20. 50.▲
    by 1ilit 3y ago

    Thanks for the feedback! The "1" and "n" labels are assigned first to the foreign key then to the primary key, e.g. if you pick "Many to one" the FK side will be "n" and the PK will be "1".
21. 51.▲
    by 1ilit 3y ago

    wow this is horrible, i love it
22. 52.▲
    by 1ilit 3y ago

    Oh god i'm sorry about that. Lol funny enough i mentioned it in a reddit thread today that i need to add a warning
23. 53.▲
    by 1ilit 3y ago

    Dbdiagram is pretty op. Actually my initial prototype was very similar to it
24. 54.▲
    by 1ilit 3y ago

    Yep! Hopefully soon
25. 55.▲
    by 1ilit 3y ago

    I like this. Definitely going on the backlog. This can be very useful.
26. 56.▲
    Show HN: Online database diagram editor(github.com)

    311 points by 1ilit 3y ago|67 comments
27. 57.▲
    by 1ilit 3y ago

    a full summer break, a semester of working on it on and off, and a full winter break, so about 7 months
28. 58.▲
    by 1ilit 3y ago

    thank you!
29. 59.▲
    by 1ilit 3y ago

    thank you! i'm not using a library it's all svg and foreign objects styled with tailwind
30. 60.▲
    Show HN: I made an online DBER diagram editor and SQL generator(drawdb.vercel.app)

    13 points by 1ilit 3y ago|6 comments