Tag: MySQL

MyLocalDev Part 2: MEMP and Valet

Every local development environment is based on a stack of some sort. My goal here was to remove as many barriers to development as possible, and for me that aligns with installing everything locally. Local for me equates to OS X, so everything in this series is based on that setup. Install Homebrew Homebrew on […]

Posted: September 28, 2017

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

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

PHP, MySQL, and Contact Management: Contacts 0.1

Contacts is a free and open source (FOSS) contact management Web application running on PHP and MySQL

Posted: October 22, 2007