Running Scrapy on Django-Chronograph

October 18, 2012Posted by Noel Purugganan

 

Most of the scheduled jobs I am running are set on django-chronograph. It makes jobs easier to manage, and allows my clients to manage the scheduling. It also allows them to check the logs in a user friendly environment. So after creating my scraper using Scrapy that runs in django ...

Django on Google App Engine plus Cloud SQL

June 08, 2012Posted by Noel Purugganan

 

Today I have successfully migrated this blog to Google App Engine (GAE) with only a change in the database settings by exploiting the new Google Cloud SQL. Here are the steps I did: 1. I followed this guide to setup my database in Google Cloud SQL. 2. I uploaded the ...

Optimization Pitfall: Memcached Memory Limit

January 28, 2012Posted by Noel Purugganan

 

Google describes Python as a language that is easy to develop with. It can greatly improve developer productivity and code readability. This Python's strength comes at a price of slow performance. Well, interpreted high-level languages are inherently slow. Fortunately Django comes with great caching techniques which can bypass all the ...

Decoupling Technique: Django ContentType

December 15, 2011Posted by Noel Purugganan

 

As described in the Django documentation, ContentType can provide generic relationships. This generic relationships can provide a good way to decouple a Django App from another, which will eventually make it more pluggable. In my case, I needed to track the number of clicks in every internal link of the ...

Django 1.1 and Wordpress Integration

November 08, 2011Posted by Noel Purugganan

 

When I was a beginner with Python, I proposed to my manager to use Python in place of PHP. And he asked me, "Can we integrate PHP and Python?". If only I had more knowledge that time, our company would have invested more with Python. During the past months, I ...

Create unhex() function for MSSQL

September 23, 2009Posted by Noel Purugganan

 

Our company stores data from Avaya into MySQL database. While our applications are using MSSQL for storage. We have our two databases connected having MySQL as a Linked Server in MSSQL. From MSSQL, we tried: SELECT * FROM OPENQUERY([MySQL_DB], 'SELECT unhex(column1) FROM table1') The MySQL query works if I run ...