Thread

1. Database abstration layers

   Jean-Michel POURE <jm.poure@freesurf.fr> — 2002-02-08T16:23:15Z

   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
   
   

2. Re: Database abstration layers

   Christopher Kings-Lynne <chriskl@familyhealth.com.au> — 2002-02-08T17:09:16Z

   > 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
   
   
   
   

3. Re: Database abstration layers

   Peter Eisentraut <peter_e@gmx.net> — 2002-02-08T17:13:22Z

   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
   
   
   

4. Re: Database abstration layers

   Jean-Michel POURE <jm.poure@freesurf.fr> — 2002-02-08T18:12:09Z

   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
   
   

5. Re: Database abstration layers

   Matthew T. O'Connor <matthew@zeut.net> — 2002-02-08T19:09:56Z

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

6. Re: Database abstration layers

   Andrew McMillan <andrew@catalyst.net.nz> — 2002-02-09T01:10:23Z

   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?