CocoaMySQL-SBG

Update: 2008-07-22
I almost thought about playing like working on this again. To that end I have moved my source into mercurial and bitbucket. You can browse the repository via http://bitbucket.org/glennsb/cocoamysql-sbg/

Update: 2006-02-21 - CocoaMySQL-SBG 0.7.1
Another update to the Universal Binary version of the CocoaMySQL-SBG. Main thing this adds in is some query completion for MySQL reserved words and table names thanks to Carsten Blüm. Using the built in Mac OS X text completion keys (esc, opt-esc, F5, or command period) it will attempt to complete in the custom query browser an SQL query using SQL keywords or table names of the current table.

APP - CocoaMySQL-SBG-v0_7_1.dmg.zip

SRC - CocoaMySQL-SBG-0_7_1.zip

Update: 2006-01-24 - CocoaMySQL-SBG 0.7.0b1
In preperation to play around with the arrival of an intel based mac, I have tossed together a new release that might be a universal binary. Note I don't yet have an intel machine upon which to test this, but as a powerpc it is working alright for me.

This version also has some of the changes I was working on for awhile before I got totally sidetracked. So it could be very half baked and very crashy. I have also changed the name more and the preference key, so all your old preferences and favorites will have to be redefined. The SMySQL framework backend is now built with a libmysql from the 5.0 release.

APP - CocoaMySQL-SBG-v0_7_0b1.dmg.gz

SRC - CocoaMySQL-SBG-v0_7_0b1-src.dmg.gz

Here is my version of CocoaMySQL. It has some changes I have made. It works for me and a few of my coworkers. That said we are all running 10.4.2 and connecting to MySQL server(s) running various patch levels of 4.0 and 4.1. So it may or may not work for you. I don't have time to test everything in all combinations, I know it works for me and we find my changes useful. Perhaps some others will as well.
Stuart Glenn

APP - CocoaMySQL-SBG-v0_6_5.dmg.zip Should fix connecting to 4.1.14 servers. Also added an IN statement search in the content tab, the user is responsible for correct quoting and comma separating values when using this.
SRC - CocoaMySQL-SBG-v0_6_5-src.dmg.zip
APP - CocoaMySQL-SBG-v0_6_4.dmg.zip Might fix timestamp and number display issues
SRC - CocoaMySQL-SBG-v0_6_4-src.dmg.zip
SRC - CocoaMySQL-SBG-v0_6_3-src.dmg.gz, should work against a 4.1 mysql server
APP - CocoaMySQL-SBG-v0_6_3.dmg.gz, should work against a 4.1 mysql server

Changes:

2005-10-06: Might fix up connection issues people are having with 4.1.14 servers. Added an IN statement searching to the content tab. Could break a whole lot more
2005-05-17: Interim release of 0.6.4 to fix timestamp and some number display issues while I work on other stuff
In the 0.6.3 version the SMySQL_bundled.framework was built against mysql-max-4.1.5-gamma release from mysql.com. This means that CocoaMySQL should connect to 4.1 servers (and in my limited testing, which was all of 30 minutes) works against the 4.1 and 4.0 server on my powerbook.
ANSI style string quoting. Will work against MySQL server in ANSI mode. Still works with MySQL running in standard mode.
Add copy (and drag-n-drop) from of result rows from the Contents pane table and the custom query results table. Data copied out will be a line per row with each field separated with a tab.
Reordered Login & add favorite panels. Grouped host, username, password and database name togeter & tab ordere between.
Added some tab order stuff in the main DB view window.
Removed unused Table Dump tab
Updated source project to be Xcode based and buit with latest 2.3.1 of the SMySQL library.
Added some memory deallocations to free memory that is no needed.