Migrator

Java application for generating database migration files

Application that generate migration files for file based database migrations like Phinx or Flyway. This application provides GUI and handles creating migration files for different languages.

Migrations are used to change database structure when application evolves and you need to share this change with multiple servers or dvelopers.

Installation

Download the latest release

Then run this command

java -jar migrator.jar

Usage example

One project has one database connection. Project also has migration output type. Currently, only supported output type is phinx, but phinx is used in variaty of PHP frameworks (cakephp, laravel).

Creating project

To create a project click on the + button and fill the form on the left. Some fields are prefilled with default values.

If your application has multiple databases you have to create multiple plojects

Creating table

Select project by clicking on open button of a project card. If your database contains tables, they will be shown in this list.

1. To create a new table click on + button in the upper right corner.
2. Select a name for your new table
3. add columns by clicking on + button in columns list
4. add indexes by clicking on + button in indexes list

index can have only 3 columns, it's a reasonable amount for most cases.

Generating migration

Select project by clicking on open button of a project card.

1. Click on ✔️ button in the upper right corner
2. Name this migration. This name will be used to generate migration file name.
3. Click on the commit button

Release History

• 0.5.2

  • Features
    • Save windows settings. If you close application in full screen, it will open next time in full screen mode.
  • Bugfix
    • Selecting columns and indexes in table. When you create new column (or index) by clicking on "+" button, it will show edit formu and select this new column (or index) in table.

• 0.5.1

  • Features
    • Performance optimalization - database connection resource management

• 0.5.0

  • Features
    • Securely store database passwords by encrpting it
    • Remember last commit message
    • Performance optimalization - less events fired when updating data from real database.
    • Performance optimalization - gui is not regenerated all the time. It's created once and then updated.
    • When creating new table, added CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP for modified_at columns
    • Toast visual redesign
  • Bugfixes
    • Refresh columns and indexes when viewing tables. It will refresh internal table changes without needing to open table detail.

• 0.4.3

  • Features
    • Added automatic tests for library classes
    • Add primary key automaticaly and remove primary_index index when creating new table
  • Bugfixes
    • Flyway migraion file versioning changed according to standard
    • Flyway migration ignored default values in columns. Fixed.
    • Empty table name throwed mysql exception. Added condition to check for empty table names.

• 0.4.2

  • Bugfixes
    • Refresh created columns and indexes after running migration
    • Refresh columns and indexes list after opening same table multiple times

• 0.4.1

  • Features
    • Phinx migration will warn you if you try to save migration with the same name
    • Add bigint mysql format compatibility.
  • Bugfixes
    • New table is created with primary_index instead of primary. Index named primary was difficult to work with during running migrations.
    • Default value for column is not always '' but is null by default.
    • Create table phinx command disables id. You have to specify id when creating migration.
    • Tables with status created (green) where visible after running migrations and application show duplicates. Not anymore.
    • Phinx drop table generates command in ->table()->drop()->save() instead of ->dropTable()

• 0.4.0

  • Features
    • Added Flyway support (with tests)
    • Loading cursor indicator and buton diable for longer actions (opening project)
    • Replace images in buttons with + sign
  • Bugfixes
    • Fixed columns not changing names in index whene column name is changed in column form
    • Sentry logs errors in correct enviroment
    • clicking x in searhc clears and closes search

• 0.3.1

  • Features
    • Added logging for database driver errors
    • Permanent toasts
  • Bugfixes
    • Agter changing database connection data, you don't have to restart application to be able to conenct to database. Data for connection are changed in real time.
    • If something bad happens, you can see entire error messages
    • Close buttons have images instead of x character
    • Application sends error reports to correct environment

• 0.3.0

  • Features
    • added support for MariaDB
    • added support for PostgreSQL
    • new table contains default columns (id, created_at, modified_at) and default index (primary)
    • rounded corners for cards, buttons and form elements
    • added auto increment column attribute
  • Bugfixes
    • deselecting indexes table row after selecting column
    • deselecting columns table row after selecting index
    • added tooltips for create project, create table, create column and create index buttons

• 0.2.2

  • deploy .jar for all platforms

• 0.2.1

  • Bugfixes
    • fix generating migration files. Changes were not selectet properly, we were still selecting changes by project name, but we changed it to selecting changes by project id.

• 0.2.0

  • Features
    • you can search in tables by presing CTRL+F
    • added support for hotkeys

• 0.1.2

  • Features
    • added icon

• 0.1.1

  • Bugfixes
    • fixed loading column types
    • setting signed / unsigned value from database
    • setting presicion for decimal from db

• 0.1.0

  • First Woking version
    • support for phinx migrations
    • support for mysql database

Meta

Peter Gasparik – gasparik.pe@gmail.com

Distributed under the MIT license. See LICENSE for more information.

Contributing

Have you found a bug?

Do you wan to share your ideas how to improve this application?

Are you looking for some little thing to code?

Look at the contribution manual

TODO

• add analytics
• allow changing column order
• add tests
• add support for frameworks:
  • evolve (.NET)
  • fluent (.NET)
  • db-migrate (nodejs)
• allow data seeding
• set database connection info from project (phinx config, ...)
• running migrations
• check if there are any not migarted files in project