Designing Databases
A few months back I came across a resource for designing databases (it was posted in a MySQL discussion list). Database Answers has tons of sample designs (a.k.a., models) for various situations. What the site lacks in attractive design in more than makes up for in its usefulness. There are hundreds of designs for you to consider, covering everything from “dog whisperer” to event reservations to online banking. Definitely worth looking at when you’re thinking about the database scheme for your next project.
Configuring FCKEditor for Yii-Driven Sites
I’ve created three Yii-driven PHP sites in the past few months, each of which required an administrative area to dynamically manage the site’s content. Much of the content can contain some HTML, including media (images, videos, etc.), typography, lists, and so forth. So that non-technical people can create nice-looking HTML, I use a Web-based WYSIWYG editor like FCKEditor or TinyMCE. Getting either to work within the Yii environment isn’t too hard, once you know what to do. But because assembling the disparate parts can be tricky, I outline the specific steps and requirements in this post. Note that the post does assume familiarity with Yii. (continue reading…)
