Re: Connecting GTK application to a database

[Murray Cumming <murrayc murrayc com>]

On Wed, 2010-02-24 at 10:50 -0600, Daniel Espinosa wrote:
> Using GDA (www.gnome-db.org) based on GObject/GLib and its GTK+
> objects, you can develop applications using a C API to access any
> supported database backend (postgresql, mysql and sqlite, are some of
> them). Any application can run simple queries. Exist an application
> (on development) at
>
> http://library.gnome.org/devel/gda-browser/4.1/
>
> GDA manual is located at library.gnome.org.

I agree with this. Server-specific APIs are generally awful and there's
no advantage in tying yourself to a specific server unnecessarily.
libgda uses API conventions that are familiar to GTK+ developers and
makes changing the backend server fairly easy.

(Over the years we have changed Glom from using MySQL, to using
PostgreSQL, to optionally also using SQLite.)

> 2010/2/24 Mats Rauhala <mats rauhala gmail com>:
> > Database engines have their own API for connecting. Check the following
> > links. I recommend you start looking at the SQLite library, as in my
> > experience it has the most simplistic tutorial, which can help you get
> > up to speed with sql apis and concepts. Naturally there are differences
> > with different libraries, but I'm sure that as long as you understand
> > one, it helps tremendously on the others :).
> >
> > For postgres:
> > http://www.postgresql.org/docs/8.2/static/libpq.html
> >
> > For MySQL:
> > http://dev.mysql.com/doc/refman/5.0/en/c.html
> >
> > For SQLite:
> > http://www.sqlite.org/cintro.html
> >
> > --
> > Mats Rauhala
> > sip:MasseR ekiga net
> >
> > _______________________________________________
> > gtk-app-devel-list mailing list
> > gtk-app-devel-list gnome org
> > http://mail.gnome.org/mailman/listinfo/gtk-app-devel-list
>
>
>
> -- 
> Trabajar, la mejor arma para tu superaciÃn
> "de grano en grano, se hace la arena" (R) (en trÃmite, pero para los
> cuates: LIBRE)
> _______________________________________________
> gtk-app-devel-list mailing list
> gtk-app-devel-list gnome org
> http://mail.gnome.org/mailman/listinfo/gtk-app-devel-list


-- 
murrayc murrayc com
www.murrayc.com
www.openismus.com