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