Thread: Database abstration layers

Database abstration layers

From
Jean-Michel POURE
Date:
Dear all,

I am looking at available database abstraction layers with the idea of 
porting pgAdmin2 to Linux. This is just for information, my project is not 
clear by now.

GnomeDB (http://www.gnome-db.org) seems quite fantastic when used in 
conjunction with Glade. Until now, I never heard of any abstraction layer 
under KDE. Is there any?

By the way, I looked at KDE TOra, which seems very Oracle centric. TOra seems 
to be built upon database wrappers, not abstraction layer classes. Am I wrong?

What is the best database abstraction under Linux ? Any idea, suggestion, 
etc.. are welcome. 

Best regards,
Jean-Michel POURE


Re: Database abstration layers

From
Peter Eisentraut
Date:
Jean-Michel POURE writes:

> Until now, I never heard of any abstraction layer under KDE. Is there
> any?

It's built into Qt.

-- 
Peter Eisentraut   peter_e@gmx.net



Re: Database abstration layers

From
Christopher Kings-Lynne
Date:
> GnomeDB (http://www.gnome-db.org) seems quite fantastic when used in
> conjunction with Glade. Until now, I never heard of any abstraction layer
> under KDE. Is there any?

QT3, which KDE3 uses, has database objects with postgresql support...

Chris




Re: Database abstration layers

From
Jean-Michel POURE
Date:
Le Vendredi 8 Février 2002 18:13, Peter Eisentraut a écrit :
> > Until now, I never heard of any abstraction layer under KDE. Is there
> > any?
>
> It's built into Qt.

I am looking for an abstraction layer which gives access to all database 
objects (tables, views, triggers, functions, rules). As far as I know, 
Gnome-db and libgda provide shuch a framework.

Cheers,
Jean-Michel POURE


Re: Database abstration layers

From
"Matthew T. O'Connor"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Friday 08 February 2002 10:23 am, Jean-Michel POURE wrote:
> Dear all,
>
> I am looking at available database abstraction layers with the idea of
> porting pgAdmin2 to Linux. This is just for information, my project is not
> clear by now.

what is your goal?  

If it's to port pgAdmin2 to Linux, then why do you need a database 
abstraction layer?  Why not use direct calls to postgres?  Most language have 
native support (C, C++, PHP, Python, Perl...)   Is it not true that pgAdmin 
under windows has some limitations due to the fact that it's usind ODBC?

If it's to write a generic database management tool that can be used against 
different databases then the need for an abstraction layer is obvious.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8ZCKG8BXvT14W9HARAoiHAJ9eJIsynNIc6GJ01NqlSN+R5v4AiACcCcUa
cu4e5Lyd3K0c85vTAZ+2Q/o=
=XwtN
-----END PGP SIGNATURE-----


Re: Database abstration layers

From
Andrew McMillan
Date:
On Sat, 2002-02-09 at 05:23, Jean-Michel POURE wrote:
> Dear all,
> 
> I am looking at available database abstraction layers with the idea of 
> porting pgAdmin2 to Linux. This is just for information, my project is not 
> clear by now.
> 
> GnomeDB (http://www.gnome-db.org) seems quite fantastic when used in 
> conjunction with Glade. Until now, I never heard of any abstraction layer 
> under KDE. Is there any?
> 
> By the way, I looked at KDE TOra, which seems very Oracle centric. TOra seems 
> to be built upon database wrappers, not abstraction layer classes. Am I wrong?
> 
> What is the best database abstraction under Linux ? Any idea, suggestion, 
> etc.. are welcome. 

Since pgAdmin2 already uses ODBC, would it not be best to leave that
alone and just use ODBC in a Linux port as well?

The ODBC in pgAdmin2 is a good help in porting to PostgreSQL from other
databases, but no doubt it has it's drawbacks.  On the other hand if it
is already existing, and should work 'as-is' then perhaps it would save
a lot of work to leave it alone.

Regards,                Andrew.
-- 
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/        PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201    MOB: +64(21)635-694    OFFICE: +64(4)499-2267      Are you enrolled at
http://schoolreunions.co.nz/yet?