YourSQL

Home

Visit the YourSQL Help files

Frequently asked questions

Features

Known issues

Download

Contact us!

YourSQL Does Not Run Under Snow Leopard
Apple has discontinued support for the Cocoa-Java framework under OS X 10.6 Snow Leopard, and since YourSQL is built on that framework, it does not run under Snow Leopard. OS X Leopard is the latest version of OS X that YourSQL will run under.

YourSQL is a simple but powerful program to create and manipulate MySQL databases. It is intended to be easy to use for the beginner as well as the more advanced user, and provides access to some otherwise underused, advanced features of MySQL, such as indices, InnoDB tables, multi-statement SQL scripts and multi-threaded handling of SQL dumps for backups or similar administration tasks.

YourSQL is an open source project from Ludit s.r.l..

Development Status: Singing Its Swan Song

As you may have noticed, there has not been any new development on the YourSQL project for a while.

The reason for this was that Apple - without any further explanation - deprecated the Cocoa-Java development framework, making it difficult to justify development of new features.

However, some experimentation showed that even with Leopard, YourSQL would continue to work, and so we decided to let this little app that could sing its swan song also on Intel Macs.

So without further ado, please download it here. We would still love to hear what you think, but don't expect any new features.

New Experimental Feature: Import/Export

After a long period of experimentation, the Import/Export function has been added to a public version! The function is still limited (handles only text data,) but sufficiently stable to be used on simple tables.

The Import tab is new and gives an opportunity to read in text data files, such as CSV files, tab delimiter files, standard web log files, etc. Load the file from the File menu.

If Autodetection is selected as file format (the default), a series of known standard file formats are tested on the first 10 records of the file. The first file format that gives a consistent result (all records read have the same number of fields) will be used as autodetect result.

The first record can be used as column titles, and again an attempt at automatic detection of this is done. The criteria is at least one column with the first row beginning with a character and all other rows not beginning with a character.

Whether the first record consisted of titles or not, the title of the selected column can be changed - use the Col name button.

Finally, the OK button will create a new table (with all columns VARCHAR 255) in the selected database.

CSV files can be exported from the File menu.

Please notice: There is currently no way to handle large files. A realistic limit to file size is around 2MB for importing text files.

Should the autodetection not recognise your format, use the File fmt button to produce a drawer with the possibility to specify exactly the special-char-delimiter format you want, as long as the delimiter is a printable character.

Features

• Now a Universal binary, working on both Intel and PPC. Requires OS X 10.4 or higher.
• JDBC driver updated.

From 1.8.0e:

• Toolbars can now be configured with space and dividers.
• Tooltips have been added to toolbar items.
• A bug which affected dumps when installed in a path with spaces in folder names has been solved.
• Error handling of dump processes has been improved.
• JDBC driver updated.

From 1.8.0d:

• bug which made a modification in the Design Table view change tab to the most resently used tab has been solved.
• Now builds cleanly under Tiger.
• Export data now has an option to include column names in the first row for both CSV and Excel files.

From 1.8.0c:

• Ordering (ascending or descending) of column data in Show Data tab.
• Re-ordering of columns in Show Data tab, saved for next viewing of table.
• Selected tab stored for each table between table viewings.

From 1.8.0b:

From 1.8.0a:

• Export tables as CSV (comma separated values) text files, readable by spreadsheet programs, text editors and many data conversion utilities.
• Export tables as Microsoft(TM) Excel(TM) Workbooks, readable by Excel and many other spreadsheet programs. All field types are currently exported as text fields.
• Import tabular text files. Interface to specify field delimiter and line endings.
• Automatic recognition of field delimiters and line endings for a range of common combinations (Tab delimited, CSV, common log format, semicolon-delimited).
• Preview of data with possibility of to edit before final import into the database.
• Import as new table in current database, with all fields set to varchar(255).
• Option to set column names from first row of data when creating new table.
• Import into existing table with same number of columns.

Screen shots
Click on the small pictures below to see what the app actually looks like in daily use

Design Table

Free Form SQL

Features Of Version 1.7

• Works on OS X 10.3 and 10.4.
• Error messages in the Free-Form SQL tab are now shown in a text view, allowing longer messages to be shown on more than one line.
• Dates, Datatimes and Timestamps now accept values with year 0000, thanks to a new option in the JDBC driver.
• Functionality to keep column widths in the Show Data tab has been restored.
• A use of a deprecated method generating a warning when closing a window has been fixed.
• Java stack traces included by the driver in error messages have been removed to provide a clearer understanding of the problem.
• UTF-8 can now be handled when stored on databases configured for latin1. This feature can be activated through a special entry called "UTF-8 + latin1 (server)" in the list of possible character sets. This option does not work for Dumps and Loads of SQL files, which require a correctly configured database to produce expected output.
• A bug always showing the character set for a connection as "As reported by server" in the change connection pane has been fixed.
• The "Case Sensitive" option, which was based on the behaviour of MySQL 3.23.X and 4.0.X, has been disabled for MySQL 4.1.X and later databases, as they do not provide a reliable means to retrieve the data in Java.

From version 1.7.0beta11

From version 1.7.0beta10:

• External links on help pages work properly
• Tabbing from user id to password in the New Connection dialog works
• Help text regarding dumps has been updated

From version 1.7.0beta9:

• German localisation by Stephan Bergmann - thanks Stephan!
• Dumps and loads completely reworked, now use MySQL's own tools to ensure compatibility and reduce character set problems
• A bug causing the last column to be only a few pixels wide in the Show Data tab has been solved
• Better error messages in case of connection, login or network problems with a help anchor button to specific help pages for each problem with links directly to the MySQL forum on entropy.ch for users who would like to discuss their issues with other Mac MySQL and YourSQL users. Thanks to Marc at entropy.ch for providing the forums!
• Help pages worked over to remove the most blatantly outdated parts

Changes in version 1.7.0beta6:

• This version fixes (hopefully) an irritating bug causing crashes when dealing with large databases or changing the selected table fast.
• Now compatible with the latest MySQL drivers again.

• A new live search feature provides immediate search for partial strings in table data, developed by Julian Fricker.
• Live search is carried out in all columns for quick searches or in a single specified column for specific purposes.
• Selected table rows can be dragged to other applications or to the desktop as clip files. (from iSQL-Viewer, by Markus A. Kobold)
• Selected table rows can be copied to the clip board and pasted into other applications. Based on the drag-n-drop code.
• The Tab key (or the standard Alt-Esc combo) provide code completion with table and column names.
• Column re-ordering.
• Immediate update and synchronisation of row view guaranteed for tables with a primary key, when editing non-primary key columns.
• Immediate update of tables without a primary key, no synchronisation of the view.
• Refresh Data menu item to synchronise view with changes from other sources.

Markus is doing research into modularisation of Java code and has generously ported some of his results to Cocoa-Java for the benefit of YourSQL and it users.

YourSQL is Open Source, and the download is free.

All comments to yoursql@ludit.it