jpuck / qdbp Goto Github PK

Maybe parse the DSN driver to determine the DBMS.

CREATE DATABASE <database name> CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

See also: choosing a collation.

this will allow for backwards compatibility in PHP<7

closing tags causes whitespace issues (being sent before header, etc.) when appended

The current password generation mechanism is too simple as it only uses [0-9a-Z] which won't satisfy MySQL 5.6 complex password standards. The function needs to spice it up with special characters, and it could stand to be longer also.

sometimes with localhost we get

[PDOException (2002)]
SQLSTATE[HY000] [2002] No such file or directory

https://stackoverflow.com/a/22927341/4233593

if you enter a multi-line command for exec_sql.bash, then only the first line gets saved to exec_sql

In the event that the credentials.local.bash file is in a folder available to the world wide web, it needs to be blocked from a web server freely distributing it. for production environments, this file is not created, so it's a low priority. as long as the web server has php enabled and configured properly, then it shouldn't serve the contents of the credentials.local.inc.php file. considerations for a variety of web server vendors should be made.

Longer term solution with other possible benefits: implement all the bash scripts in php.

too many errors forgetting to simply bump the splash screen version number. need something like this release script.

please consider registering with phive on https://phar.io/

credentials.local.* are already ignored in this project, but we need a way that first checks if they're presently ignored in the super project, and appends the .gitignore if not.

you can now pass a username (and password) to this script for more powerful automation - in particular setting -u root with no password for travis-ci.

need to update usage prompt in script and README.md