Cybertec
Jan/10

13

Porting to PostgreSQL

Porting applications to PostgreSQL has always been a task I personally liked but when somebody suddenly came to ask us to port “several hundred” terminal programs from Informix to PostgreSQL I was pretty overwhelmed. I have never seen such a big set of individual proprietary programs in one place.

The code which we are supposed to port is mostly consisting of Informix ESQL/C. The problem is only: You simply cannot go to every program and fix things once after the other. Changing 700 programs one after the other is simply impossible without either running out of time, manpower, or any other finite resource you can think of. So, obviously a traditional approach is not possible. The only approach to make things work within a reasonable timeframe is actually to change and extend the PostgreSQL precompiler to eat Informix code. As PostgreSQL is Open Source this is the best option and in my opinion the only possible solution to this problem. The funny thing is: That even writing countless precompiler extensions is still cheaper than paying for Informix support in the long run.

, Hide

Cybertec is a company offering a comprehensive set of services for the world's most advanced Open Source database, PostgreSQL.
Our products work on all platforms including Linux, Solaris, and Windows. No matter whether your application is small or complex - we have the right solution for you.