SitePoint Sponsor

User Tag List

Results 1 to 15 of 15

Thread: Tools for connecting to a database

  1. #1
    SitePoint Addict D3V4's Avatar
    Join Date
    May 2010
    Posts
    370
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Tools for connecting to a database

    I only know HeidiSQL, are there better solutions? I'm interested in Windows, Linux and Mac OS.

  2. #2
    SitePoint Addict
    Join Date
    Jul 2002
    Posts
    282
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm pretty happy with Navicat. Supports Mac, Windows and Linux. Supports MySQL, Postgres, SQLite, Oracle and SQL Server. The Lite versions are sufficient for basic reading, writing and some designing. The premium versions are full-featured.
    Pricetack - sell your goods with automatic markdowns

  3. #3
    SitePoint Addict D3V4's Avatar
    Join Date
    May 2010
    Posts
    370
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the suggestion

  4. #4
    Non-Member
    Join Date
    Aug 2010
    Posts
    44
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use SQLServer and MYSQL to connect to database.

  5. #5
    SitePoint Addict D3V4's Avatar
    Join Date
    May 2010
    Posts
    370
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    For now I'm using HeidiSQL with Wine on Linux.

  6. #6
    Do. Or do not. There is no try silver trophy
    SitePoint Award Recipient ScallioXTX's Avatar
    Join Date
    Aug 2008
    Location
    The Netherlands
    Posts
    8,341
    Mentioned
    85 Post(s)
    Tagged
    2 Thread(s)
    I use SQLYog on Windows. It's not free, but a nice application with tons of features.
    Rémon - Hosting Advisor

    Minimal Bookmarks Tree
    My Google Chrome extension: browsing bookmarks made easy

  7. #7
    SitePoint Enthusiast NicoJulius's Avatar
    Join Date
    May 2011
    Location
    Belgium, Europe
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use SQLYog free edition, works fine

  8. #8
    SitePoint Enthusiast
    Join Date
    Feb 2011
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i use sqlserver to connect to database
    i will suggest that

  9. #9
    SitePoint Addict D3V4's Avatar
    Join Date
    May 2010
    Posts
    370
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by jargonbust View Post
    i use sqlserver to connect to database
    i will suggest that
    Isn't this Windows only?

  10. #10
    secure webapps for all Aleksejs's Avatar
    Join Date
    Apr 2008
    Location
    Riga, Latvia
    Posts
    755
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  11. #11
    SQL Consultant silver trophybronze trophy
    SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,457
    Mentioned
    34 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by jargonbust View Post
    i use sqlserver to connect to database
    i will suggest that
    sql server isn't a tool for connecting to a database -- it's a database system server

    which leads to an interesting question for D3V4 ... what database are you looking for a tool to connect with?

    presumably it is mysql, as i believe heidi only works with mysql, but it would be nice to get confirmation
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  12. #12
    secure webapps for all Aleksejs's Avatar
    Join Date
    Apr 2008
    Location
    Riga, Latvia
    Posts
    755
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Since March 30, HeidiSQL supports MSSQL as well:
    Introducing support for MS SQL

  13. #13
    SQL Consultant silver trophybronze trophy
    SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,457
    Mentioned
    34 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by Aleksejs View Post
    Since March 30, HeidiSQL supports MSSQL as well:[/url]
    thanks, good to know
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  14. #14
    SitePoint Addict D3V4's Avatar
    Join Date
    May 2010
    Posts
    370
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    sql server isn't a tool for connecting to a database -- it's a database system server

    which leads to an interesting question for D3V4 ... what database are you looking for a tool to connect with?

    presumably it is mysql, as i believe heidi only works with mysql, but it would be nice to get confirmation
    Yes, it's mysql

  15. #15
    SitePoint Wizard bronze trophy Immerse's Avatar
    Join Date
    Mar 2006
    Location
    Netherlands
    Posts
    1,661
    Mentioned
    6 Post(s)
    Tagged
    1 Thread(s)
    I still use the 'old' MySQL Query Browser, it works fine.
    I think it's now a part of the MySQL workbench, which I don't enjoy using too much - it crashes and messes stuff up too often.

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
  •