Category Archives: PostgreSQL

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

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