After some projects done with symfony, I’m giving Slim Framework a try. I need to setup a database, but I’m not sure about the approach to choose.
With symfony and doctrine ORM, database schema was defined only once in a central place (php model files, or xml/yml config). Then, it was easy to generate the sql creation/migration scripts, and choose between mysql, sqlite and postgres.
With Slim Framework, there are some docs about eloquent but I’m missing the commands to generate the sql commands.
I’m therefore wondering how you here usually deal with the database schema creation. Do you use specific tools like mysql workbench or some other db agnostic tool ?
Right now, I’m thinking of using doctrine (like that : http://blog.sub85.com/slim-3-with-doctrine-2.html) or Phinx (like this : https://siipo.la/blog/how-to-use-eloquent-orm-migrations-outside-laravel).