REVIEW: Database Creator is here!

The settings are auto saved. Just try refreshing your database schema - use the refresh icon on the toolbar

Do you think you could squeeze in an option to create a migration zero file for live databases? Or is it too much trouble for the amount of people that could use it? I have my own doubts tbh regarding how useful it could be to people.

Edit: checking knex features I can see already it’s too much trouble.

Also, what considerations should we take if we want to add manually a migration. From the file name and the contents of the tables I’m assuming the field name has to match the filename.

What about id, batch and migration_time? What special considerations should we take for the order?

I thought about that but couldn’t find the most logical solution.

Do you mean just a full dump of the current database scheme as a change file so it can be fully recreated? Not sure about the usefulness and workflow - so ideas are welcome.

As for the current changes - those are store as migration files and have exact creation time stamp and are executed in the exact order.

They are also shown in the tree in the right order ( maybe we should reverse it so the latest come on top?)

The time stamp is visible on hover above the change.

Latest on top feels more intuitive.

Regarding the migration zero file I can’t think of anything neither. I mean the difference between a specific knex migration for that an a mysql structure dump doesn’t seem the worth. It would have been nice to have all in knex files but as said…it isn’t worth the work.

For some reason when I enter the details for user direct connection it does not save, when I click the Apply changes it says nothing to do and when I click the refresh it just removes all the info in user direct connection.
Am I doing something wrong here??

I have also tried adding an FTP account with the same user and password and still shows unable to connect :frowning:

This is on a fresh install by the way on Mac

Would it make sense to dump automatically the db schema after each migration file is created and store it with them?

If you put your app and migration files under source control and revert to an old commit the migration files won’t be enough to leave your database as it was on that old commit.

One way to do it without the schema dump is by removing the migrations from source control, but that creates a problem for teams. Another option is to resolve conflicts for the migration files under source control but that is not a simple matter.

I know there is a lot of discussion about this topic and no best way to handle it.

Amazing work guys… :slight_smile:

I have no idea why but opening up the Database manager it says I have 3 databases exactly the same on my Local Dev, with exactly the same data in it.

I manage this in Navicat and can not see three databases in Docker, is this some kind of connection replication or some other anomaly?

It does indeed seem to be 3 connections to the same thing! :thinking:

Tried this and it doesn’t save every time I enter the details and refresh it clears the direct connection details.

When creating a field:

Not able to create a foreign key as yet? I see the easy check box and the ‘increments’ and works great…

Would be great to have “Foreign” check box or perhaps drop down selection [Primary] or [Foreign] for just “Key” .

Then foreign key would need some kind of relationship reference:

  • Name
  • Field
  • Referenced Data
  • Referenced Table
  • Referenced Field
  • On delete
  • On update

Also for Primary Key an “Auto increment” or “increment” checkbox.

2 Likes

Yes foreign keys and relations are coming up in the next update. We just couldn’t make it on time for the initial preview :slight_smile:

2 Likes

Thought there might be, just wanted to put in my 10 cents worth :grinning:

Very nice implementation so far @George and team. Not sure if I missed it and if it might have been asked for in other comments, but something we do not get in Navicat Essentials for instance is import and I always have to go to phpmyadmin (if the server has it installed) for imports. Would you consider adding a db import option?

What kind of db import do you mean? An initial structure or data?

Both would be first prize, but if only structure can be done, it would also be great!

Is there any support planned for working with database views?

1 Like

@Hyperbytes - have you added your IP address to the Remote MySQL Access settings?

Yes, Jon. It is added and I can connect via navicat, mysql workbench etc with the settings.

1 Like

Refresh just clears the settings, they don’t save

We will be revamping the direct connection options to a separate dialog for next week, so lot more connection options are available like SSL and SSH

You can focus now on the local databases and test out the database structure changes and apply.
Lie ones in WAMP or with Docker