Category Archives: database

Getting the size of BLOB in MySql

Posted on January 6, 2010 by dimuthu

If you want to store binary in database, you can use BLOB as the data type of that column. In Mysql you can use TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB depending on your space requirement. Here is an example of database table … Continue reading →

Posted in database, php, Tutorial/Guide | Tagged , , , , | Leave a comment

Article Introducing PHP Data Services

Posted on January 5, 2009 by dimuthu

Now you can view the article I wrote titling “Introduction to PHP Data Services“. There I explain how you can design and implement Data Services in PHP using WSF/PHP Data Services Library. This article covers, Designing your Data Service API. … Continue reading →

Posted in database, DataServices, design, php, REST, RESTful, SOA, SQL, Tutorial/Guide, web services, WSDL, wsf/php, wso2, xml | Tagged , , , , , , , , , , , | Leave a comment

WordPress Database – Relationship with Tags, Catagories and Posts

Posted on December 20, 2008 by dimuthu

WordPress has a very simple database schema. And it is well documented. You can access the complete description of the wordpress core database from here, http://codex.wordpress.org/Database_Description. Anyway first time I looked at the database I was confused with the term … Continue reading →

Posted in database, design, php, Tutorial/Guide, wordpress | Tagged , , , , , , | 9 Comments