georgiotunson / ssql Goto Github PK

The original intention of this tool was to support both postgres and mysql. It currently only supports mysql.
The implementation should happen here:

If you have a look at the above if statement here:

You will see all of the helper functions that are called in the case of mysql. The objective is to figure out which helper functions can be reused and which would need to be recreated for postgres.

Add functionality to dump databases.

As you have undoubtedly noticed, the above example stores a plaintext password in a config file and in this case, the application will also use this password on the command line. This is insecure for a variety of reasons and is not recommended. To resolve this issue, we need to create a more secure implementation for using db credentials. The idea is to use option files.