-Since you didn't specify what language you are using, I'll start by saying use C, because you then get to work with gtk and postgresql the "right" way. That being said, if you want something easier I would go with Python.
-The only way to truly have the exact same code on both linux and windows would be to use an interpreted language like python. (which is great for cross platform and junior programmer use - depending on were you are coming from). That being said, you can certainly do it in C with gtk and postgres. The issue is that you end up using #ifdef macros to have some different code for different platforms. By and large you can do what you want by having different Make files for the different platforms, or using a dynamic build system.
-I would recommend using the native postgresql library, libpq.-The next thing to think about is what programming model to use - synchronous, threaded, or asynchronous for the database side. If you go with libpq then you can pick asynchronous, which fits in with gtk paradigms nicely. Also that might be the only way to go for cross platform unless you don't mind UI freezes that wait for network operations. What you will end up with is a g_io_channel that feeds PQconsumeInput().
Date: Tue, 22 Jul 2008 21:44:27 +0800 From: paragasu <paragasu gmail com> Subject: developing postgresql app using gtk i am very new to gtk programming. still struggling to learn how to develop program using gtk. i am using debian linux workstation. but i have to develop gtk program that run in windows. is it possible to develop gtk in linux and later on run on windows without any code modification? i search all over the internet for tutorial about developing gtk application that connect to postgresql database. To my disappointment, i found none. can somebody point me any information about this? thank you..