Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Database schema design tools

Options
  • 08-02-2013 3:20pm
    #1
    MOH
    Registered Users Posts: 6,464 ✭✭✭


    Anyone know a decent free tool for helping design a database schema?

    Not looking for anything complicated - basically just looking for a neater alternative to scribbling on a notepad. Don't need it to generate any SQL, just something to help visualise the layout.

    Linux or web based. Thanks.


Comments

  • Options
    #2
    mewso
    Moderators, Science, Health & Environment Moderators Posts: 8,919 Mod ✭✭✭✭mewso


    I've tried a few of the online ones for general modeling. Plenty of options out there. You could browse the chrome plugins (although most are simply web links but they will be added to your app list in chrome which is handy).

    https://www.lucidchart.com
    https://www.cacoo.com


  • Options
    #3
    Tom Dunne
    Registered Users Posts: 23,212 ✭✭✭✭Tom Dunne


    MOH wrote: »
    Anyone know a decent free tool for helping design a database schema?

    Not looking for anything complicated - basically just looking for a neater alternative to scribbling on a notepad. Don't need it to generate any SQL, just something to help visualise the layout.

    Linux or web based. Thanks.

    Power Architect. Its not brilliant, but it is free. Also SQL Workbench has an ERD design feature.


  • Options
    #4
    stevenmu
    Moderators, Society & Culture Moderators Posts: 9,689 Mod ✭✭✭✭stevenmu


    Not free, but Visio can be pretty good if you have access to it. Otherwise you could look at the various free UML tools out there. StarUML seems to be popular, but I haven't tried it myself.

    edit: oh, just spotted the linux/web based requirement


  • Options
    #5
    croo
    Moderators, Technology & Internet Moderators Posts: 1,334 Mod ✭✭✭✭croo


    Simple & light, Dia is an open source (visio like) drawing tool.
    http://projects.gnome.org/dia/??

    It's a standard in the repos of most linux distros and is also available as a binary for windows.


  • Options
    #6
    MOH
    Registered Users Posts: 6,464 ✭✭✭MOH


    Cheers for all the replies, I must check those out.

    I found dbschema earlier, does the job pretty well for now, but not sure how many of the features you lose when the 15-day trial expires, so I'll probably fall back to one of those other options then.


  • Advertisement
Advertisement