SQL tips and tricks

Over a period of time we have accumulated a large number of SQL tips and tricks. This is a collection of those quirks. Generic SQL, MSSQL, MySQL & PostgreSQL are included.   To find all the rows in a table where a certain value is empty select productid,title_tag,weight,length,width,height,meta_description from xcart_products where LENGTH(meta_description) != 0″ queries…

Details

Sending Messages Using SNS , SQS Along with the push Notification Using Urbanairship

Amazon Simple Notification Service (Amazon SNS) Amazon SNS is a web service that makes it easy for the developers to publish messages from an application and immediately deliver them to subscribers or other applications. It is designed to make web-scale computing easier for developers.Amazon SNS provides a simple API that allow developers to create and…

Details

PMB OPAC TRANSLATION

PMB is an Integrated Library System named PhpMyBibli at its beginning . PMB (PhpMyBibli) is a fully featured open source web-based integrated library system , developed in French. PMB is based on web technology. PMB requires an HTTP server (such as Apache, but this is not an obligation), the MySQL database and the PHP language..…

Details

PhoneGap and jQuery Mobile

PhoneGap PhoneGap is an open-source mobile development framework developed by Nitobi Software. PhoneGap lets developers use web technologies to develop apps for iOS, Android, Blackberry, WebOS ,Symbian and Bada. PhoneGap doesnt require knowledge in Objective-C/Java, it allows developers to develop applications in Javascript, HTML and CSS. What PhoneGap does is “bridge the gap” (hence the…

Details

Perl Dancer Framework

Dancer is a micro framework used for writing Web applications. It is modelled after a Ruby framework called as ‘Sinatra’ that constructs web applications by building a list of HTTPs, URLs and different methods to handle that type of traffic to that specific URL.

Required Perl Modules
Dancer, Template Toolkit, File::Slurp, DBD::SQLite.

Template Toolkit : Front-end module to the template toolkit.

Details