SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast morrty's Avatar
    Join Date
    Oct 2008
    Location
    Ontario, Canada
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Programs you use to design a new database?

    Recently I've started working one a new site and this will be my first site that uses a database that wasn't preconfigured (wordpress / drupal).

    I'm just curious what everyone uses to design their database structure, layout the types/primary keys etc...

    I've been doing it in Microsoft Excel. I gave Microsoft Access a try but found it tedious when everything is changing around so much. When it comes to laying out the relationships I may have to try it again but until then Excel seems to be working. Eventually when done the design I will be using MySQL Database.

    So, do you use Excel, Access, Pencil/Paper, handbomb trial/error, etc...?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,269
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    paper and pencil sketches still work best, especially for thinking through the PK/FK issues...

    i've tried some data modelling tools but the good ones are ~very~ expensive, and the cheap ones are no good
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast morrty's Avatar
    Join Date
    Oct 2008
    Location
    Ontario, Canada
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks, Rudy. I bought your book, I think I may pick it up tonight off the book shelf and give it a read before I proceed with this web site.

  4. #4
    SitePoint Wizard
    Join Date
    Dec 2004
    Location
    At My Desk!!
    Posts
    1,642
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm the same - Pen and paper. I haven't found anything better (Although I haven't looked very hard) for free
    "Am I the only one doing ASP.NET in Delphi(Pascal)?"

  5. #5
    SitePoint Enthusiast
    Join Date
    May 2007
    Location
    Lappeenranta, Finland
    Posts
    28
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MySQL Workbench is a free database design tool, that can export your design into MySQL. Highly recommended, if you are working on a big design. On smaller databases I usually just use phpMyAdmin and click relations and indexes directly in.
    PHP web application development: Perhosgrafiikka

  6. #6
    Follow: @AlexDawsonUK silver trophybronze trophy AlexDawson's Avatar
    Join Date
    Feb 2009
    Location
    England, UK
    Posts
    8,111
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    I second MySQL Workbench, it's a pretty solid all round project and replaced DBDesigner which was excellent back in it's day.

    http://wb.mysql.com/

  7. #7
    SitePoint Enthusiast morrty's Avatar
    Join Date
    Oct 2008
    Location
    Ontario, Canada
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Noted, I will see what this "MySQL Workbench" has to offer.

    Thanks.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •