Archive for the ‘MySQL’ Category

Introduction Currently I’m working with stock market data, and its quite an interesting topic when we are getting to the point of real time data as it brings a number of new concepts into the mix. The first challenge is to import information from the feeds into our databases (MySQL), whilst this should be a […]

recently read “Binaries Belong in the Database Too” on, and thought I would shed some light with regard to my experience of storing files in databases. I’m sure many of you have known this to be a taboo practice, and I would certainly agree depending on the database. A project I worked on for […]

I wrote this a while ago, whilst playing with SQL Injection, however a little unfinished, the idea was to try to write out entire files, through an SQL Injection attack. I thought I would expand, on my previous post Exceptions, Exceptions, Exceptions, and see what is possible with a simple a SQL Injection attack. I […]

MySQL Install multiple instances. Create a folder called Conf with Instance.1.ini, Instance.2.ini, and Instance.3.ini. The Port each are listening on should all differ, as well as having a different data directory. I named these C:\Program Files\MySQL\MySQL Server 5.0\MySQLData\Instance1 mysqld –install “Mysql-Instance-1″ –defaults-file=”C:\Program Files\MySQL\MySQL Server 5.0\Conf\Instance.1.ini” mysqld –install “Mysql-Instance-2″ –defaults-file=”C:\Program Files\MySQL\MySQL Server 5.0\Conf\Instance.2.ini” mysqld –install “Mysql-Instance-3” […]



17 Dec 2005

Lately i’ve been developing with MySQL3, and it’s almost like hitting your head against a brick wall with its limitations and specific documentation is difficult to find. Some of the limitations: Subqueries. ’select id from t where grp in (select grp from g where u > 100)’ Add DISTINCT to Aggregates JOINs with ambiguous columns […]

About this blog

I have been a developer for roughly 10 years and have worked with an extensive range of technologies. Whilst working for relatively small companies, I have worked with all aspects of the development life cycle, which has given me a broad and in-depth experience.