Archives For MySQL

Defining Databases for the Yii Application

November 5, 2009
This entry is part 4 of 8 in the series Learning the Yii Framework

This is the fourth post in my series on Yii, my favorite PHP framework. [intlink id=”473″ type=”post”]In the first[/intlink], I show how to download and test the framework itself. [intlink id=”563″ type=”post”]In the second[/intlink], I show how to create a basic Web application. [intlink id=”583″ type=”post”]In the third[/intlink], I walk through some configuration options. In this post, I want to discuss the database design that will be the foundation for the Yii application I’m demonstrating (in the subsequent four posts). The specific example will be a classic employees-departments application, with each employee in one department. This post does assume you have an existing Yii application to work with, most likely by following the steps in my previous posts.

(Note: In October 2010, I’ve updated this entire series to reflect changes in Yii since this series was written, and to take into account feedback provided through the comments. Some outdated material will be crossed out, but left in to reflect how things have changed since the series was begun in June 2009.)

Continue Reading…

In MySQL, PHP, Web Development , ,
permalink

Configuring Yii

November 3, 2009
This entry is part 3 of 8 in the series Learning the Yii Framework

This is the third post in my series on Yii, my favorite PHP framework. [intlink id=”473″ type=”post”]In the first[/intlink], I show how to download and test the framework itself. [intlink id=”563″ type=”post”]In the second[/intlink], I show how to create a basic Web application. The end of that post also discusses the files and folders in the application directory. You’ll want to be familiar with those as you go forward. In this post, I discuss how you’ll want to configure your Yii-based application, including handling errors, adding components, and establishing a database connection. This post does assume you have an existing application to work with; if you don’t, follow the steps in the previous two posts.

(Note: In October 2010, I’ve updated this entire series to reflect changes in Yii since this series was written, and to take into account feedback provided through the comments. Some outdated material will be crossed out, but left in to reflect how things have changed since the series was begun in June 2009.)

Continue Reading…

In MySQL, PHP, Web Development , ,
permalink

Getting Started with the Yii Framework

October 31, 2009
This entry is part 2 of 8 in the series Learning the Yii Framework

Many, many moons ago I wrote [intlink id=”473″ type=”post”]a post introducing the Yii framework[/intlink]. It’s a framework for creating Web applications using PHP 5 (or greater) that I’ve really liked since I originally started with it. Ruby on Rails was the first Web development framework I personally used (back in 2005) and Zend was the first PHP framework. I love the former, and Yii is quite like it in many ways, but I never really took to Zend. In that first post, I discussed just downloading and testing Yii; here I’ll walk through creating the beginnings of a Web application.

(Note: In October 2010, I’ve updated this entire series to reflect changes in Yii since this series was written, and to take into account feedback provided through the comments. Some outdated material will be crossed out, but left in to reflect how things have changed since the series was begun in June 2009.)

Continue Reading…

In MySQL, PHP, Web Development , ,
permalink

NoSQL

October 13, 2009

If you haven’t heard about NoSQL before, it’s worth looking into. It’s an interesting development in the world of databases, or an interesting label given to a long-running approach to non-databases, depending upon how you want to think about it. The short description of NoSQL is that, instead of turning to existing relational databases, from MySQL to the powerful Oracle, many high-demand applications are using their own storage system. This includes the biggies, like Facebook, Amazon, and Google. By writing a specific storage system for an application, you can greatly improve the amount of data that can be managed and, more importantly, the performance. In other words, instead of using something that’s been designed to work for every situation, create something that’s perfect for your situation. This level of effort certainly isn’t for everyone or every situation, but for those that use databases a lot, and have potentially demanding applications, it’s worth thinking about.

I first heard about NoSQL when I saw this article in Infoworld. You can read about the June NoSQL conference in San Francisco here. There is also a piece of software called NoSQL,

In MySQL, Web Development
permalink

MySQL: Forked Beyond Repair?

May 30, 2009

[intlink id=”390″ type=”post”]In a previous post[/intlink], I discussed an offshoot from MySQL called MariaDB. Interestingly, I just read this quick article over at InfoWorld. It talks about the pros and cons of forking (for us, the end user) and what they feel Oracle must do to keep MySQL on top and relevant.

In MySQL
permalink