Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

Which software you use to administer your sql database?

SQL php

  • Please log in to reply
22 replies to this topic

#1 jessje

jessje

    CC Resident

  • Just Joined
  • PipPipPipPip
  • 63 posts

Posted 20 July 2008 - 02:18 PM

Which software do you use to administer your sql database?
Software like phpmyadmin or some other sql database software?
  • 0

#2 wahkiz

wahkiz

    CC Regular

  • Just Joined
  • PipPipPip
  • 30 posts

Posted 28 July 2008 - 06:34 AM

phpMyAdmin =D its by the far the easiest to use.

Would like to see someone suggest some alternatives tho
  • 0

#3 Orjan

Orjan

    CC Mentor

  • Moderator
  • 2918 posts
  • Location:Karlstad, Sweden
  • Programming Language:C, Java, C++, C#, PHP, JavaScript, Pascal
  • Learning:Java, C#

Posted 28 July 2008 - 07:22 AM

I use phpMyAdmin aswell for some things, but mostly I use MySQL's own GUI-Tool named MySQL Query Browser, downloadable for free from mysql.

the advantages with this is:

tabs to hold and work on several queries and resultsets at the same time.
it can load larger sql-scripts than phpMyAdmin can manage.
you get SQL syntax highlighting while writing your queries
you can as easy as with phpMyAdmin magnage your tables creating and modifying tables and stuff.

many web hotels don't allow access from remote to the sql-server though :/
  • 0

#4 wahkiz

wahkiz

    CC Regular

  • Just Joined
  • PipPipPip
  • 30 posts

Posted 28 July 2008 - 07:26 AM

Yeap, I would say that I find phpMyAdmin more useful than a GUI tool, because it's accessible regardless of how restricted the web access is. And second, I think it has the simplest and easily adaptable interface.

I remember XAMPP bundled a GUI tool to use with the MYSQL server, but I was so used to pma that I placed pma to use in local instead LOL.
  • 0

#5 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

Posted 28 July 2008 - 07:44 AM

I use a mixture of tools, but mainly Database Workbench Pro.
  • 0

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/


#6 Guest_Jordan_*

Guest_Jordan_*
  • Guest

Posted 28 July 2008 - 07:47 AM

I use PHPMyAdmin for MySQL and Toad for Oracle. Zend Studio has a built in MySQL tool that I'll probably be using in the future.
  • 0

#7 wahkiz

wahkiz

    CC Regular

  • Just Joined
  • PipPipPip
  • 30 posts

Posted 29 July 2008 - 03:26 AM

Lol, I am wondering what is the advantages of Oracle over mysql. Sounds interesting.
  • 0

#8 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

Posted 29 July 2008 - 08:20 AM

My observations on Oracle vs MS SQL vs Firebird:
Firebird is free, open-source, cross-platform, and works well until you get to around 20 GB in size. At that point it starts to slow down.
MS SQL is easy to manage, but does a few odd things, especially with Collations
Oracle is a pain in the rump to manage. It will not auto-truncate strings for you, it has very odd rules for handling date/time fields, etc. I think all this is to enable better internationalization, but it makes it a real pain for day-to-day usage.
  • 0

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/


#9 Guest_Jaan_*

Guest_Jaan_*
  • Guest

Posted 29 July 2008 - 02:48 PM

I use phpMyAdmin also.. but Jordan.. I have Zend Studio and it's very lame.. believe me
  • 0

#10 Guest_Jordan_*

Guest_Jordan_*
  • Guest

Posted 30 July 2008 - 04:01 AM

Do you have the new version based on Eclipse or the old version?? I really like the new version plus it is cross-platform. I can use it here at work in Windows, go home and load it in Linux. Not to mention I just took a week long class from Zend on using it.

I agree though, the old version was **.
  • 0

#11 chili5

chili5

    CC Mentor

  • Expert Member
  • PipPipPipPipPipPipPipPip
  • 3038 posts
  • Programming Language:Java, C#, PHP, JavaScript, Ruby, Transact-SQL
  • Learning:C, Java, C++, C#, PHP, JavaScript, Ruby, Transact-SQL, Assembly, Scheme, Haskell, Others

Posted 30 July 2008 - 09:53 AM

I use phpmyadmin. I find it good enough for my uses and it was pre-installed on my web server software. :)
  • 0

#12 Xav

Xav

    CC Mentor

  • VIP Member
  • PipPipPipPipPipPipPipPip
  • 8356 posts

Posted 30 July 2008 - 10:27 AM

I don't use anything, I don't have DBs. :(
  • 0
If you enjoy reading this discussion and are thinking about commenting, why not click here to register and start participating in under a minute?





Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download