Simple database management
August 18, 2017
You must have a gorilla.com user.
- You must have got installed Docker, GorillaJS and DB plugin manager.
$ gorilla plugin add db_manager
$ gorilla plugin remove db_manager
How to use it.
This plugin is very useful to do maintenance basic tasks in your database. You can import, export, replace the database easily. If you need to make questions or a forward-thinking management, you can use the Adminer plugin.
To import you have to pass the sql file with the queries you want to import. It doesn’t replace the actual tables and the data there’re in the database.
$ gorilla db import my-file.sql
To export you have to pass the path in which you want GorillaJS to save the database copy.
$ gorilla db export my-file.sql
This command is the same than the import one but it eliminates all the actual database and later it imports the data we pass in the sql file.
$ gorilla db replace my-file.sql
For the moment it only works with containers which uses the MySQL engine. The last version will also work with PostgreSQL and MongoDB.
The NodeJS template that comes as a default in GorillaJS uses the Express.js framework to start a server and return a response. This is optional, and once the application is running we can eliminate this server and use the application in any other way.
Why do you need to free the port 80? Can you make your own installers? Can you use GorillaJS in a remote server?