Tags: mysql

Jetty, Jersey and MySQL inside Eclipse

November 15th, 2011
This article gives a step by step set of instructions to set up Eclipse to run a Jetty application container using Jersey RESTful annotations and talk to a MySQL database. You would have thought that with all these technologies being really popular ther… more »

Installing Python 2.7 with MySQL support on Plesk CentOS 5.5

July 7th, 2011
CentOS 5.5 is dependant on Python 2.4. Everything will break if you change it, so we must install a newer version of Python in a different place. Surprisingly my 1&1 CentOS didn't come with gcc installed so I had to install it myself. yum -y i… more »

Set conditions in a MySQL database

November 1st, 2010
Ever come across the situation where you need to search for sets of values in a (MySQL) database? SQL along the lines of: SELECT col1, col2 FROM table1 WHERE (col3 = 5 and col4 = 6) or (col3 = 10 and col4 = 12) or (col3 = 15 and col4 = 3) more »

Adding MySQL users to a Plesk 9.2.1 server

September 1st, 2009
Creating a MySQL user that can only access a particular database instance, is a bit tricky to do from the MySql command line. Fortunately, the people at Plesk have added it into the appliance administration software. Previous incantations of the Plesk… more »

I am a Snowhead now!

November 11th, 2008
I am officially a SnowHead now. I went on my first Skiing trip with them to Xscape‎, in Milton Keynes which is an indoor real snow dome. SnowHeads is an internet club of skiers who meet up and go skiing together. SnowHeads organises events in th… more »