connection string etc

I'm playing around with Garage. Initially it was easy to get a connection to MySQL and return some rows, so I'm looking forward to using it.

Where would you typically keep a connection string, considering it also includes a password?
An ini file? That seems rather old school :-)
Or is there a better way than just storing a string?

2016-11-18 2:04 GMT-03:00 Jeff Gray <[hidden email]>:
> I'm playing around with Garage. Initially it was easy to get a connection to
> MySQL and return some rows, so I'm looking forward to using it.
>
> Where would you typically keep a connection string, considering it also
> includes a password?
> An ini file? That seems rather old school :-)
> Or is there a better way than just storing a string?

You could use an external STON [1] or JSON [2] file to store the
configs. I use the latter.

You could symmetrically encrypt the whole file or just the password
field. Or leave it in plain text where only the OS user can read it.

Regards!

[1] https://github.com/svenvc/ston
[2] https://github.com/svenvc/NeoJSON

Esteban A. Maringolo

On Thu, Nov 17, 2016 at 09:04:15PM -0800, Jeff Gray wrote:
> Where would you typically keep a connection string, considering it also
> includes a password?
> An ini file? That seems rather old school :-)
> Or is there a better way than just storing a string?

For the password, see blog post:

  http://www.samadhiweb.com/blog/2013.08.11.splitpasswordstore.html

I use it to configure the password to get into the RFB server in the Pharo
image that is running my blog.

Pierce