Archive for December, 2009

Once again Saturn opens the door

December 14th, 2009 Comments off

Saturn SPL at Technopark requires PHP professionals. For more information you may contact +91-471-2527000.

* Only personnel with minimum one year need to apply
* Knowledge in ExtJS ui library, MySQL etc added advantage
* Knowldege and experience in popular PHP IDE, with remote debugging would be appreciated
* Package will be at par with industry standards.

Categories: PHP openings Tags: ,

Migration from MySQL to MSSQL our solutions – Continued

December 14th, 2009 1 comment

In the previous post, I had specified that a code analysis would be presented later on, which is happening now. Though I am not permitted to abstract the whole database abstraction, which would otherwise divulge the core business logic of the system too, I do expect that the following would be enough to guide a MySQL PHP developer to port his application to MSSQL 2005. Mostly the compatablities are maintained. But for the database design, we had to let away some of the wonderful features from MySQL.

We started by a code auditing and reworked the system such that we did not use any group_concat through out the system. Also all timestamp and datetime fields were changed to varchar(19) since we were already feeding those fields with the php function date’s return value or ‘now()’. But there was quite a handful of areas where we were using STR_TO_DATE and with different formats. So this had to be handled in its own way. And it is here we started our regular expression war path.
Read more…

Migration from MySQL to MSSQL our solutions

December 11th, 2009 2 comments

Last post I did had all of my feelings, and despair, and now I am sure those were out of sheer negligence and mostly because I was unaware of the MS SQL product. Though I still do not agree with certain things like the row_count workaround for the limit feature, and escaping of quotes. But for our project we could more or less maintain a streamline by using the same code base for MySQL, SQLite3 and MSSQL 2005. Will try to explain this across a couple of posts.

Read more…

Categories: General Articles, mysql Tags: ,

Porting application from MySQL to MSSQL

December 6th, 2009 No comments

At first I thought it should be a challenge, though I did not expect it to be too tough, since we were already using a custom db wrapper. Well it turned out to be well too heavy a nightmare. And there was situations where I even considered retiring from life. I pity those who are paying thousands of hard earned money to buy such filthy crap.
Read more…

Categories: Code Snippets Tags: ,

Convert MySQL Database to SQLite3 Database

December 3rd, 2009 6 comments

For a cd based time limited working copy, of one of our products, I decided to port our mysql application to sqlite3. Since we had about 70 tables, and all with optimized indexes, and about 24 user defined function 3 triggers and 12 procedures, normally anyone would have thought of simply getting along with the mysql system itself. But I wanted to face the challenge. Thanks to Rob Cameron for the shell script published on his blog RidingTheClutch, Convert a MySQL database to a SQLite3 database, which sparked my thoughts.
Read more…

Categories: Code Snippets Tags: ,


December 1st, 2009 Comments off


Extending the art & spirit of PHP, Zend Framework is based on simplicity, object-oriented best practices, corporate friendly licensing, and a rigorously tested agile codebase. Zend Framework is focused on building more secure, reliable, and modern Web 2.0 applications & web services, and consuming widely available APIs from leading vendors like Google, Amazon, Yahoo!, Flickr, as well as API providers and cataloguers like StrikeIron and ProgrammableWeb. Expanding on these core themes, the Zend Framework is implemented to embody extreme simplicity & productivity, the latest Web 2.0 features, simple corporate-friendly licensing, and an agile well-tested code base that any enterprise can depend upon. Extreme Simplicity & Productivity Zend Framework is designed with simplicity in mind. To provide a lightweight, loosely-coupled component library simplified to provide 4/5s of the functionality everyone needs and that lets you customize the other 20% to meet your specific business needs. By focusing on the most commonly needed functionality, they have retained the spirit of PHP programming, managed to dramatically lower the learning curve, and the training costs ? so developers get up-to-speed quickly. This has been achieved by: * An extensible and well-tested code base ? easy to augment * A flexible architecture ? not locked-in to a rigid application structure * No configuration files necessary to get up and running ? or when maintaining and deploying your apps Frameworks and best practices mean reduced training costs and quicker time-to-market ? important factors in adoption decisions. Built such a way that one can choose just the pieces they need to turbocharge any web application ? all developers know where to find their PHP / Zend Framework code, speeding new development and reducing maintenance costs. Latest Web Development Features * AJAX support through JSON ? meet the ease-of-use requirements your users have come to expect * Search ? a native PHP edition of the industry-standard Lucene search engine * Syndication ? the data formats & easy access to them your Web 2.0 applications need * Web Services ? Zend Framework aims to be the premier place to consume & publish web services * High-quality, object-oriented PHP 5 class library ? attention to best practices like design patterns, unit testing, & loose coupling Friendly & Simple Licensing, Safe for the Enterprise Based on the simple and safe new BSD license, with Zend Framework's License, one can rest assured that their code is compliant, unimpeachable, and protected as you see fit. It is also require that all contributors to the open source Zend Framework to complete and sign a Contributor License Agreement (CLA) ? which is based on the standard open-source Apache license ? protecting your own intellectual property (that is, your added-value) built on Zend Framework. Fully Tested ? Extend Safely and Easily Tested. Thoroughly. Enterprise-ready and built with agile methods, Zend Framework has been unit-tested from the start, with stringent code coverage requirements to ensure that all code contributed has not only been thoroughly unit-tested, but also remains stable and easy to extend, re-test with compatiable extensions, and to further maintain. Downloads

Downloads are available from the official website.

Categories: Code Snippets Tags:


December 1st, 2009 Comments off


The Zoop Object Oriented Php Framework (The Zoop PHP Framework for short). A framework written in and for php.

The Zoop PHP Framework is stable, scalable and portable. It has been in production use for the last 5

years and has been used in many production environments. The Zoop PHP Framework is designed to be fast, efficient and clean. It is easily extendable and you choose to include only the functionality you use.

With Zoop an inexperienced coder can make secure web applications quickly. A more experienced coder will really appreciate how flexible The Zoop PHP Framework is. Both experienced and inexperienced coders alike will appreciate the automations that are at his/her disposal to handle mundane tasks.

The Zoop PHP Framework encourages separation of display, logic and data layers(MVC).

The Zoop PHP Framework is made up of many components and integrates many different projects including smarty ( and the prototype AJAX framework. It also makes use of PEAR modules ( The efficient core components handle many of the functions you would have to code yourselves. Zoop's integrated error handling can be configured to log errors for production environments, and is highly informative and readable which makes bugs easy to find and squash.

Zoop has been designed to make the developers life easier by providing tools to make efficient use of his/her time. On of our more unique and notable features is our implementation of GuiControls, a revolutionary idea in PHP that provides many form widgets with validation completely integrated, as well as a framework to develop your own guiControls extremely easily.

Zoop Features
The Zoop framework features GuiControls (a PHP implementation of .net's webcontrols), AJAX support and integration, automatic form validation and creation (including db integration), a Smarty templating system, PDF creation, session handling, and SMTP template-based email sending, and integrated caching.

The latest version of the Zoop framework is available at
There are three files at SourceForge:

* Zoop—The Zoop Framework.
* Skeleton—A Zoop skeleton application.
* Lib—Zoop's PEAR library dependencies.

Go ahead and download all three.
Installing Zoop

Since Zoop is a PHP framework, you will need a working copy of PHP. If you don't have this, downloads are available from Zoop works great with PHP 4.3.10 or greater. We like PHP 5.2. We also recommend using a PHP Accelerator like eAccelerator.

Begin by extracting the files. On Windows use 7-Zip or another program capable of extracting tar.gz files. Zoop can be installed anywhere on your system. Some people put it in /usr/lib/zoop others put it in ~/zoop . It doesn't matter where you put it, just remember where it is because you need to tell your application.

The lib folder should be placed in the zoop folder, so you should have zoop/lib/pear/… Note that lib isn't strictly necessary. Depending on your system's PEAR installation, you may not need any of the included libraries. We provide them for ease of use, especially for shared hosting where you have no control over the system's PEAR libraries.


The latest Zoop code can also be checked out via subversion.

svn co "" zoop


svn co "" zoop_skeleton


svn co "" zoop/lib

Categories: Code Snippets Tags:


December 1st, 2009 Comments off

Yii is a high-performance component-based PHP framework for developing large-scale Web applications. Yii enables maximum reusability in Web programming and can significantly accelerate the development process. The name Yii (pronounced as [i:]) stand

s for easy, efficient and extensible.

Yii is easy to learn and use. You only need to know PHP and object-oriented programming. You are not forced to learn a new configuration or templating language. Yii is extremely fast. Its overhead to applications written on top of it is negligible. As a matter of fact, it is one of the most efficient PHP frameworks around.

Yii is highly reusable and extensible. Yii is purely object-oriented. Everything in Yii is a self-contained component which can be configured, reused or extended easily. More importantly, Yii has an ever-increasing extension library consisting of user-contributed components, which may help reduce your development time significantly. Yii comes with a rich set of features. From MVC, DAO/ActiveRecord, to theming, internationalization and localization, Yii provides nearly every feature needed by today's Web 2.0 application development. Yii has very detailed documentation. From the definitive guide to class reference, Yii has every information you need to quickly learn and master it.

Yii is carefully designed from the beginning to fit for serious Web application development. It is neither a byproduct of some project nor a conglomerate of third-party work. It is the result of the authors' rich experience of Web application development and the investigation and reflection of the most popular Web programming frameworks and applications.

Last but not least, Yii is free! Yii uses the new BSD license, and it also ensures that the third-party work it integrates with use BSD-compatible licenses. This means it is both financially and lawfully free for you to use Yii to develop either open source or proprietary applications.

Yii incorporates many ideas and work from other well-known Web programming frameworks and applications. Below is a short list.
* Prado: This is the major source of ideas for Yii. Yii adopts its component-based and event-driven programming paradigm, database abstraction layers, modular application architecture, internationalization and localization, and many others.
* Ruby on Rails: Yii inherits its spirit of conventions over configurations. Yii also referenced its implementation of active record design pattern.
* jQuery: This is integrated in Yii as the foundational JavaScript framework.
* Symfony: Yii referenced its filter design and plug-in architecture.
* Joomla: Yii referenced its modular design and message translation scheme.

Yii is released under the BSD License. This means you can use it for free to develop either open source or proprietary Web applications.

Downloads are available from the official download page.

Categories: Code Snippets Tags: