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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Database schema design tools

  • 08-02-2013 2:20pm
    #1
    MOH
    Registered Users, Registered Users 2 Posts: 6,465 ✭✭✭


    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

  • #2
    mewso
    Moderators, Science, Health & Environment Moderators Posts: 9,035 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


  • #3
    Tom Dunne
    Registered Users, Registered Users 2 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.


  • #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


  • #5
    croo
    Moderators, Technology & Internet Moderators Posts: 1,336 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.


  • #6
    MOH
    Registered Users, Registered Users 2 Posts: 6,465 ✭✭✭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