What can a common PHP/MySQL-based CMS package teach me about data structures and algorithms? [more inside]
posted by circular on May 20, 2011 - 7 answers

I have a list of about 350 words that I'm putting into a database that I'm building from scratch. For each word in the list, I'd like to include its American English dictionary definition (preferably American Heritage Dictionary), UrbanDictionary entry, and Wikipedia page link (I realize that entries may not exist for some columns for many of these words). Is there some way to streamline or data-mine this process, so I don't have to look up each word individually in 3 separate sources x350+, not to mention all the copying and pasting? [more inside]
posted by iamkimiam on Feb 11, 2011 - 10 answers

What interesting statistical information can I dig out of this medical billing data? [more inside]
posted by neilkod on Nov 19, 2009 - 8 answers

I am thinking of making a simple wine-tracking website. The website would allow users to search for specific types of wine and add them to their "list". Where can I get data for all common wines? [more inside]
posted by jdlugo on Dec 14, 2008 - 3 answers

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 answers

Help me price out a server. I have a 10GB dataset from a company that I want to run SQL queries against. Right now on my MacBook they're taking ~12 hours to complete. Faster hardware is definitely needed! [more inside]
posted by sbutler on Mar 12, 2008 - 17 answers

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted by tmcw on Nov 15, 2007 - 7 answers