Tag Archive for "sql"

Finding Frequency Counts With 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.

Continue Reading Finding Frequency Counts With SQL...

Funniest Database Quote

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 […]

Continue Reading Funniest Database Quote...

The New Gallery Has Finally Been Built

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 […]

Continue Reading The New Gallery Has Finally Been Built...

I’ve Finally Learned A Database

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 […]

Continue Reading I’ve Finally Learned A Database...