Re: gtk-app-devel-list Digest, Vol 51, Issue 31

[Thomas Stover <thomas wsinnovations com>]

Although I haven't written a postgresql app myself, it is something that 
I have almost had to do several times. Here are some thoughts to help 
you get started:

-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..
>