Archives for “MySQL”

Pie Charts with MySQL

Hey... ... want to know how to do this with MySQL? [code gutter="false" light="true" wraplines="false"] +----------------------------------------------------------------------+ | pie_chart ...


Outline An interesting problem reared its head today regarding the inability of my Django setup to connect to a remote MySQL server. I have just migrated ...


Useful MySQL Tips 1

I seldom get through the working week without spending at least a little time on the MySQL server command line. I love those little things ...


I have just come across an interesting discussion of MySQL's GROUP BY clause. I have always taken it as read that MySQL rather 'abused' the ...


MySQL's fulltext searching makes use of 'Term Vector Theory', which basically means calculating word distances using three dimensional vectors. Go here for a more thorough ...


I recently had the requirement to connect to a SQL Server DB from a Linux environment using Perl. Having run a round a bit to ...


I have had the opportunity to use PDO to connect to a MySQL DB at work recently. One requirement of the project was to provide ...


I have just started investigating the possibilities of using PHP5's 'PHP Data Objects', or PDO, as a way of accessing databases. This has come after ...