Archives For MySQL

The CDbCriteria class let’s you customize queries through an object. The first thing you should do to become more comfortable with Active Record when using the Yii framework is master usage of CDbCriteria.

This is an excerpt from Chapter 8, “Working with Databases,” of “The Yii Book”.

Continue Reading...

I recently read this short but awesome post titled “Be Productive with the MySQL Command Line”. In the post, the author Stephane Combaudon,presents three extremely useful tips for when you’re using the command-line MySQL client. The first two are invaluable to me.

Continue Reading...

This is the third and final issue of my two-part newsletter on “going big”. (Yes, third in a two-part series.) By “going big” I mean how one transitions from a Web site with little to moderate traffic, to one that can handle tons of traffic. The first newsletter looked at going big from the macro perspective: theory, implementation, hardware, and networking. The second newsletter was the first look at the micro perspective: how to write code that scales well. The emphasis there was on the code itself, along with the development process.

In this newsletter, I’ll provide a couple of resources for two other key components: the underlying database and the user’s browser. As always, questions, comments, and all feedback are much appreciated. And thanks for your interest in what I have to say and do!

Continue Reading...

Yesterday I (finally, finally, finally) posted another update to “The Yii Book”. This is version 0.7, with two new chapters:

Chapter 15, “Internationalization”
Chapter 16, “Leaving the Browser”
This adds about 40 more pages of material, bringing the total to around 405 pages as a PDF.
These two chapters do reflect a change in the table of contents, but I’ve not removed any planned content, just re-arranged it. The next two chapters are:

Continue Reading...

I am pleased to announce that I’ve just signed a contract to write the second edition of my “Effortless E-commerce with PHP and MySQL” book, published by New Riders. The first edition was written in the fall of 2010, and has been very well received (out of 22 reviews at Amazon, 18 are 5-star). There was more I wanted to do in the first edition, and a few things have changed since the book was written, so my publisher and I felt it was time for a revision. I’ll be writing the book at the end of the summer and early fall (after I complete “The Yii Book”), with a release date in October or November.

Continue Reading...