Database abstration layers

Started by Jean-Michel POUREalmost 24 years ago6 messages
#1Jean-Michel POURE
jm.poure@freesurf.fr

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

#2Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: Jean-Michel POURE (#1)
Re: Database abstration layers

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

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Jean-Michel POURE (#1)
Re: Database abstration layers

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

#4Jean-Michel POURE
jm.poure@freesurf.fr
In reply to: Peter Eisentraut (#3)
Re: Database abstration layers

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

#5Matthew T. O'Connor
matthew@zeut.net
In reply to: Jean-Michel POURE (#1)
Re: Database abstration layers

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

#6Andrew McMillan
andrew@catalyst.net.nz
In reply to: Jean-Michel POURE (#1)
Re: Database abstration layers

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?