Connecting Tech Pros Worldwide Forums | Help | Site Map

Database abstraction library

Ivan S
Guest
 
Posts: n/a
#1: Jul 16 '08
What are your recommendations for lightweight database abstraction
library (Oracle/MySQL)?


I prefer OOP. :)



Tnx, Ivan.

NC
Guest
 
Posts: n/a
#2: Jul 16 '08

re: Database abstraction library


On Jul 16, 1:56 am, Ivan S <ivan.sku...@gmail.comwrote:
Quote:
>
What are your recommendations for lightweight database
abstraction library (Oracle/MySQL)?
You are looking for the impossible. "Lightweight abstraction" is a
contradiction in terms...

Cheers,
NC
sathyashrayan
Guest
 
Posts: n/a
#3: Jul 16 '08

re: Database abstraction library



"Ivan S" <ivan.skugor@gmail.comwrote in message
news:5ae6f85c-4a96-4013-b036-67051dfe8ae9@k37g2000hsf.googlegroups.com...
Quote:
What are your recommendations for lightweight database abstraction
library (Oracle/MySQL)?
>
>
I prefer OOP. :)
>
>
>
I don't know what is ment by "lightweight database abstraction". But this
link is worth reading http://aphp.yasashiisyndicate.org/wiki/ActiveTable it
uses oops. An example implementation is http://modulargaming.com/


Ivan S
Guest
 
Posts: n/a
#4: Jul 16 '08

re: Database abstraction library


On 16 srp, 11:17, NC <n...@iname.comwrote:
Quote:
On Jul 16, 1:56 am, Ivan S <ivan.sku...@gmail.comwrote:
>
>
>
Quote:
What are your recommendations for lightweight database
abstraction library (Oracle/MySQL)?
>
You are looking for the impossible. *"Lightweight abstraction" is a
contradiction in terms...
>
Cheers,
NC
I don't need huge level of abstraction, I just need little and fast
library that support some common functionality for Oracle (or MySql)
database.


Hope that clears possible language barrier. :)
Ivan S
Guest
 
Posts: n/a
#5: Jul 16 '08

re: Database abstraction library


On 16 srp, 12:28, "sathyashrayan" <sathyashra...@ATGmaIl.comwrote:
Quote:
"Ivan S" <ivan.sku...@gmail.comwrote in message
>
news:5ae6f85c-4a96-4013-b036-67051dfe8ae9@k37g2000hsf.googlegroups.com...What are your recommendations for lightweight database abstraction
Quote:
library (Oracle/MySQL)?
>
Quote:
I prefer OOP. :)
>
I don't know what is ment by "lightweight database abstraction".
Maybe "lightweight library for database abstraction layer" sounds
better...
Quote:
But this
link is worth readinghttp://aphp.yasashiisyndicate.org/wiki/ActiveTableit
uses oops. An example implementation ishttp://modulargaming.com/
Thanks for your help.
Erwin Moller
Guest
 
Posts: n/a
#6: Jul 16 '08

re: Database abstraction library


Ivan S schreef:
Quote:
What are your recommendations for lightweight database abstraction
library (Oracle/MySQL)?
>
>
I prefer OOP. :)
>
>
>
Tnx, Ivan.
Have a look at ADODB (yes it is PHP).
http://www.phplens.com/adodb

Regards,
Erwin Moller
Jerry Stuckle
Guest
 
Posts: n/a
#7: Jul 16 '08

re: Database abstraction library


Ivan S wrote:
Quote:
What are your recommendations for lightweight database abstraction
library (Oracle/MySQL)?
>
>
I prefer OOP. :)
>
>
>
Tnx, Ivan.
>
Ivan,

I created my own abstraction layer before PDO got going. Nothing fancy,
and much faster. Effectively it's a base class with mostly abstract
members and a derived class for each database I've used.

It's not elegant and it doesn't contain all of the bells and whistles of
PDO, but it works for me. And it didn't take that long to create it
(although I've added to it over the years).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

NC
Guest
 
Posts: n/a
#8: Jul 16 '08

re: Database abstraction library


On Jul 16, 3:39 am, Ivan S <ivan.sku...@gmail.comwrote:
Quote:
>
Quote:
"Lightweight abstraction" is a contradiction in terms...
>
I don't need huge level of abstraction, I just need little
and fast library that support some common functionality for
Oracle (or MySql) database.
Again, it's not possible, because abstraction can't be fast. Once you
decided to use abstraction, you must accept a performance penalty.
The extent of that penalty varies depending on the abstraction layer
used and on the type of query run. In benchmark tests, popular
abstraction layers increase execution times by anywhere between 15%
and 300%:

http://phplens.com/lens/adodb/

Cheers,
NC
Satya
Guest
 
Posts: n/a
#9: Jul 17 '08

re: Database abstraction library


On Jul 16, 3:56*pm, Erwin Moller
<Since_humans_read_this_I_am_spammed_too_m...@spam yourself.comwrote:
Quote:
Ivan S schreef:
>
Quote:
What are your recommendations for lightweight database abstraction
library (Oracle/MySQL)?
>
Quote:
I prefer OOP. :)
>
Quote:
Tnx, Ivan.
>
Have a look at ADODB (yes it is PHP).http://www.phplens.com/adodb
>
Regards,
Erwin Moller
I will prefer Db.php from pear. It is very commonly used for this job.

http://satya61229.blogspot.com
Closed Thread