Forums | MacLife
You are not logged in.
#1 2003-10-10 3:54 pm
- jdsmith575
- Member
- From: Texas Tech Univ.
- Registered: 2001-04-09
- Posts: 741
- Website
Working with MySQL: 3rd party interfaces
I don't know how many of you actually use MySQL for development, but I think quite a few here do use it.
In the past I have always kept a terminal window open with mysql going so that I could test queries. I started using CocoaMySQL about a week ago and have been impressed with how useful it is. Give it a try if you work with MySQL.
(I debated putting this in the sticky Web Editor Software thread, but decided it didn't really belong. Maybe we need a sticky thread for development related software.)
(And no, I am not the developer, nor was I paid to use CocoaMySQL. I'm just pimping it in the same way I pimp Hydra, err, SubEthaEdit.)
Offline
#2 2003-10-10 5:08 pm
Re: Working with MySQL: 3rd party interfaces
I tried an earlier version of CocoaMySQL and found it to be buggy, but this was a while ago. I've been using YourSQL exclusively for the past few months. The version I have is does not have as many features as CocoaMySQL, but I see that the latest alpha has a number of new features.
Offline
#3 2003-10-10 5:30 pm
- Macskeeball
- Member
- Registered: 2002-02-07
- Posts: 8014
- Website
Re: Working with MySQL: 3rd party interfaces
I use Complete MySQL, which is quite easy to use.
tech writer for hire
Offline
#4 2003-10-10 7:38 pm
- ViralDoctor
- Member
- From: Calgary
- Registered: 2003-01-18
- Posts: 2213
- Website
Re: Working with MySQL: 3rd party interfaces
After I had so much trouble getting mysql to work from the standard packages, I tried the Complete MySQL, and it saves alot of work. I recommend it.
As for software, I've tried both CocoaMySQL and YourSQL, and when I did try them (a couple of months ago) I favoured YourSQL because of the table for data input. I'll have to try them again - looks like they've both been updated since.
Offline
#5 2003-10-10 10:44 pm
- TonyPrevite
- Slobbering Jester
- Royal Wombat
- From: Glendale, AZ
- Registered: 2002-04-14
- Posts: 3606
- Website
Re: Working with MySQL: 3rd party interfaces
I debated putting this in the sticky Web Editor Software thread, but decided it didn't really belong. Maybe we need a sticky thread for development related software.
Well I think it deserves a sticky of it's own! I hope you don't mind me changing the title a bit 
If you don't mind paying a few bucks I've always liked SQL4X I've got an old version, looks like they have a Nice GUI for nearly all databases now...yummy 
Offline
#6 2003-10-12 12:34 am
- jdsmith575
- Member
- From: Texas Tech Univ.
- Registered: 2001-04-09
- Posts: 741
- Website
Re: Working with MySQL: 3rd party interfaces
Thanks for the stickyness Tony. By the way, does your name somehow come from a Hardy Boys character? I'm thinking it does for some reason.
/me makes a note to try YourSQL
Offline
#7 2003-10-12 1:46 am
- TonyPrevite
- Slobbering Jester
- Royal Wombat
- From: Glendale, AZ
- Registered: 2002-04-14
- Posts: 3606
- Website
Re: Working with MySQL: 3rd party interfaces
Nope that's my real name 
Offline
#9 2003-10-12 4:27 pm
- TonyPrevite
- Slobbering Jester
- Royal Wombat
- From: Glendale, AZ
- Registered: 2002-04-14
- Posts: 3606
- Website
Re: Working with MySQL: 3rd party interfaces
And you still can't spell....regardless of what your name is...check your sig for spelling will ya 
Offline
#10 2003-10-12 6:47 pm
Re: Working with MySQL: 3rd party interfaces
Lol... rwwwaaar, Tony!
Oh... Governator, is your avatar from DeusEx?
Now, on to the actual topic. I'm a biiig fan of PHPMyAdmin. I don't know about any of these other applications, but I really like the fact that I can access my application from any computer. Plus it's in PHP, which is cool. 
The one thing I've heard about it is that you can't always trust the generated PHP code... but I tend to write my own anyway, so it's not that big a deal for me.
Basseq is me, John Whittet.
(Finishing the remainder of the thought expressed in the post has been left as an exercise for the reader.)
Offline
#11 2003-10-13 12:07 am
Re: Working with MySQL: 3rd party interfaces
Lol... rwwwaaar, Tony!
Oh... Governator, is your avatar from DeusEx?
Now, on to the actual topic. I'm a biiig fan of PHPMyAdmin. I don't know about any of these other applications, but I really like the fact that I can access my application from any computer.
That's not necessarily a good thing. Unless I'm planning on travelling access to my database (which is unusual), I keep my phpMyAdmin local-only. My databases will only accept connections from inside the SGCN, so for me, putting phpMyAdmin in a DMZ of sorts rather defeats the purpose of my security measures.
Offline
#13 2003-11-22 8:24 pm
Re: Working with MySQL: 3rd party interfaces
3rd parties are nice. However I would strongly advice that you learn the sql syntax. Its not that hard, and the quickstart guide I purchased helped a lot. Although if you don't build your own content management systems these 3rd parties are helpful. I just build my own though took a lot of work. Phpmyadmin is good.
Offline
#14 2003-12-02 1:16 am
- jdsmith575
- Member
- From: Texas Tech Univ.
- Registered: 2001-04-09
- Posts: 741
- Website
Re: Working with MySQL: 3rd party interfaces
I agree. I learned both HTML and SQL the hand-coded way.
I've got a huge binder from my database class to prove it.
Offline
