installing and tuning mariadb on osx

Wanted to install MariaDB on OSX. Mostly because I was running one in an Ubuntu VM and it seemed slow. Running a some dozens inserts taking several seconds. First install homebrew from http://brew.sh. The process is to invoke some cryptic looking command line sentence, which downloads a ruby script over the internet and runs that […]

python3 mysql connector and pip install procedures

Trying to learn some Python and use some of the nice and shiny libraries available for it. Problem: Need to use MySQL to store some data. Have to figure out how to connect and use the MySQL DB from Python3. Several places suggest using a Python package called MySQLdb. Seems fine but does not support […]

another fix to hibernate error

well, now i got another error along the lines of check the manual that corresponds to your MySQL server version for the right syntax to use near ‘type=InnoDB’ –>hibernate generates a script that is wrong in defining “type=” where it should be “engine=”. whooppee so it seems i can only create the tables myself..

mysql reserved words

my hibernate adventures, first try, failure to have it create dabase in mysql “you have an error in syntax between…” -> there is a set of reserved words in mysql and “precision” is one those. might be better to give some nicer error messages.