Archive for June, 2013

MySQL: Installing and starting MySQL On Mac

Sunday, June 30th, 2013
  1. Download latest native Package (i.e. .dmg) here: MySQL Download
  2. See installation doc (install MySQL and the startup items

Startup Items Info from doc

The Startup Item for MySQL is installed into /Library/StartupItems/MySQLCOM. The Startup Item installation adds a variable MYSQLCOM=-YES- to the system configuration file /etc/hostconfig. If you want to disable the automatic startup of MySQL, change this variable to MYSQLCOM=-NO-.

Start:

shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

Stop:

shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop

See source

maven: Custom Maven Repository Web Applications

Monday, June 10th, 2013

Archiva vs artifactory vs nexus

postgresql: jdbc url to connect to a schema

Saturday, June 8th, 2013

There does not seem to have a way to have a connect string that specify a schema, but a user can be set a default schema.

ALTER USER user_name SET search_path to 'schema'

source