Version History
This document contains details of changes made in each release of SQLEditor
- 1.7.18
- Release of 1.7.18b1
- [includes: 1.7.18b1]
- 1.7.18b1
- First gatekeeper signed version (for mountain lion)
- Fix for bug where object locations could be corrupted
- New minimum System 10.5.8 (due to gatekeeper signing)
- 1.7.17
- Release version of 1.7.16b3
- [includes: 1.7.16b1,1.7.16b2,1.7.16b3]
- 1.7.16b3
- Rewrite of layering system (from v2.0) to fix a performance issue when pasting.
- 1.7.16b2
- Fix for undo when pasting
- 1.7.16b1
- MySQL unique could be ignored by importer if table name contained mixed upper and lower case
- Fix for Oracle foreign key importing
- Fix for oracle export, on update is now not exported if set on foreign key since most oracle SQL doesn't support this
- Fix for bug with indexes on export which could cause a duplicate index exception due to incorrect matching
- 1.7.15
- Release version of 1.7.15b1
- [includes: 1.7.15b1]
- 1.7.15b1
- SQLite autoincrement keyword parsing
- SQLite add column fix
- 1.7.14
- Release version of 1.7.14b1
- [includes: 1.7.13b1,1.7.13b2,1.7.14b1]
- 1.7.14b1
- Fix for 10.4 compatibility
- Fix for parsing single alter table with multiple foreign key instructions
- 1.7.13b2
- fix for YEAR keyword with and without PRECISION
- fix for DOUBLE keyword and PRECISION keyword
- fix for some other keywords that weren't reliably recognized.
- 1.7.13b1
- This release contains sql parser improvements:
- Parser now supports both TIMEZONE and TIME ZONE for relevant time types
- Parser add support for some missing data types (including CURSOR)
- Parser better handling of keywords that are also identifiers
- Parser better handling of intervals for postgres and oracle
- 1.7.12
- Release version of 1.7.12b1
- [includes: 1.7.11b1,1.7.12b1]
- 1.7.12b1
- Fix for cardinality on table level foreign keys not saving
- SQLite export now uses double quotes for identifiers and single quotes for quoted values
- 1.7.11
- Release version of 1.7.11b2
- [includes: 1.7.11b1,1.7.11b2]
- 1.7.11b2
- Added zoom menu item to toolbar
- added zoom menu to context (right click) menu in main window
- 1.7.11b1
- removed zoom placard to fix lion scroll tearing with gesture mouse (FS#923)
- removed scroll zoom option (to return in b2)
- 1.7.10
- Release version of 1.7.10b2
- [includes: 1.7.10b1,1.7.10b2]
- 1.7.10b2
- SQL Import: now collapses single entry indexes into a field level index
- SQL Import: better handling of double quote mark escaping
- 1.7.10b1
- Fix for type field parsing so that it correctly splits enums where the enum string contains a closing bracket
- 1.7.9
- Image Export improvements
- Exported PDF images now match the size of exported bitmaps
- Exported images and printed documents no longer display selected objects
- Preference to optionally display selected objects in prints and exported images
- Fix for saved images sometimes being blank
- 1.7.8
- Release version of 1.7.8b1
- [includes: 1.7.8b1,1.7.7b2,1.7.7b1]
- 1.7.8b1
- Fix for preference bug (keys and values switched in 1.7.7b1)
- 1.7.7b2
- Fix for bug where the first connection preset couldn't be deleted
- 1.7.7b1
- SQLEditor now registers itself only for the current user when running on Lion/10.7
- Fix for error with how update menu item was being created
- Fix for for database panel presets not saving port numbers
- Fix for database panel connection delete preset option being enabled when it shouldn't be
- Updated nib files to remove redundant objects
- 1.7.6
- Release version of 1.7.6
- [includes: 1.7.6b4,1.7.6b3,1.7.6b2,1.7.6b1]
- 1.7.6b4
- Fix for bug where JDBC table filters were being used when exporting (FS#894)
- 1.7.6b3
- Fix for MySQL timestamp where default value is NULL also needing NULL on column (FS#891)
- Fix for Postgres BIGINT should match BIGSERIAL when type matching foreign keys (FS#889)
- SQLite foreign keys now export ON DELETE and ON UPDATE actions correctly (FS#892)
- 1.7.6b2
- Fix for bug where db connection strings not updating when preset changed [FS#890]
- 1.7.6b1
- Find objects now searches for the string anywhere in the object name (not just at the beginning)
- Fix for alter table engine export bug
- Fix for crash when typing accented characters or symbols into table name field
- Ruby on Rails now generates "references" statement in migration export
- Ruby on Rails importer now imports some types of references statements
- 1.7.5
- Release version of 1.7.5b1
- [includes: 1.7.5b1]
- 1.7.5b1
- Rewritten help menu handling
- Fixed bug where setString could be called with nil on modifying a field with unique property set
- Fix for plugin menu handling not working
- 1.7.4
- Release version of 1.7.4b4
- [includes: 1.7.4b4,1.7.4b3,1.7.4b2]
- 1.7.4b4
- Fixed to support sparkle beta appcast correctly
- Modified update system to fix other minor bugs
- 1.7.4b3
- Fix for table and canvas area name editing not updating with typing
- JDBC password saving between operations improved
- New preference to save last password in keychain (Preferences | database | JDBC Options)
- Fix for connection string not updating when changing preset
- 1.7.4b2
- Fix for object layering bug
- Obsolete foreign key preference removed
- Updated sparkle to newer release
- Option to report statistics on system configuration when updating
- Fix for paste not working without clicking on canvas first
- Slight changes to appearance and z-order behavior of connector labels
- 1.7.3
- Release version of 1.7.3b4
- [includes: 1.7.3b4,1.7.3b3,1.7.3b2,1.7.3b1]
- 1.7.3b4
- Fix for bug where pasting a field would put new field in wrong location (bug in 1.7.3b3)
- Fix for bug where duplicating a field would put new field in wrong location (bug in 1.7.3b3)
- Fix for some uid related issues
- Fix for schema name reseting to empty when editing table name
- 1.7.3b3
- Improved file saving, fewer unnecessary changes and improved scm compatibility
- Objects in saved files should now be generated in a more predictable order
- Fix for bug where copying field would put entire document's SQL on clipboard
- Fix for bug in table schema name edit field when field focus lost
- Removed obsolete xml export code
- Fix for bug with cardinality editing which caused stray error messages in log
- 1.7.3b2
- ON UPDATE now imported from JDBC
- SQLite JDBC username bug fixed
- Fixed "Don't quote default value" setting with postgres
- 1.7.3b1
- Added ON UPDATE for foreign keys
- Improved quoting in Postgres for data/time constants in default values
- Fix for Ruby On Rails down methods using underscore to camel case incorrectly
- Improved inspector code and removed obsolete parts
- Switch to zip format for distribution
- 1.7.2
- Release version of 1.7.2b2
- [includes: 1.7.2b1,1.7.2b2]
- 1.7.2b2
- Fix for bug where object locations weren't saving
- 1.7.2b1
- Fix for plugin export failures
- Fix for schema name being nil on export
- Fix for possible crash with keychain code
- Modified database export to simplify code in settings window
- 1.7.1
- Release version of 1.7.1b1
- [includes: 1.7.1b1]
- 1.7.1b1
- New default cardinality for imported objects (separate from user created objects)
- Improved default cardinality settings
- Fix for ON_UPDATE handling in inspector
- ON_UPDATE changes now correctly cause updates in SQL source view
- Fix for Simulate option not working in some cases (Oracle, Filemaker)
- Fix for possible JDBC failures with database that used "database" as a setting name
- Commenting out SQL now only occurs in Non-JDBC mode
- Fix for missing semi-colon in Constraint export
- Oracle index updating fixed
- Improved internal handling of JDBC connection settings
- Removed obsolete code
- 1.7.0
- Release version of 1.7.0b2
- [includes: 1.7.0b1,1.7.0b2]
- 1.7.0b2
- Added image export alpha (transparency) support
- Better import of Oracle foreign keys which don't reference primary key
- Rewritten inspector system
- Fix for auto increment option incorrectly appearing in Oracle SQL
- Fix for bug where source view stopped updating after failed database export
- Improvements to plugin system
- Fix for possible crash in SQL parser + other minor improvements
- Object name quoting is now off by default
- Minor parsing improvements
- Ruby On Rails Plugin now uses system sandbox and should work better with rvm
- Ruby On Rails plugin now requires 10.5 or later
- 1.7.0b1
- Internal release only
- 1.6.9
- Release version of 1.6.9b2
- [includes: 1.6.9b1,1.6.9b2]
- 1.6.9b2
- Fixes for multiple indexes being added
- Fix for indexes being incorrectly added
- Duplicate index adding fixed
- Modified single entry index collapsing to work better with JDBC export
- 1.6.9b1
- Fixes for incorrect index dropping during export
- Fix to make index names unique with indexed option
- Table, field and other object names are now quoted by default
- 1.6.8
- Improved progress bars and status information during database operations
- Improved database updating (fewer unnecessary DROP, CREATE cycles)
- Parser improvements (Oracle constraint parsing, MySQL + postgres alter table)
- Applescript improvements
- Added custom url based registration system
- Fix for duplicate indexes with table prefixes
- Fix for dropping UNIQUE keys
- Fix for index altering not working
- Fixed bug which caused empty instructions to be executed during updates
- Fix for multiple CREATE INDEX instructions being executed
- Fix for MySQL types being changed on export when size was missing in document
- Fixed mismatch highlighting with unsigned integers for foreign keys
- Better handling of MySQL foreign keys when exporting to database
- Fixes for importing single entry UNIQUE keys (Now imported to UNIQUE option on field)
- Better handling of single entry indexes (optionally)
- Minor user interface changes
- Fix for canvas area naming and renaming not working
- Find menu item now opens find window
- Find object list now updates when switching documents
- Improved inspector display when editing foreign key objects
- Added label editing for foreign key objects
- Removed some unneeded logging messages
- 1.6.7
- Internal development version only
- 1.6.6
- Removed a conversion between XML and string format when loading (efficiency)
- Improved load/save
- Fix for bug which caused import to fail with unrecognized selector on NSDocumentController
- 1.6.5
- Fix for parser with mysql table options separated by comma
- Fix for parser create index instructions with prefix
- Exporting index prefixes now works with more data types in MySQL
- 1.6.4
- Improved handling of duplicate foreign key indexes on sql export
- Fixed checking for new beta versions in a release version
- Fix for a bug where a deallocated selection was mistakenly being accessed when closing a document
- [includes: 1.6.4b2]
- 1.6.4b2
- Comments can have now have any title (older SQLEditor versions will rename on opening)
- Improved object renaming when double clicked
- Fix for index prefix sizes added on sqlite and others (now only added when supported by database)
- Re-factored various bits of import and export code
- Improved modification of existing database foreign keys
- Improved memory management in JDBC and database operations
- Better index naming with JDBC export
- Better reporting of JDBC and database errors
- Fixed some memory leaks
- Improvements to the SQL parser for parsing stand-alone create index statements
- Better handling of comments and commented sections when parsing SQL
- New Preflight window (although only two actual preflight tests yet)
- Fields can now draw warning icons for issues in preflight
- Preflight actions can be added from a plugin
- Filemaker JDBC driver now auto-detected
- Experimental filemaker dialect (doesn't work for export yet)
- Fixed a bug which caused a concurrent modification error when closing a document
- 1.6.3
- Fix for some Help Menu items not working
- Release version of 1.6.3b1
- 1.6.3b1
- Fix for Preferences window on 10.4
- Fix for SQLite default value constants (CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP)
- 1.6.2
- Type lists can now be provided from a plugin
- Plugin system now loads only newest plugin for each identifier (based on CFBundleVersion)
- JDBC now supports importing types in lowercase
- Oracle JDBC importer now ignores objects in recycle bin (starting BIN$)
- Rails importer now parses schema.rb files
- Rails exporter can now create schema.rb files
- Fix for SQLite data type sizes when importing via JDBC (now ignores sizes on types when importing)
- Now correctly quotes default values for DATETIME and TIME in MySQL
- Fix for MySQL export when ON DELETE was set to SET NULL (unsupported in mysql dialect)
- MySQL Exporter now adds a size to VARCHAR types if none is specified (as is required)
- SQLEditor now supports lower case for field types
- "Automatically add new types as used" has been removed (add using preferences window instead)
- Improvements to "Add type" system in preferences window
- 1.6.1
- Better handling of errors during image export
- Modified image export to better handle large images
- Improved SQL server database import and export
- JDBC Import bug fixes for statistic indexes (mainly for SQL Server)
- bug fix for columns occasionally appearing in wrong tables on import from jdbc
- Support for indexes in rails migrations
- Improved object and file naming in migrations
- Snap to grid now snaps to bottom right as well as top left (with preference setting)
- Fixed reordering of tables with foreign keys in exported SQL
- Modified Export preferences to separate Rails migrations into new pane
- SQLite primary key handling modified (better handling of multiple int primary key columns)
- SQLite foreign key handling improved (fixed some bugs in the sql export)
- Fix for sqlite database files having file extension included twice
- Better handling of file errors when opening and importing files
- 1.6
- Release Version
- New online help
- Changed position of inspector on first launch
- 1.6b17
- Fix for table level COLLATE and CHARACTER SET being swapped when parsing from SQL
- Fix for Table and field sql comment (notes) editing changes altering all comments
- Fix for bug when renaming table or field to the empty string (now returns to previous name)
- Fix for comment naming
- Improved document meta data handling (SQLDocumentInfo)
- 1.6b16
- SQL parser improvements including better handling of TIMESTAMP, COLLATE and CHARACTER SET
- Improved error reporting of SQL parse errors
- Fix status window display when pasting SQL into SQLEditor
- Fixed SQLConstraint exporting
- Better auto complete in field type box
- Show Inspector Menu Item not changing when closing window
- Better memory handling with database drivers
- Fix for a memory handling bug in document loading
- New palette images
- Updated code signing certificate
- Added user interface for ON UPDATE (for timestamps in mysql)
- Fixed bug with empty quoted default values
- 1.6b14
- Fix for foreign key objects not updating if fields that they reference are deleted
- Fix to allow setting entries in foreign key object back to unset.
- Fix for bug that caused indexes and foreign keys to get duplicated unexpectedly when dragging
- JDBC drivers can now be loaded from the SQLEditor specific directory again
- Fixed custom (non label) object colors
- field inspector now defaults to its options panel when first starting SQLEditor
- MySQL table collation and character set exporting now exporting correctly
- Fix for bug with non-object compound foreign key deleting
- Improved smoothness when dragging foreign key connections
- JDBC export should now correctly drop foreign keys that have been deleted in the document
- 1.6b11
- Connectors can now be repositioned in orthogonal mode (which was broken in 1.6b7)
- SQLite exporting integer primary keys now behaves better
- JDBC import now imports NOT NULL status on columns better
- Save as image files now exports correctly in the chosen format
- Fix for log messages on 10.6 about requested Java version
- Fix for bug which could cause a crash when closing documents immediately after opening
- Reordered some JDBC export instructions to make certain changes to tables after adding columns (rather than before)
- Fix for bug with boolean settings which are not properties when loading documents (which could affect primary keys and some other settings)
- More reliable index deleting during JDBC export to MySQL.
- Modified XML generation for better reliability and improved readability. You may notice this change if you do a diff on SQLEditor documents.
- Index prefixes now work again
- Fix for possible crash with document options panel
- Fix for a bug in copy/paste code
- 1.6b9
- Fix for crash in preferences window
- Added connection timeouts on some JDBC drivers
- Modified layout of database preferences panel
- Fixed a bug causing an error message to be logged about multiple copies of ObjePCRE
- Better handling of SQLEditor documents that incorrectly contain objects with the same name
- 1.6b8
- Fix for foreign key import with schema not connecting foreign key links
- Reordered post load instructions in JDBC export
- Fix for JDBC import not setting dialect correctly
- 1.6b7
- Fixed a crash that could occur when switching dialects
- Fix for a bug that could corrupt files with old style compound foreign keys
- Improved broken file recovery.
- 1.6b10
- Not released
- 1.6b6
- Fix for strange object dragging behaviour with overlapping objects
- improvements to JDBC import and export
- fixes for index handling
- fix for foreign key naming when several foreign keys link to one target
- reduced number of log messages when exporting
- removed dependency on IOKit for identifying Mac model name
- IF NOT EXISTS now available on indexes in SQLite (for file export)
- IF NOT EXISTS now not used in JDBC code
- Fix for XML bug that could cause problems saving files if they were damaged
- fixes for label color handling when label data elements were damaged or missing
- fix for an issue that prevented boolean properties being used by JDBC drivers
- fix for user interface visual glitches on load
- some internal fixes and improvements
- 1.6b5
- Improved visual feedback when dragging foreign keys (The cursor changes)
- Fix for SQLite IF NOT EXISTS
- Fix for a bug that caused SQLite to be listed more than once in various menus
- Better handling of exporters that handle more than one driver
- Fix for a bug involving Postgres (and possibly other) foreign key operations failing due to a an incorrect comparison
- Fix for hang when dragging from a field to a foreign key object
- Fix for some unexpected exceptions
- Improved XML processing on 10.6
- Table and column comments in MySQL are now trimmed to the maximum supported length when exporting.
- 1.6b4
- First public 1.6 beta release
- Minimum System requirement now 10.4
- Improved toolbar icons
- Support for 10.6 (Snow Leopard)
- New ANTLR based SQL parser
- Improved model code (now entirely Objective C)
- Rewritten Java interface (now using JNI)
- Improved Inspector handling
- User Interface improvements
- Labels are now per-document instead of global as in 1.4.x
- There is a new labels window to allow renaming labels and changing label colors
- Rewritten preferences window system
- Document auto-save
- 1.5
- Test and development releases towards 1.6
- 1.4.7
- All improvements from 1.4.6b1 to 1.4.6b7
- [includes: 1.4.6b1,1.4.6b2,1.4.6b3,1.4.6b5,1.4.6b6,1.4.6b7]
- 1.4.6b7
- Corrected SQLite types list
- Forward delete key should now work to delete objects
- Improved handling of indexed property on fields when re-exporting
- Fixes for two internal bugs in the object name handling system
- Better (but probably slower) handling of objects with dark background colors. (Option at Preferences->Appearance->Colors)
- 1.4.6b6
- Now identifies columns that differ in "unsigned" setting when looking for mismatches in foreign keys
- 1.4.6b5
- Improved canvas dragging
- Improved behavior of object selection and dragging
- Fix for option+drag copying of objects when the object isn't selected
- Index inspector name warning now works properly
- Fixed a button icon that wasn't appearing correctly on systems earlier than 10.5
- 1.4.6b3
- New tables are correctly named when there is another table which has a name that differs only in case
- Tables cannot now have names that are different only in case. (Which wasn't correctly enforced before)
- 1.4.6b2
- Group dragging fixed
- Improved copy and paste. Objects now act more intelligently when connecting to existing objects
- Bug fix for possible crash when deleting tables containing connectors
- Change to default names for indexes
- Table names are now (optionally) prefixed onto index names when created (although they can be renamed)
- Changed behavior of index exporting. Table names are not now automatically added to index names on export
- 1.4.6b1
- New Icons
- New Toolbar graphics
- 1.4.5
- Release version of 1.4.5b1
- [includes: 1.4.5b1]
- 1.4.5b1
- Fix for bug selecting connectors
- Fix for double clicking table action bug (resize/rename)
- Fix for bug which caused connectors to be incorrectly released when canceling a create connector action more than once.
- 1.4.4
- All improvements from 1.4.4b1 to 1.4.4b2
- [includes: 1.4.4b1,1.4.4b2]
- 1.4.4b2
- Fix for error message when importing from Oracle
- Fix for bug that moved connector handles when an object was pasted into a document
- 1.4.4b1
- New foreign key object with support for multi-column foreign keys
- New options to modify behavior when importing foreign keys (via JDBC)
- Scroll+Cmd key now zooms when in normal (zoom-scroll=off) mode
- Fix for "on delete" actions not being saved
- Added jTDS driver support (needs more work still though)
- Improved SQLite foreign key handling
- New dialect menu for source view
- Option to include "IF EXISTS" when exporting to SQL
- Rewritten object movement code to fix possible location bug
- PLUS: New and improved Icons (including larger 512x512 sizes)
- 1.4.3
- All improvements from 1.4.3b1 to 1.4.3b3
- [includes: 1.4.3b1,1.4.3b2,1.4.3b3]
- 1.4.3b3
- Fix for incorrect commas between fields and indexes
- Added simulate export to database mode
- Added option to disable dropping fields and indexes
- Status window now shows failed exports in list
- Fixes for index modification and adding on database export
- Better handling of foreign key modification
- Some fixes for instruction ordering when using database export
- Fix for possible crash when removing an index that has just been added
- 1.4.3b2
- Improved code to detect pre-existing indexes on JDBC export
- Fix for better handling of altering primary keys in MySQL
- Modified generated SQL in JDBC Export to better handle indexes on MySQL foreign keys
- Fixed to remove comma from index if empty and commented out
- Modified Comment object to resize text area correctly
- Better handling of exporting indexes where table names are appended automatically
- modified parser to remove quoting characters when importing
- Correction for fix to Drop Table without schema
- 1.4.3b1
- JDBC importer can now correctly import comments on tables and columns
- JDBC exporter can now modify comments on existing tables and columns
- Fix for cursor jumping in table comments
- Fix for error displaying document info window
- Minor fixes for some parser bugs (CREATE DATABASE/DROP TABLE with schemas)
- Fix for a bug where the inspector didn't appear when dragging to select a single table
- Fix for table inspector not appearing when clicking the parent table button
- 1.4.2
- All improvements from 1.4.2b1 to 1.4.2b3
- [includes: 1.4.2b1,1.4.2b2,1.4.2b3]
- 1.4.2b3
- Fix for comments on fields in MySQL exporter having extra '=' (equals) sign
- 1.4.2b2
- Modified MySQL exporter to use ENGINE instead of TYPE for better compatibility
- Comments now attached to fields when exporting MySQL (i.e COMMENT 'xyz' style)
- Connector inspector is now displayed automatically when a new connector is created
- More padding added to line click detection to make it easier to click on connectors
- Now correctly parses comments attached to mysql fields
- Fix when using Postgres and reexporting objects without specified schema names
- Database window now doesn't save passwords that aren't part of a preset
- Improvements for quoting with Sybase and MS SQL-Server
- Fix for an undo bug that prevented tables with some arrangements of connectors being un-deleted
- 1.4.2b1
- Added support for editing MySQL character set and collation settings on fields and tables
- Modified inspector on fields to use popup menu for selecting tabs
- Fixed bug that prevented saving files after creating new foreign keys when referencing primary keys in tables with indexes
- 1.4.1
- All improvements from 1.4.1b1 to 1.4.1b4
- [includes: 1.4.1b1,1.4.1b2,1.4.1b3,1.4.1b4]
- 1.4.1b4
- Fixes for SQL parser errors when importing some kinds of keys and indexes
- Fixes for better parsing of several MySQL specific SQL fragments
- 1.4.1b3
- Fix for image export types being wrong
- Modified foreign key handling with compound keys
- Some internal improvements for better performance
- Fixed undo menu text (was showing wrong object types)
- Fix for undo movement of connector control handles
- Fix for bug which caused deletion of compound foreign keys to fail when dragging from on the secondary fields
- 1.4.1b2
- SQL Parser: Multiple instructions in single table alter
- Better ignoring of insert and update instructions affecting database data
- Fix for (null) appearing as index prefix size with mysql
- Modified MySQL export to better handle types that require index prefix sizes
- SQL Parser: Better handling of CONSTRAINT primary and foreign keys in tables
- Better error reporting for some kinds of error (instead of "no reason given")
- SQL Parser now ignores temporary tables (with message)
- 1.4.1b1
- Fix SQL parsing bug: multiple parts in alter table instruction
- Fix for SQL parsing bug: error with foreign key in table body
- Better handling of SQLEditor specific JDBC driver directory
- "Open Driver Directory" button in preferences now opens SQLEditor specific directory
- 1.4
- Release version
- 1.4b26
- Fixes for auto increment with SQLite
- Final Candidate Version for 1.4
- 1.4b25
- Fix for an odd bug that would sometimes cause SQLEditor to quit on startup
- Fix for a bug that caused JDBC Imports to fail with foreign keys that didn't have names
- Minor code improvements
- 1.4b22
- Fix for Java Update for Mac OS X 10.5 release 1 bug.
- 1.4b21
- Improved handling of database connection settings
- Fixes for SQL output correctness issues
- Note text field cursor jumping problem fixed
- Fix for connector control handle not dragging correctly
- Modified export naming of created indexes when specifying a schema
- 1.4b20
- Fix for escaping of quotes for table comments in MySQL
- Fix for WITH TIME ZONE in Postgres for TIME and TIMESTAMP
- Modified postgres types list to consolidate the TIME and TIMESTAMP options together
- (This shouldn't affect existing tables)
- Fix for BINARY type import from file
- Fix for a possible bug in index handling
- Fix for a bug in Clipboard Cut operations
- Modifications to improve compatibility with Microsoft SQL Server Import
- Added new index prefix size option for certain types (MySQL)
- Fixed an odd bug that affected files that were re-opened having incorrect uids under some conditions
- Increased starting size of Comment object
- Context (popup) menu on Comment Views now works better
- Added first version of MS SQLServer Support
- Improvements to database export for Oracle, Postgres and MySQL
- Better updating of existing databases when exporting to database
- Improved JDBC preset handling
- Importing a document now sets the document dialect to match the original database
- Better handling of the Keychain
- SQLEditor is now correctly security signed as an application
- Minor SQL parser improvements
- 1.4b19
- Fix for a crashing bug in inspector
- Several improvements for dragging, scrolling and resizing of objects
- Fix for enum and set values being forced to uppercase
- Fix for bug in Find Object
- Fix for a bug that prevented export if a table had the same name as a canvas object
- Added back the button to convert comments -> Canvas Areas (and reverse too)
- Fix for a bug where comments weren't loading colors correctly
- A few internal optimizations
- Parser now imports mysql KEYs (as Indexes currently)
- Fix for repeated JDBC Export of tables with foreign keys to MySQL which was failing
- Ruby on Rails table names are now forced to start with a capital letter for better compatibility
- Fix for a log window resizing bug
- 1.4b18
- Fix for source sidebar
- SQLEditor now allows JDBC drivers to be stored in "/Library/Application Support/SQLEditor/JDBC Drivers" (as an alternative location)
- New warning icon for possibly unsuitable default values
- Fix for Ruby on Rails Plugin issues
- Fixes and improvements for SQL Parsing (decimals in unquoted default values, fulltext with optional index and table level unique keys)
- More "ON DELETE" action types for connectors
- Modified MySQL unique keys when importing from database
- New constraint object (initially for unique keys)
- Fixes for indices when exporting (better SQL)
- Fixes for some database export bugs (indices again)
- Modified field appearance to better distinguish name from type
- Fix for Add Driver menu item not working in Import & Export from database windows
- Fix for an import bug where types would appear in lowercase then switch to uppercase
- Fix for a problem that caused the source sidebar to be empty
- 1.4b17
- internal release only
- 1.4b16
- Fix for autocomplete bug in field types
- Auto adding field types as they are entered is now optional (see Preferences->Data Types)
- Fix for occasional bug in displaying status messages when running on PowerPC
- 1.4b15
- Fix for oracle connection type string missing
- Changes to prevent adding an empty custom database driver
- Data type lists for Oracle, Postgres, Rails, Sybase and OpenBase now included. (Reset Dialects to use)
- Fix for a bug where type sizes imported from a MySQL database could be wrong for some types
- Fix for a bug where MySQL table types weren't being imported correctly.
- New hand drag scroll tool (via optional document toolbar palette item)
- New modifier when scroll wheel zoom: hold down command to switch to normal scrolling mode
- 1.4b14
- Added default setting preference for automatic table sizing.
- Better export image cropping
- Modified image export to add a small border around the image
- Modified Canvas Areas to randomly select initial color
- Canvas Area objects can now be added from the popup menu.
- Changed zoom shortcut to display Command (PLUS) instead of Command (EQUALS),
this makes no change in functionality since both work equally - Better Rails Class naming
- New Rename underscores for table names option for rails export
- FIX: First field added to a document sometimes had incorrect type.
- FIX: for comment inspector selection bug
- 1.4b12
- FIX: startup failure on 10.4
- 1.4b11
- Added per document option to hide field types
- 1.4b10
- FIX: for a bug that caused objects to resize when dragged if the document was scaled
- FIX: for a crash bug related to the table inspector
- FIX: for a selection bug when copying objects with option drag
- FIX: for incorrect visibility of export plugin menu
- 1.4b9
- Better support for new Ruby On Rails 2.0 migrations
- New Canvas object to replace old style canvas area comments
- Minor SQL parser changes
- Fixed the button style in the SQLite import panel
- Fixed a packaging error where the disk image was unmountable on Mac OS X 10.3.9
- 1.4b8
- Ruby On Rails Import from migration added
- Better Ruby On Rails type conversion
- New option to align field type labels in a vertical column per table for better readability
- New "New with Dialect" to allow choosing the document dialect when creating a document
- Improved preferences window, visual and organizational improvements
- FIX: Inline rename wasn't updating correctly
- FIX: Parse status window time was wrong
- FIX: Source view updates weren't happening
- FIX: Correct printing system is chosen automatically
- FIX: SQLite auto-increment
- CHANGE: "Export to SQL" is now "Export to File"
- Other minor changes
- (Also the first public build built with 10.5 and XCode 3.0. Please report any problems)
- 1.4b7
- Improved visual appearance - rounded corner tables, with colored table headers (optional)
- Labels and colors on fields as well as tables
- Can now duplicate fields as well as tables
- FIX: Inspector now updates if you make changes using a popup menu
- FIX: Ruby on Rails auto increment output incorrect
- FIX: Fields could not be dragged between tables
- FIX: Modified type matching to ignore sizes when matching postgres SERIAL types
- FIX: Minor improvements and fixes for printing (page numbers particularly)
- FIX: Fix for some inspector issues that appeared in 1.4b6
- 1.4b6
- Changed toolbar icons to look better with Mac OS X 10.5 Leopard
- FIX: for Ruby On Rails join tables
- FIX: for side bar visibility
- Passwords for connections are now stored in the keychain
- 1.4b5
- Fix for JDBC Driver list sometimes being empty
- Fix for a bug relating to updating the source sidebar when closing a window.
- 1.4b4
- Modified Inspect Object to display the inspector if it is not already visible
- Fix for a bug that sometimes caused the application to crash if a source update occurred after the window had closed.
- 1.4b3
- Fix for undo on index fields
- Minor fix to registration window user interface
- 1.4b2
- Fix for a bug that caused connectors to be incorrectly deleted
- Fix for undo/redo bug
- Improved update checking (now using Sparkle)
- New beta warning message (shown once only per version release)
- Fix for live source view sometimes being blank
- Fix for live source view not changing when document export dialect changed
- Fix for a bug that sometimes caused undo to stop working.
- 1.4b1
- New live source view sidebar
- Improved search (now searches for fields as well)
- Image export file type now selectable
- Some SQL export fixes
- Fix for a bug that was sometimes preventing fields being added under odd conditions
- Fix for drop order with referenced tables
- Fix for a file corruption error
- Improved status window (it now indents!)
- Fixes for minor bugs in registration window
- New Show Inspector toolbar item
- Better database driver listing delete handling in preferences window
- Added option to De-Register Software (if selling a machine for instance)
- Improved undo/redo when repeatedly undoing and redoing (particularly delete)
- Fixed save/revert menus not becoming inactive
- Other minor fixes
- 1.3.9
- Fix for a crash that sometimes happened when importing or exporting
- Performance fix for selecting objects in large documents
- Parse status window: Large messages are now displayed completely and not cropped
- Better handling of java 1.5 drivers when running using java 1.4
- 1.3.8
- Fix for a save bug that caused tables not to get saved correctly under certain conditions
- 1.3.7
- Tables and indexes can now correctly have the same name
- Improved Openbase support
- Parsing of collate settings on tables is better (allows equal character between option name and option value)
- Some internal re-optimizations
- Small bug fixes
- 1.3.6
- Fix for mysql auto increment not being read correctly when using jdbc database import
- further fixes for database connection issues.
- 1.3.5
- Fix for a bug that prevented Database connection windows from opening if there were no preset connections.
- 1.3.4
- Loading foreign key links now works more reliably (SQLEditor was getting confused if uid values weren't correct)
- Types are now sorted within each dialect
- Parser is now better able to understand check constraints (although editing and exporting aren't available yet)
- Database import window now appears even if there are no drivers present (previously didn't appear)
- Hand icon appears when cursor is over field drag area
- Bug fix for an odd crash when drawing
- First ssl support (for postgres only at the moment) in import and export
- Improvements to Postgres JDBC support with JDBC drivers >= 8.0
- 1.3.3
- Internal release only
- 1.3.2
- Added new per dialect column type system and a new option to select a default type (see preferences - data types)
- Choosing no-preset in database connect now clears the import/export window
- Default type list for mysql now includes most (possibly all) mysql data types - please advise if there missing items
- Fix for a bug that caused altering tables in a mysql to reset some attributes on columns
- Parser recognizes (but doesn't actually do anything with) collate and character set options
- 1.3.1
- Fix for a bug which meant that UIDs for objects weren't recreated when an object was copied,
causing connectors not to be saved correctly under certain conditions. - Images are now saved using filename.type, rather than filename-image.type
- Show/Hide inspector menu item shortcut wasn't working - fixed
- Fix for a bug which meant that UIDs for objects weren't recreated when an object was copied,
- 1.3
- Functional identical to 1.3b10
- Release Version - will not expire
- 1.3b10
- Fix for index importing sometimes duplicating fields
- Fix for a bug which caused some parts of database presets not to be saved under some circumstances
- Fix for indexes sometimes wrapping to a new line when printing
- Altered display code on indexes when the table width is too short
- Fixes for a few internal bugs that shouldn't normally appear during use
- Fix for a bug that caused connections between fields to be lost when using a file created in a version before 1.3b9 AND where the tables were schemas
- Added a new and more reliable way of SQLEditor storing links between fields (using unique id numbers). Fully backwards compatible, files now contain both old and new style links with new style links used if available.
- 1.3b9
- Fix for progress bars sometimes not disappearing
- Fix for some display preferences (including snap to grid) not being saved
- Added default settings for display preferences
- Fix for bug with indexes where index type combo was not always set correctly
- Added new keyboard short cuts for many file related actions (including import and export)
- Fix for a MySQL export bug that would add additional indices when export foreign key relations
- Fix for a bug that affected adding a JDBC driver from the JDBC Import or JDBC Export window
- Better support for importing full text indices in mysql
- Handles tables with schemas better (including Find panel)
- Now detects if a database can support add / drop tables and displays an error if necessary
- Fix for user interface when importing (didn't show progress bar correctly)
- Fixes for some internal bugs (mainly edge cases that weren't handled correctly)
- Saving very large files would sometimes cause out of memory errors. Fixed
- 1.3b7
- Added logging for SQL Export
- Index names are now prefixed with table name when exported to be more unique
- Object comments are now exported in SQL as comments
- Bug in ordering of default and not null in Oracle and Postgres fixed
- Window zoom menu now appears on mouse down not mouse up
- Bug which deleted foreign keys when duplicating table fixed
- Minor bug fixes
- 1.3b6
- Fix for a bug that removed foreign keys when duplicating a table
- Application bundle information was wrong in finder windows - fixed
- 1.3b5
- Copy and Paste for single fields in the main canvas should now work
- Drawing a connector will now scroll the view if necessary so objects can be linked more easily
- Improved suggestion system a bit
- Fixed a bug that caused object handles to stick when resizing
- Postgres - auto increment to serial mapping now working again
- Registration and certain startup information windows now appear less often (Only once a day)
- 1.3b4
- Export operations can now be canceled
- Fix for adding types in preferences window
- Fix for schema name missing on export
- Fix for artifacts appearing when dragging
- Hide/show objects causes resize when auto size tables option set
- Fix for connectors highlighting after document load
- Minor bug fixes
- 1.3b3
- Export to image now supports JPEG and PNG formats
- Export to JDBC is now interruptible
- Find object is now case insensitive
- Fix for a bug involving undo and redo with foreign keys
- Export to SQL and Save As Image are now sheets (not dialog boxes)
- Improvements when importing from MySQL Isam tables
- Export now correctly includes schema name (if set)
- Fix to a bug that caused objects to resize in a weird way
- Internal improvements
- 1.3b2
- Improvement in group selection speed
- First version of SQLite export dialect
- 1.3b1
- Rails improvements
- Added option to remove the SQLEditor exporter header in exported SQL
- Major Version number increased (1.2->1.3b1)
- 1.2.4b4
- Added rails export type replacement
- Added rails export file name correction
- Modified camel case converter (rails)
- 1.2.4b3
- Added multi-column unique index support for tables
- Improved some parts of import export
- Added default SQL Dialect setting for new documents
- Rearranged preferences panel
- File export popup now changes file extension to match export type (mainly for rails)
- File extension can now be shown or hidden in export dialog
- Option Dragging tables to another application using option now respects export setting
- Rails export now uses rb extension
- Rails Export identifiers now auto convert to Camel case if quote identifiers is off
- Other rails improvements
- Rails id columns are now automatically removed from exported data (but not from the sqs file)
- 1.2.4b1
- Ruby on rails exporter added (experimental)
- Limited release only
- 1.2.3
- Fix for file reading error with certain types of corrupt files [FS#376,FS#374]
- Fix for inline field rename bug [FS#375]
- Fix for version check bug involving beta versions [FS#378]
- 1.2.2
- Fix for Postgres export [FS#373]
- Fix for incorrect quoting
- Fix for incorrect sizes
- Fixes for incorrect handling of default values
- 1.2.1
- Fix for a bug with moving connector handles
- Fix for Oracle named schema bug
- Fix for Postgres JDBC connect string bug
- Fix for Postgres quoting bug
- Fixes for Postgres JDBC bug
- Fix for a postgres unique key export bug
- Added option for schema name on tables (only Oracle exporter supports this)
- Added option to disable all quoting of tables in export (advanced users only)
- 1.2
- Released 24/04/2006
- 1.2b6
- Internal - not released
- Added option to prevent quoting of default column/field values with a checkbox
- Improvements to online help and the manual
- 1.2b5
- Released 31/03/2006 - Expires 30/04/2006
- Fix for comment inspector text coloring errors [FS#340]
- Log files weren't being attached to suggestions - fixed [FS#361]
- Added export support for timestamp with timezone option box [FS#267]
- Added support for hiding of field icons on columns [FS#255]
- Fixed quoting character appearing when importing from SQL [FS#362,FS#365]
- Import complete message was appearing twice - fixed [FS#364]
- 1.2b4
- Fix for a window resize bug [FS#359]
- Fix for a canvas sizing bug when reopening large schemas [FS#360]
- 1.2b3
- Fix for a MySQL export bug [FS#357]
- Fix for non-quoting of names in export [FS#341]
- 1.2b2
- Parsing improvements
- JDBC Import and export improvements
- New zoom controls on each window
- Fixes for Oracle JDBC and SQL dialect errors
- better support for Oracle indexes
- Minor fixes
- Option to zoom using Mouse wheel
- 1.2b1
- Parsing improvements: better index import, first support for constraints
- Fix for a bug involving undo handling and connectors
- Better index support (at table level), now also handles multi-column indexes
- type matching is now case insensitive
- added the expiry date for the beta to the about box
- renumbered to 1.2 from 1,1
- 1.1.4b6
- Fix for a bug that caused files not to load if the comment namespace overlapped with the table namespace
- 1.1.4b5
- Minor internal refactoring of label handling
- 1.1.4b4
- SQL Parser improvements
- Added support (initial for timezone option on timestamps)
- Preference to change grid size (global)
- Removed plugin and export menus (unless plugins are installed)
- First version of import table selection - note that this may cause export errors
- Minor fix to table layering
- JDBC export can now alter mysql table types (e.g from INNODB to MyISAM
- Fix for index export bug
- Fix for bug that prevented undo on connector delete
- connectors are now deleted using the delete key (or via the target field)
- Fix for improved error recovery on JDBC import errors
- 1.1.4b3
- Fix to improve import from SQL of foreign keys
- Fix for a minor bug in SQLParser that produced incorrect error messages
- Fix for a bug that caused extra commas to be inserted into exported SQL files.
- 1.1.4b2
- Fixes for saving, importing and pasting in intel release
- Improvements to SQL export via JDBC
- Fix for an exception that wasn't being caught when importing
- 1.1.4b1
- First release with intel architecture support
- 1.1.3
- Fix for problem that caused lines to be missing on print outs
- Added support for importing column sizes and enums via jdbc
- Fix for context menu sometimes being disabled
- Fix for bug when resizing an object that is part of a selection
- Fix for an obscure foreign key export problem
- Changed quoting of tables and columns in mysql
- Added a preference for using GO when exporting to sybase
- Fix for duplicate index creation bug in mysql
- Fix for beta expiry date being wrong (although not visible in release version)
- Rewritten update checking code - now checks for updates in a separate background thread
- SQLEditor now saves window size and position in each document
- New option to not open a new window at startup
- 1.1.2
- Internal release only
- 1.1.1
- Fix to a bug that prevents moving the control handle on connectors [FS#290]
- 1.1
- Non beta version - this version won't expire if you have a serial code
- Improved handling of large tables when scrolling and dragging [FS#184,FS#287]
(scrollview doesn't move in the wrong direction anymore) - Improved printing support on 10.4, page header doesn't overlap objects now [FS#124]
- Option added to disable checking for beta versions [FS#286]
- Page grid added on a per document basis [FS#119]
- snap to grid added [FS#264]
- Added new Oracle dialect for export (still being worked on) [FS#260]
- switched to IF EXISTS in mysql exporter [FS#283]
- Improved update checking [FS#243]
- fixes for some SQL import bugs including timestamp fields with on update arguments, some kinds of comments and table names that start with symbols such as the underscore.[FS#274,FS#265,FS#270]
- other minor fixes
- reverted to b6 behavior on quotation marks for default values. 1.1.0b7 tried to automatically add and remove these, but failed. Functionality has been removed, although it may return as an option in a future version
- 1.1b7
- Added auto detection of JDBC Drivers
- Fix to SQL import to fix a problem that prevented comments followed by semi-colons from being imported
- Fix for importing enums with NULL option
- Fix for the add driver menu in the import and export windows not working
- Improvements for Export to database
- New preference for foreign key type checking
- Fix to drawing of cardinality lines where these were sometimes chopped off.
- Made field (column) types case insensitive (and forces them to uppercase)
- Minor fixes to a number of other areas
- 1.1b6
- Basic index support added, multi-column indexes aren't supported yet though
- Fix for an odd export bug that caused fields to appear in the exported sql without an enclosing table
- Improved version checking code (now checks for beta versions as well)
- Fix for a crash that sometimes occurred when setting document options
- new printing code (option in preferences) that allows better headers, time and date and file name indications
- Fix for a bug with annotations that caused the annotation to appear for all objects and with null values
- 1.1b5
- Fixed a bug that was preventing export to database from working. (Please read the readme file for information about database export)
- user settable tooltip 'notes' on tables and fields
- New guidance and warning icon (red U) on unique keys for foreign key relationships
- re-written sizing and icon drawing for field icons, should be more efficient.
- Comment autosizing
- better handling of compound primary and foreign keys
- The cancel button in the add label panel now works (not that it really does anything the close box doesn't do though)
- Fix for some bugs that could cause a crash when you have a circular foreign key relationship i.e. if you have three tables: a, b c. a.id -> b.id -> c.id -> a.id. That worked before, but more complicated relationships crashed. Now appears to be fixed.
- changed the way that the warning icons appear in the inspector
- 1.1b4
- Fix for scrolling jitter with very tall or wide objects
- Added a way of changing the drag handle size from the preferences window
- Added Help->Registration to allow registration from the help menu
- Modified the welcome window to be clearer
- 1.1b3
- Added a new find object panel
- Drop object on export added (File->Document Options)
- Per document sql export dialects now saved (File->Document Options)
- Improved selection, copy and paste so it fits in with other applications better. It now selects the new object after pasting or dragging, rather than leaving the selection on the old object
- Default value quoting. Changed to give permanent quoting
- Icon highlighting. Fixed : Fixed as far as testing can tell
- A suggestions window - directly accessible from the application. Creates an email in mail.app with the correct address
- Microsoft SQLServer is now believed to be working
- Added a collection of new checkboxes to the field inspector
- Bug in inspector undo. Fixed
- Changed the architecture of the inspector panel so that inspectors are registered dynamically (Should support plugin inspectors, except that the API isn't public yet)
- Using copy/paste export now correctly reflects the current document dialect
- Changed the Database preference window "Open Directory" button to work more reliably.
- Drag to copy on the canvas or between documents by using drag+option.
- 1.1b2
- Fixes for a serious bug in the load/save system that was causing some characters to be lost under some rather odd circumstances
- Fix for a bug that was introduced in 1.1b1 that caused a crash if a circular relationship was created.
- Midpoints for orthogonal lines are now saved when they are changed. (There is a preference to disable this)
- Connector drawing system has been re-arranged which will provide extra features in the future.
- Fixes for some minor parser bugs
- JDBC Export improvements
- The about box now shows what type of license is in use, in addition to the existing information
- Fix to a bug that caused some objects that were dragged from the palette to be incorrectly positioned
- 1.1b1
- JDBC Export functionality.
- This is still being worked on, but it supports exporting tables to a JDBC database, adding and dropping, plus adding and dropping fields. Modifying fields is still to come
- Save JDBC connect details between launches. Implemented
- Specify field size instead of using custom field types. Implemented
- Objects can have size 0, causing them not to display. Fixed
- allow setting colors on objects. Implemented
- Store state of palette and inspector. Implemented
- Bug with enums, spaces and import from file. Fixed: Fixed
- allow drag/drop between windows. Implemented
- Color code/highlight primary keys.. Implemented
- Foreign key type checking. Implemented
- A window toolbar. Implemented
- Duplicate Objects. Implemented
- Field gap at bottom of table. Fixed
- Drag handle size. Implemented
- Table name positioning. Implemented
- Field spacing too big. Fixed
- Oracle JDBC Connectivity. Fixed
- Duplicate object command. Implemented
- Draw Border Checkbox state. Fixed
- Freeze in update checking if server is down. Fixed
- Object layering is not saved. Fixed
- Default file names for exporting. Implemented
- JDBC Export functionality.
- 1.0.5
- Fix to a layering bug that prevented canvas areas from being layered behind other objects.
- Improved behavior with version checking if the update server is unreachable
- Initial support for some minor parsing improvements when using INSERT
- Minor optimizations
- 1.0.4
- Fix to a bug that was created during the fix to the foreign key export bug
- Fixes to some other minor issues
- 1.0.3 was incorrectly built using an experimental SQL parser. This has been removed and replaced with the production parser
- 1.0.3
- Fix to a bug that caused a crash when using the popup menu to delete a field from a table
- Fix to a bug that caused foreign keys to be exported incorrectly if the target field had been renamed
- Improved preferences handling in some cases
- Improved registration handling in some cases
- Slightly changed the arrangement of menus
- 1.0.2
- Added capability to move connectors horizontally when in orthogonal mode
- Improved oracle support
- Fixed a bug where page numbers, headers and footers were not being displayed correctly
- Improved automatic update checking in various ways
- 1.0.1
- Added a field to select a schema within a database from JDBC import
- Fixed a memory leak in the JDBC import system that was causing out of memory errors
- Minor optimizations
- 1.0
- Changed keyboard shortcut for next/previous object to (command+Arrow Up), (Command+Arrow Down)
- Improved Help
- Minor changes to graphics
- 1.0FC2
- Altered the keyboard handling. Now next object (command+[) and previous object (command+]) functions added and inspect object command removed as redundant
- 1.0FC1
- Better keyboard support, you can use tab and shift*tab to move back and forward between fields and objects. Cursor keys to move objects (hold down shift for faster movement) and the t key to select types on fields from a menu
- A number of internal improvements to improve speed and performance
- Undo support has been improved in a number of ways and should be faster
- Drag handles now appear on all sides of selected objects and disappear from deselected objects
- Comments can now have selectable colors and can be set as a backdrop to other objects. HINT: use these objects to section the canvas into logical groups
- Objects can be locked in position
- Fit to window added
- Fixed a bug where objects could appear outside the visible area
- Changed the way that some lines are drawn to improve appearance
- fixed a bug where the inspector wasn't updated correctly when objects where created
- Altered Database import to better handle errors during import
- Rewrote connector selection so it works better
- Add a bring current to front option (command+1) to switch the focus back to the document window if the inspector is the focused window
- Some minor bug fixes to other areas
- 1.0b12
- Inline editing - double click to edit the names of objects. (click on areas that aren't text to get previous behavior
- Context (popup) menus on most objects
- Better support for different database connection strings
- Better support for unicode characters in saved files
- Altered dragging of fields. Fields now have a drag handle instead of having to hold down control to drag. Drag handles will not show on print outs or saved images.
- Slightly altered drag and drop for fields
- Fixed some parser bugs including IDENTITY support
- Bug fix in types preference panel
- Slightly altered drawing of cardinality symbols to improve appearance
- Fixes for positioning of self-referential foreign keys in vertical display mode
- Removed the circle from foreign keys (just click on the line instead)
- SQL files now double clickable. You should now be able to double click exported SQL files and they will be automatically imported and loaded
- You can now import structures from files with extensions:txt,text,SQL. Also files without extensions can also be imported
- Minor improvements to exported SQL
- 1.0b11a
- This is a bug fix release that fixes a problem that can cause crashes when printing if no print header is set for a document
- There are no other changes
- 1.0b11
- Drag and drop for fields now works correctly
- Improved mysql export. Now automatically creates required indexes for foreign keys (mainly useful for earlier versions of mysql that don't automatically create these).
- Improved automatic object naming algorithm, now uses underscore instead of hyphen so that the resulting objects will actually work in real databases.
- Threaded import. When importing an existing structure from a file or a database the main part of the import is now threaded. This means that you can continue to edit other documents while an import is going on and the application will remain responsive. This may also speed up imports on multi-processor machines.
- Auto size table option added. When set, tables will automatically be resized to account for changes (View->Auto Size Tables)
- Types list now automatically adds and saves types that are used if they haven't been added before. This means that you shouldn't normally need to use the preferences screen at all to add types. Just start using them instead
- New vertical connector style. This will connect tables at the top and bottom as well as the sides, but is otherwise identical to the diagonal style
- Print style (fit to page, tile or crop) is now saved
- Undo after arrange objects now works (although redoing it doesn't yet)
- Better constraint when dragging groups of objects. They no longer go off the top left of the canvas
- Connector improvements, easier selection (just click) and easier deleting (select and hit delete). Still can't move the connectors, that's coming in the next release (hopefully)
- Improved sybase export a bit (Please continue to send in bug reports)
- Document Information panel, sets printing headers and footers for a document.
- Page numbers on print outs
- Made field borders optional after a request. (Drawn by default)
- Minor performance improvements in importing, object movement and object arrangement
- Minor bug fixes in various things including the parser and inspectors
- 1.0b10
- Improved JDBC database import. Importing databases via the JDBC system is now more efficient. SQLEditor now imports the database structure by directly reading it from the JDBC driver as opposed to creating sql and then importing the sql. This is both faster and more reliable. It should also eliminate all of the "SQL error on line 71" style error reports
- Export dialect support. It is somewhat simplistic at the moment, but the capability for SQL dialects is now supported. Dialects initially supplied are:
- Dialects:
- Generic - Standard ANSI SQL (or close to it)
- MySQL - MySQL dialect
- Postgres - Postgres dialect
- Sybase - Sybase Dialect - experimental
- The mysql dialect is probably closest to the format that was previously exported. Documents should remember the export dialect that you select.
- Note that generic will be used when copying and pasting. An option may be added later to select this. Be cautious about expecting to be able to perfectly re-import files exported, certain dialects (now and in the future) may not work perfectly.
- Dialects:
- Connector selection. A new widget (circle) is now shown on foreign key connectors. If you click on the widget you can edit the connector or delete it.
- Table names are now bold
- Double click header to resize tables added
- Pasting has been changed so that the objects pasted now appear in a slightly more useful location
- Option dragging the canvas now scrolls the canvas
- Bug fixes in the parser, editing system and some other areas
- 1.0b9
- Significant printing improvements, new features include tiling that actually works, printing to the whole page (maximum imageable area), lines on the canvas to show where the page boundaries are
- Page setup information is now saved with each document
- Saved file format slightly tweaked (strings are now PCDATA). This adds robustness and prevents problems if you use bits of XML in comments or object values. This does not affect importing data into older versions and files will be automatically updated to take advantage of this as they are loaded into the program.
- Fixed a bug which prevented a document from being loaded if it had an empty title
- Added a work around for a problem that occurred with primary keys when importing via JDBC using mysql drivers
- Improved the scaling system a bit more. Documents now remember scale settings
- Minor UI fixes for odd problems
- Changed the canvas so it now increases in size as necessary to accommodate all the objects. This also happens when you drag objects over the edges of the current canvas
- Changed comments so that they can now be used without the scrolling text area, just reduce the vertical size until only the title bar is visible, then use the title bar for the comment. Comments will be improved in a later release
- Fixed a very specific problem that occurred when importing data from scripts exported from MySQL that used SET FOREIGN_KEY_LINKS
- File saving is now handled more intelligently
- 1.0b8
- Import from database - use any JDBC driver and drop it into /Library/Java/Extensions
- Improved inspector speed, the bug supposedly fixed in b7 now actually is fixed
- Improved selection, dragging and editing including improved multiple selection
- Fixed the foreign key bug that meant that some exports wouldn't work with real databases. Foreign keys are now added to the tables after they have all been created. This might get to be a preference in a future version.
- Type saving might have been failing in b7 under some situations, this should now be fixed
- SQLEditor is now more aggressive in prevents duplicate tables and fields. You probably will not be able to create duplicates. SQLEditor will automatically rename them
- Fixed some other bugs as they occurred
- Free zooming is now available, see the view menu
- Arrange object option to move the objects visible into a kind of square.
- Diagonal connector as the default, the old orthogonal connectors are now an option * in response to a suggestion
- Improved undo support (which was actually in beta 7, but didn't get a mention)
- 1.0b7
- Connectors can now show cardinality
- A bug that prevents fields from being dragged from the palette has been fixed
- Rewrote parts of the inspector to speed things up a bit when selecting fields
- A bug that caused connectors to be badly drawn in some cases has been fixed
- Added serial number and personalization support
- Minor Bug Fixes
- 1.0b6
- Fields can now be dragged from one table to another.
- The list of data types can now be edited and changed
- Improved preferences options
- Better printing, including scaling, tiling and fit to page.
- New buttons to add a sibling field to a table or delete the currently inspected one
- C-shaped connectors are back. (This is where a connector loops back on itself if it would otherwise overlap either the source or destination field)
- You can now change the colors of objects. This is a global setting at the moment. Individual color changing is coming soon
- A few minor bug fixes
- Slightly altered the appearance of the table object view
- First version of online help. As yet incomplete.
- 1.0b5 - Second Public Beta of Cocoa Version
- Much better parsing. The parser now shows errors and reports status
- Some work on coloring of fields to indicate relationships (experimental)
- Automated internet version checking (you can turn it off via a preference)
- Speed improvements
- Bug Fixes
- 1.0b4 - First Public Beta of Cocoa Version
- First public cocoa beta version
- Cocoa user interface
- Improvements to core functionality for better stability