Tag Archive for "sql"
January 11th, 2008 by Andrew
Finding the frequency of items in a database table is something I find myself needing to do a lot. Though for some reason when I need to do this, I always forget how, so here it is. Let’s say you have a table of tag data with two columns and a bunch of rows. Let’s say the table is a simple adjacency list of tags for posts on a blog.
November 28th, 2007 by Andrew
I found this on Slashdot today as a question posed to Brian Aker, who is the Director of Architecture for MySQL AB. Having extensively used both MySQL and PostgreSQL myself, I found this quite hilarious: So, let me get this straight: you (mySQL) use a dolphin to fetch data while PostgreSQL uses an elephant to […]
July 6th, 2004 by Andrew
I’ve been working for some time on a new gallery to hold all of my pictures. It finally works, and I’m adding more and more pictures as I write this. My new gallery is much faster, and works much better. Underneath it’s shiny new interface is a bunch of PHP code, and a few MySQL […]
June 15th, 2004 by Andrew
I’ve put it off for a long time as something I didn’t need, but now that I have the skill, I don’t know how I’ve gone without it. PHP with a MySQL database is extremely awesome. Before I learned how to use it, I was making my own way of storing and retrieving any dynamic […]