This will be intermediate tutorial about caching SQL query results. We will use interface to make support for extending available ways of caching your results. We will create cache that will use MySQL database and flat text files to store cache.
Read the rest
I’ve read an article about database design. It’s very simple but I try to design my databases/tables following that article. But there is one thing that is also important. You need to design your tables and their relations so that you can get almost everything your need with as much queries as possible. This is a part that MySQL-s complex queries are very useful. In two last jobs that I did I needed to optimize script as much as possible. One project is a plugin for Wordpress that I’m currently working on. When ever I do something I give my best to do it right and I really try to design relations and queries very good. Here are some examples of queries that I needed.
Read the rest