Posted on February 15, 2008 by ragrawal
When developing a web application, one has to be careful about the “character encoding”. There are many options such as latin1, utf8, etc, and the best character encoding depends on the language that your targeted audience use for writing. Since most web applications are required to handle all types of languages and, thus, are required to handle all different types [...]
Filed under: CakePHP, Database, MySQL, PHP, Web | Leave a Comment »
Posted on December 26, 2007 by ragrawal
Recently, I started working on a new project which uses postgres database and contains more than 3 million addresses. One of my first task was to geocode address. To do so, I wanted to sequentially access all the records ordered by address. As I never dealt with such a large database before, my first attempt was a [...]
Filed under: Database | Tagged: Cursor, PgSQL | 3 Comments »