Tagged: Database

Quick-Start Guide to ADOdb Database Abstraction Library for PHP

PHP (and yes it’s for Python too..!) Adodb library has been one of the popular database abstract library since sometime now. We have been using it since sometime for simple operations when we are not using standard framework and probably just serving the plain web-services.

Here is a quick start guide to get started with Adodb5 library when using with PHP to get started with most basic functions for database interactions. For more details one can always browser around and read through detail documentation available at http://phplens.com/lens/adodb/docs-adodb.htm. This is just a quick start guide for all those who just want it little faster to get along with.

Reading MSSQL BLOG column data with PHP

I was working on a migration script to transfer data from legacy desktop software to Portal we have developed. While migrating attachments (stored as TIFF files) in BLOB (Long Binary) in Microsoft SQL Database Server using PHP it was not a cake-walk. When I observed every time it was creating a file of same size (4KB). I quickly understood that there is some limitation (of size) for reading records in PHP configuration.

Alternate to FIND_IN_SET for non-MySQL databases

If you are MySQL user initially at the beginning of your career and later on as the career progresses got in touch with other RDBMS then you might miss MySQL’s FIND_IN_SET function badly.
What MySQL’s FIND_IN_SET does is it returns position of the matched element in the SET. That SET of items must be comma-separated. Now if you’re long time MySQL user you will miss some of the functions and one of them could be FIND_IN_SET, read on to find out how easily we can use LIKE in alternate to FIND_IN_SET.

MySQL 5.5 available for production

Back in December when I updated my twitter status to announce MySQL 5.5 general availability, I was very happy at that moment. It was the first major and much awaited release of MySQL after Oracle – the database giant acquired Sun (and so MySQL). Though MySQL 6.0 is not an active project right now and there are many strategic changes after Oracle’s acquisition of Sun for MySQL’s development road-map, but as a AMP developer it was news to be happy about.