CocoaMySQL

*The* Open Source MySQL Database Manager for Mac OS X 		  Latest Version: 0.5
Date: September 11, 2003

CocoaMySQL is localized in the following languages:

English
French (Beta)
German (Beta)

Features



Document Based Application
Documented Based
  • Because it is document based you can connect to multiple databases all at one time
  • Actions in one document window are separated from actions in another


Flexible Database Connections
Flexible Database Connections
  • Connect to multiple MySQL Servers locally or over the internet
  • Save connections and their options to a favorites list
  • Specifiy a different socket, or use the default
  • Specifiy a different port, or use the default
  • Specifiy a database to use by default


Database and Table Management
DB Management
  • Create and drop databases
  • Create, drop, or modify tables; can also rename them
  • Create, drop or modify fields and indexes
  • View, sort and filter table content by fields and keywords
  • Add, edit and/or remove rows
  • Manage indices and keys easily, even multiple ones for each table
  • Optimize tables with the click of a button
  • Create fields with a name, type, length, unsigned value, zerofill value, binary value, default value, auto incremented or non-NULL
  • Create fields of type: tinyint, smallint, mediumint, int, bigint, float, double, decimal, date, datetime, timestamp, time, year, char, varchar, tinyblob, tinytext, blob, text, mediumblob, mediumtext, longblob, longtext, enum and set


Content Viewing and Custom Queries
Custom Queries
  • View, sort and filter table content by fields and keywords
  • Perform custom queries
  • Save queries to a favorites list for later use
  • Perform queries out of your favorite text editor using the services menu
  • Keeps history of the most recently used queries
  • Can limit query results to a number you specifiy
  • Shows errors, if any, that are generated from a query


Data Importation and Exportation (Dumps, CSV, etc..)
Data Import and Export
  • Import an entire database or any CSV file
  • Export to a CocoaMySQL dump format, CSV format or XML format
  • Dump tables or entire databases to the formats listed above
  • Generate SQL table syntax of your tables for re-creation in another database


Text Encoding
  • Database content can be stored in the text encoding format you desire
  • Text Encoding options in CocoaMySQL: EUC-CN, EUC-JP, EUC-KR, EUC-TW, HK, ISO,ISO Arabic, ISO Cyrillic,ISO Greek, ISO Hebrew, ISO Latin-1, ISO Latin-2, ISO Thai, ISO Turkish, ISO 2022-CN, ISO 2022-JP, ISO 2022-KR, KOI8-R, Shift-JIS, UTF-8, Win Arabic, Win Baltic Rim, Win Cyrillic, Win Greek, Win Korean, Win Latin-1, Win Latin-2, Win Turkish, Win Vietnames


Binary Support for Images, Strings or Hex Representations
  • View and store database binary content correctly; for usage with images, strings or hex representations in blob or longblob fields


CocoaMySQL is Open Source!
  • The application is free, the source code is free. (GPL License)