Tag: database

Understanding MySQL in WordPress

Like most things in WordPress, SQL “just happens,” and you don’t have to know anything about it beforehand to start working with WP. You could actually go your entire life using WordPress and never once need to know anything about SQL. That’s if your entire life using WordPress is in a lightweight manner – a […]

Posted: August 29, 2013

Understanding MySQL in WordPress

If you’re looking to improve your low level WordPress querying chops, this article is great. When building more application-like pieces of functionality in WordPress, it’s really important to understand what’s happening under the hood (at least to a degree) so you can ensure that you’ve taken care of potential bottlenecks when your project gets utterly […]

Posted: June 13, 2013

Sequel Pro 1.0 RC1

This is great news! Sequel Pro has become my absolute go-to for all things MySQL. It’s a very successful open source project and I highly recommend it if you’re not a die hard command line user. Some things of note: the guys at Panic see as much value in Sequel Pro as I do and […]

Posted: January 09, 2013

Loading half a billion rows into MySQL

derwiki – Loading half a billion rows into MySQL. Wow, I’ve never worked with databases as big as the one mentioned in the article, but I’m fascinated by the updates that were made to optimize 500 million table sharded records into a single table all the while increasing performance. Over time I’ve struggled with large […]

Posted: June 06, 2012

Three things you should never put in your database

Three things you should never put in your database | Revolution Systems. There are a few good tips outlined here, but with everything there are two sides to every story. There’s some good discussion in the commentary behind various counter-arguments. I’ve worked on a few projects that broke some of these rules, one in particular […]

Posted: May 04, 2012

dbdsgnr.appspot.com

dbdsgnr.appspot.com. Database schema design is a talent to me. I’ve designed some pretty awful databases in my time, but I think a tool like this could have helped with that. dbdsgnr is an HTML 5 Web app that lets you visually build out your database schema. Once you’re done, the app will spit out the […]

Posted: January 26, 2012