SQLEditor

by Malcolmhardie for Mac OS X

Download Now

Downloaded: 5K

Visual database design

Find objects now searches for the string anywhere in the object name (not just at the beginning)Fix for bug where JDBC table filters were being used when exporting (FS#894)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)Fix for bug where db connection strings not updating when preset changed [FS#890]Fix for alter table engine export bugFix for crash when typing accented characters or symbols into table name fieldRuby on Rails now generates “references” statement in migration exportRuby on Rails importer now imports some types of references statements

Changes

  • Find objects now searches for the string anywhere in the object name (not just at the beginning)Fix for bug where JDBC table filters were being used when exporting (FS#894)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)Fix for bug where db connection strings not updating when preset changed [FS#890]Fix for alter table engine export bugFix for crash when typing accented characters or symbols into table name fieldRuby on Rails now generates “references” statement in migration exportRuby on Rails importer now imports some types of references statements

SQLEditor is a tool that allows you to create basic SQL databases graphically. You can create the tables and fields using a drag and drop approach, then edit and export the database as an SQL file or as an Entity relationship diagram.

Key Features:

  • Visual editing, including drag and drop
  • With SQLEditor’s reverse enginering facility you can import existing databases to diagram and SQLEditor will create a diagram for you.
  • Once you’ve created your diagram you can export it directly via JDBC to one of several supported database systems including Postgresql and MySQL.
  • You can save your database to an SQL instruction (DDL) file for immediate use on remote servers or with other tools.
  • Import existing DDL files directly into SQLEditor
  • Copy and paste to import and export supported SQL to and from SQLEditor
  • You can print out designs so that you can see your database up on the wall(1). SQLEditor also supports PDF output for easy sharing.