Category Archives: SQL

All things SQL and RDBMS related.

Missing MySQL’s REPLACE (aka MERGE) in PostgreSQL

Posted on July 13, 2006 by Michael Schurter

When Synthesys first decided to go with PostgreSQL as the database for a large web application, I was very excited to get away from our usual reliance on MySQL and move to a real database platform. Once we figured out … Continue reading →

Posted in Mono/.Net, Open Source, PostgreSQL, SQL, Technology | Leave a comment

Connecting Crystal Reports XI Standard to PostgreSQL

Posted on May 22, 2006 by Michael Schurter

At Synthesys we’re using PostgreSQL as the database for a large web application.� For the time being we’re writing our reports in Crystal Reports, although we’re hoping to move to a free platform in the future. Unfortunately we only have … Continue reading →

Posted in IT, Open Source, PostgreSQL, SQL, Technology | 9 Comments

Planned Obsolescence… in 8000 Years

Posted on March 22, 2006 by Michael Schurter

I made a simple little real time data reporting system live today which dumps a row into a MySQL database once a minute. I didn’t include any archiving or purging functionality, so I decided to do some quick calculations to … Continue reading →

Posted in IT, SQL | 1 Comment

OpenIT Progress

Posted on January 24, 2006 by Michael Schurter

I’ve been keeping up a good pace of bug fixing in OpenIT thanks to user bug reports. I’m really getting bitter about using MySQL 4.0, especially after we’ve started using PostgreSQL for a new project at Synthesys. Views? Foreign Key … Continue reading →

Posted in PHP, PostgreSQL, SQL, Technology | Tagged , | Leave a comment

Fun with SQLite + PHP

Posted on August 23, 2005 by Michael Schurter

My poor little OpenIT development box which runs on a whopping 48 MB of RAM has been running unusually slow, and I think its due to upgrading from MySQL 4.0 to 4.1. That’s really the only thing thats changed on … Continue reading →

Posted in PHP, SQL | Tagged | 2 Comments