Table of Contents
Please read the section on Database Export if you intend to use this feature
SQLEditor For Mac OS X is a program to help you work with databases. Relational databases are the main type of database that SQLEditor supports, however other types can also be used.
SQLEditor allows you to create, import, view, edit and export database structures. You can use it to create diagrams of databases showing the logical layout of objects within the database. You can save images of databases to use on webpages or in documents. You can also import and view the structure of live databases via JDBC
The SQLEditor support website contains additional information on SQLEditor.
This version of SQLEditor does not support Mac OS X 10.2
You should use the latest version of Mac OS X. If you are using Mac OS X 10.3 you need to use 10.3.9 If you are using 10.4 or later you should use the latest release available.
It is recommended to update the latest available version of java
SQLEditor is now (from 1.1.4b1) being provided as a universal binary. This means that it will work both on PowerPC based macs and Intel based Macs.
You must run SQLEditor natively. It will not run using Rosetta (and we even managed to disable the option to try!)
SQLEditor now (from 1.3.2) keeps a separate types list for each dialect that it knows about.
Note also that changes made from the field inspector will now only appear in the currently selected dialect.
Also new in 1.3.2 is the concept of a default data type. This is the type used when a new field is added from a menu or toolbar button. Previously this was always INTEGER, but it now a user preference. There is a different default type for each dialect.
The button "reset all dialects" will reload all type lists to the default lists provided with SQLEditor.
The new types system uses a separate file from the old types system so that old versions of SQLEditor should hopefully continue to work.
Reset All dialects uses only the list provided with SQLEditor. It does not reimport the types from legacy preferences files.
(If you are for some reason running multiple versions; please tell us what makes this necessary. It may be something that can be fixed.)
Ruby On Rails support is new in 1.3
Ruby on rails migration format is considered a dialect of SQL (not a database export) so you should choose export to SQL to use the feature. In addition, to use clipboard export you should set the document dialect in Document Options.
Data export may cause data loss
Database export is new in version 1.1
When you use "File->export to database" SQLEditor will attempt to synchronize the database with the current document. This means that if there are tables in the database that are not in the SQLEditor document those tables will be deleted.
In addition, altering existing tables which contain data is a risky activity at the best of times, so you may loose the data in tables that are not deleted.
There are some combinations of databases that don't react very well to trying to change tables, SQLEditor has particular trouble with Postgres before 8.0, because earlier versions didn't support the change column instruction, making changes to columns difficult. Try setting the drop table option if you have trouble.
If you experience a problem or if you see an error message please report it to support@malcolmhardie.com
Starting in version 1.1.0b7 SQLEditor will auto detect certain JDBC Drivers. These will automatically appear in the driver list without having to add them by hand. Any drivers that you have previously added will also appear in the list, it doesn't matter which you use, but you can if you wish delete any drivers that you have previously added.
The default table type in MySQL does not process or store foreign key information in most versions. To get foreign key support in MySQL you need to use the INNODB table type. If you do not use this table type then you may not be able to use foreign key support and this information will not be available if you later decide to export the structure back into SQLEditor, either by dumping using mysqldump or by direct import via jdbc.
Later versions of SQLEditor now have more support for recovering foreign keys from MySQL tables.
SQLEditor is not free. You can try it free for 30 days but after that you should buy a license for continued use. Buying a license gives you technical support and removes the registration reminder dialog box at startup. It also means that you're supporting further development and provides support for a small Mac software developer.
To buy a copy please visit our online store
Release versions of SQLEditor will ask for a serial number when they start up. All issued serial numbers should work, but if you have a serial number that doesn't seem to work please ensure that the name and serial code are entered exactly as provided to you. If this still doesn't work please contact support@malcolmhardie.com and we'll sort the problem out.
If you want to register a beta copy you can do this by choosing Help->Registration and entering your details. Registration of a beta version is valid and will show that the software has been registered.
Also when you later install a release version you should NEVER see the annoying registration window.
SQLEditor will automatically check for a new release when you start up and if you select the relevant option from the application menu. If you want to disable the automatic checking you can do so using an option in the preferences window.
During the version check no information is sent to us. The program simply downloads a file from our servers and checks the data in the file against its own version number. If you have any concerns about this please contact us (below) or turn the feature off
Thanks!
From version 1.1b4 you can now send suggestions using Help->Send Suggestion
This will create a new message in Apple Mail and offer the opportunity to automatically attach the SQLEditor log file.
Alternatively please send any comments you may have on any aspect of the software to:
This is the best way to ensure that your comments get read. We promise a real person will read every (non-spam) email.
If you need support please contact support@malcolmhardie.com
For sales queries please contact sales@malcolmhardie.com
To buy a copy please visit our online store.
SQLEditor, this document and all related materials are Copyright (c) 2003-2006 by Angus W Hardie and MalcolmHardie Solutions Limited
All rights reserved, unauthorized distribution, modification, reverse engineering or rental are prohibited in part or whole, except where legislation exists providing these rights.
This software may not be exported to any country to which software exports are prohibited under UK, US or European Laws.
An unfortunate but necessary disclaimer follows:
THIS SOFTWARE IS PROVIDED BY THE AUTHOR “AS IS” AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
All Trademarks acknowledged