Category Archives: database

Getting the size of BLOB in MySql

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

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

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