Editing a WordPress site on a live server is quick and simple. It’s also one step away from disaster. The goal of this talk is to give you all the knowledge and tools you need to develop WordPress on a local machine, and then to push those changes to a live website. We will automate as much of the process as possible, giving you more time to actually develop your site instead of copying files back and forth or clicking dozens of menus to export and import databases. Topics discussed will include local web servers and databases, file version control (Git), and database synchronization.

Feel free to email me with any questions. Want to work with me? Head on over to Adaro Consulting.

Here is a list of resources I mention in the talk:

• Coda
• LiveReload
• MAMP
• XAMPP
• Git Tutorial
• Github
• Deploying Git automatically to a server
• How to Sync A Local & Remote WordPress Blog Using Version Control

Not mentioned during the talk, but here are my favorite Git clients

• Sourcetree
• Github for Mac
• Tower
• Git Extensions (Windows)
• Github for Windows

Here is the command SQL code I referenced:

1) Run this command on the live server:

2) Transfer database_name.sql locally (using scp or sftp)
3) Run this command on the local server:

4) Run this command on the local server:

The contents of update.sql should look like so:

Of course, replacing “local_folder_name” with the name of your website.

We’re using the WooCommerce plugin for their eCommerce needs, which so far has proven to be excellent and flexible enough to meet their requirements.

For this specific requirement, I modified a WooCommerce plugin to export the orders to a CSV file, which was easy enough. But I then had to modify that plugin so that I could call it from a nightly cron script.

Turns out, that is pretty simple to do. At first I thought I might have to fake logging into the site using curl and cookies, and then call the script and push through a GET request.

I then found this blog post over at CodeGarage.com which addressed the exact same issue, and he outlined a much simpler solution:

1. Include wp-load.php
2. Inlcude wp-admin/admin-functions.php
3. Call the function

So basically, all I had to do was extricate the actual function which exported the CSV from the plugin, put it in a new PHP file, include those aforementioned files, and then I was all set.

The last step was setting up a cronjob to run /usr/bin/php on the script which was simple enough.

For decades I drank coffee like (most) everyone else, from a drip coffee maker. In 2007 I started a new job that had this magical new coffee maker, called a Keurig, that made near-instant coffee that tasted much better than, well, instant coffee.

I was in love, and bought a home version for myself a year later. Like I always had, I added cream and (fake) sugar without a second thought. The coffee tasted fine this way. People sometimes raved about Starbucks or complained about Dunkin Donuts, but to me, all coffee tasted the same.

Of course, that was because I was adding cream a sugar. Sadly I can’t remember when it happened, but one day I tried a cup of good quality coffee without any additives whatsoever. The first sip was somewhat bitter, but after that, I realized it’s possible to appreciate coffee as a drink itself, rather than a way to streamline caffeine into your system.

Sadly, I realized around this time that the coffee made from Keurig machines was pretty sub-par. I decided to make the jump to making myself good coffee.

The Setup

It took a few months, but I ended up with this setup:

• Aerobie Aeropress Coffee Maker
• Bodium Conical Burr Grinder
• Bodium Coffee Storage
• Milk frother
• Good quality whole bean coffee
• Coffee spreadsheet

I actually started with just the Aeropress, since it was so cheap. I bought beans from places like Trader Joes, ground them at the store, then brought them home. The coffee was pretty good, but I noticed an exponential decrease in the coffee as early as the second day after grinding them. I realized an investment in a decent grinder was needed.

I did some research on coffee grinders used with Aeropress, and found out that you really need to spend the extra money on a burr grinder, as the blade grinders not only have the issue of burning the beans (due to the heat the friction generates), but also that the lack of consistency makes for a poor press.

The Process

1. Preheat Keurig (yes, I now use my old coffemaker as a hot water machine.
2. Measure five Tbps of whole beans and grind on the medium setting
3. Prepare Aeropress filter
4. Pour beans into the filter
5. Pour two ounces of water into the plunger
6. Stir for two seconds, wait another twenty
7. Plunge the coffee
8. Clean up the plunger
9. Pour the remaining water into the coffee
10. (Optional) Add some frothed milk on top

Even though it’s ten steps, the entire process takes about two minutes of actual work.

Best of all, the cleanup takes literally eight seconds (I timed it). I briefly used a french press, and while I loved the taste, the cleanup was such a pain. An Aeropress makes such good quality coffee for the incredibly low amount of effort it requires.

I was ecstatic after a week of using my new grinder though, and it was absolutely worth the investment. Shortly after I purchased the glass container to store the coffee in. I’ll usually pour out about 1/4th cup of beans into the storage container and put the rest in the freezer until I need them.

I also created my Google spreadsheet right at the beginning. I found there was such a vast difference in the taste of each coffee that I needed to keep track of it, in order to avoid repeating bad coffees or forgetting the best ones.

As for the next step? I should really purchase a digital scale to measure the amount of beans and water I add. I actually lost my Aeropress scoop a few months ago, which is why I’m estimating with five tablespoons of beans.

But then I had a kid, and sleeping later than 6:30am became a luxury, and suddenly I was getting quite tired by 9:00 at night.

I kept trying to force myself to stay up later (8:30pm coffee anyone?), but it just wasn’t working. This was especially true when trying to run my consulting business. I just didn’t feel as productive and motivated after dark.

A few weeks ago, I got a treadmill, and decided I was going to start waking up early enough to exercise, which meant around 5:15am. Well turns out I really do not like exercising in the morning. Actually I don’t like doing anything in the morning without a shower to wake me up first, which meant I would shower, exercise, then shower again, which felt a bit silly.

So I moved exercise to after work. But instead of abandoning waking up early, I kept doing it — and started doing consulting in the morning instead.

It is awesome. The world is completely silent, both inside (my three year old might have trouble going to sleep but sleeps like a rock in the early morning) and out (no email interruptions, not even Twitter activity to distract me).

My brain is working its absolute best at this time of day too, especially when compared to late at night. At least, it is after an Americano from my Aeropress.

There’s also something immensely satisfying about getting an hour of work done even before I start my actual “work” day. I’m able to address any client concerns before most of them even wake up, which seems to make them happy.

Really though, one of the best benefits is completely non-work related: I wake up with enough time to spend ten or twenty minutes playing with my son, who of course at three is also a morning person and is thrilled to be able to play cars with his dad at 6:45 in the morning.

1. Allow me to quickly copy the hex code
2. Allow me to paste the hex code without the # in front of it.

Apps which met the first requirement were easy to find; the second, not so much.

Around that time I just happened to see a top article on Hacker News for a color picking app someone had developed. I tried it, and really liked it, except it also was missing feature requirement number two.

I mentioned that in the comment thread in Hacker News, and lo and behold, the developer added it that very night.

Best of all, it’s free!

Color Picker Pro

I first started noticing this not when I was searching, but when I was trying to do some SEO for my company. I was looking at the sites that ranked highly for the term “dividend stocks.” In the past, the top results were always giants like Forbes, Yahoo! Finance, Motley Fool, etc.

Now though, the top results were from sites like “www.dividendstocksonline.com” and “www.dividend.com”. I immediately considered them to be useless, spam ridden sites with the sole focus of selling ads. And guess what? They were.

Then recently I was doing some research on health supplements for another client. So I type that into Google and what’s the second result? “www.healthsupplements.com”.

I knew that Google definitely took the URL name into consideration in terms of SEO, but I don’t remember it ever making low quality sites such as these and making them outrank much, much better sites.

To be fair, Duck Duck Go isn’t much better (nor is Bing, for that matter). But I do think it shows there is a lot of room for improvement in the current statuf of internet searches.

2) Read Gruber’s Article about Bing now being a possible contender, but that he uses Duck Duck Go

3) Went to Duck Duck Go and searched for the first thing that popped into my head, cheese fries.

4) See the fourth result is for chilicheesefries.net, an empty domain page.

5) Never use Duck Duck Go again.

Ok, so maybe this was a little extreme. But for all the whining people do about Google (myself included), no other site has ever come remotely close in terms of delivering accurate search results.

I’m a sucker for task and project management apps, so I signed up a few seconds after watching this. First impressions are great, though a little sad how much they ripped off the current system I use, Asana.

Everyone knows the routine, get to work by 9 AM, sit in front of the computer, code all day, and head home at 5. Now, thanks to guys like Tim Ferris I have started to re-think how I work and what makes me productive as a software developer.

Recently, I made some big changes to my Monday to Friday schedule. For a long time, I did things just like all of the other coders I know. But during the second half of 2011, I started experimenting to see what type of daily schedule makes me most productive.

I love detailed schedule posts like this, and I think there is a lot to like about this schedule.

The main takeaway I get from it is the four hour programming block. I always knew (or assumed) that blocks of 100% programming, with no interruptions whatsoever, would be helpful to development. I never really realized how true that really was until I started experimenting with the Pomodoro technique. This basically involves making time slices of 25 minutes where you work on a single task, without interruption.

So I made a macro using the wonderful Keyboard Maestro app which takes my email offline, quits twitter, and sets my IM status to Away. And I get an amazing amount of work done in those time periods.

Partially, it was because the cable was installed in an odd place in the living room. But that was just a tiny reason, the small excuse I needed. The amazing thing? For someone that enjoys television, I haven’t really missed cable at all.

I’ve missed it during the Oscars, the Super Bowl, and one time when my mom visited and she wasn’t able to watch the Cleveland Caveliers play.

What have I gained? Well, to start with, something in the range of $2500. Cable is amazingly expensive, even with a basic package, when you include the “necessary” add ons in this day and age, such as high definition and HD DVR boxes.

I’ve gained an amazing amount of free time, I’m sure. I still watch shows every other night or so, but there is no such thing as sitting down and zoning out in front of the television. I always have to sit down with a purpose.

My son is growing up without a television. The movie room is downstairs, which he doesn’t use (yet). He has an iPad, but only watches or plays with it for maybe 30 minutes each day.

This Wall Street Journal article sums up my thoughts nicely:

I mean, come on. How many shows about housewives are there? I like chefs, but I don’t need to see them on television 24/7. Ghost hunters? Dancing celebrities? Talent shows? “Shark Week”? Celebrity ghost-hunting talent shows during “Shark Week”? It’s too much of too little. You’re full of a lot of inescapable crap.