I'm trying to learn rails, and the issue of databases has made it a bit difficult to understand. Create a database by console and subsequent migration, this is supposed to create 3 databases (dev, test and production). But when viewing the bd server from a database administrator (eg: myqlworkbench) none of those created databases appear. Is there any way to manage them in graphical mode or are they just "virtual" databases?
When you create by default a first application rails, is configured to use sqlite as a database so when you run rake db:create and rake db:migrate you are creating new databases in this manager bd, to explore them you could use some sqlite client tool and open the files hosted in the / db folder of your project.
Once you create a migration, you must run on the console:
rake db:create
and then
rake db:migrate
By default, rails use sqlite and by default when you run rails commands run them in development environment, so once you run rake db:create and rake db:migrate you'll get < strong> a sqlite database real in the /db directory, usually with the name development.sqlite3 or similar. To manage it graphically you can use sqlitebrowser
You can also configure MySQL or PostgreSQL for which you have to edit the file database.yml with the data of the databases and in your server that data must match.
hello I understand what you ask exactly you would have to change to my sql and localhost by default of the mysql .. with another database I do not know. you recommend that you use this command in the console rails g scaffold nombre_tabla_campo1:string campo2:integer campo3:integer since it generates the CRUD. add modify update and destroy. Apart from the controllers and the views, you would only have to execute that and it would be easier for you to learn.