Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
Which software do you use to administer your sql database?
Software like phpmyadmin or some other sql database software?
22 replies to this topic
Back to top|
|
|
#2
Posted 28 July 2008 - 06:34 AM
wahkiz
-
- Members
-
- 30 posts
Learning Programmer
phpMyAdmin =D its by the far the easiest to use.
Would like to see someone suggest some alternatives tho
Would like to see someone suggest some alternatives tho
#3
Posted 28 July 2008 - 07:22 AM
Orjan
-
- Moderators
-
- 3,298 posts
Writes binary right handed and hex left handed
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 :/
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 :/
#4
Posted 28 July 2008 - 07:26 AM
wahkiz
-
- Members
-
- 30 posts
Learning Programmer
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.
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.
#5
Posted 28 July 2008 - 07:44 AM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
I use a mixture of tools, but mainly Database Workbench Pro.
#6
Guest_Jordan_*
Posted 28 July 2008 - 07:47 AM
Guest_Jordan_*
Guest_Jordan_*
-
- Guests
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.
#7
Posted 29 July 2008 - 03:26 AM
wahkiz
-
- Members
-
- 30 posts
Learning Programmer
Lol, I am wondering what is the advantages of Oracle over mysql. Sounds interesting.
#8
Posted 29 July 2008 - 08:20 AM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
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.
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.
#9
Guest_Jaan_*
Posted 29 July 2008 - 02:48 PM
Guest_Jaan_*
Guest_Jaan_*
-
- Guests
I use phpMyAdmin also.. but Jordan.. I have Zend Studio and it's very lame.. believe me
#10
Guest_Jordan_*
Posted 30 July 2008 - 04:01 AM
Guest_Jordan_*
Guest_Jordan_*
-
- Guests
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 crap.
I agree though, the old version was crap.
#11
Posted 30 July 2008 - 09:53 AM
chili5
-
- Members
-
- 7,247 posts
Writes binary right handed and hex left handed
I use phpmyadmin. I find it good enough for my uses and it was pre-installed on my web server software. :)
