SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast TannerC's Avatar
    Join Date
    Mar 2005
    Location
    Orem, UT
    Posts
    65
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [rails] Question about database editors

    I'm wondering if there are any good application programs (not through terminal, or if they are I don't see it) to create databases for my projects?
    Visit Creative Something, my creativity blog.

  2. #2
    SitePoint Guru
    Join Date
    Aug 2005
    Posts
    986
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use migrations. Migrations are Ruby scripts for setting up a database. It's much easier than SQL.

  3. #3
    SitePoint Enthusiast TannerC's Avatar
    Join Date
    Mar 2005
    Location
    Orem, UT
    Posts
    65
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can you give me more details? I'm really new to this and haven't quite grasped the concepts yet.
    Visit Creative Something, my creativity blog.

  4. #4
    ☆★☆★ silver trophy vgarcia's Avatar
    Join Date
    Jan 2002
    Location
    in transition
    Posts
    21,235
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    Getting started with migrations from the guy who helped write the Migrations module

  5. #5
    SitePoint Member
    Join Date
    Mar 2006
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you are after a specific SQL application http://www.webyog.com is excellent.

    It has a free open source version but with the paid for enterprise version you can tunnel into live server that are behind firewalls.

  6. #6
    SitePoint Addict myrdhrin's Avatar
    Join Date
    Jul 2004
    Location
    Montreal
    Posts
    211
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    But frankly you should stay away from SQL when dealing with Databases in RoR. Unless what you need to achieve can't be done any other way then through SQL.

    Migrations are really the way to go
    Jean-Marc (aka Myrdhrin)
    M2i3 - blog - Protect your privacy with Zliki

  7. #7
    SitePoint Evangelist
    Join Date
    Feb 2006
    Location
    Worcs. UK
    Posts
    404
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by myrdhrin View Post
    But frankly you should stay away from SQL when dealing with Databases in RoR. Unless what you need to achieve can't be done any other way then through SQL.

    Migrations are really the way to go
    I have to say that I disagree with the first sentence.

    Yes, use migrations to create and modify tables. Migration is fabulous.

    However, that doesn't mean that you shouldn't also use SQL tools to check settings, view data, try temporary table adjustments, test non-standard SQL calls, check that what is being returned by your ActiveRecord query matches what you'd expect to be returned.

    Being able to check the database directly has to be a sensible thing to do, and personally I find a good GUI based system is ideal.

    I use MySQL with my RoR apps, and find MySQL database tools: Administrator and Query Browser to be invaluable.


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
  •