by Andrew Johnstone
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 sitepoint.com, 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 […]
In: MySQL
20 Dec 2005MySQL 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” […]
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 […]
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.