473,397 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

SQL Abstraction layer

Hello,
As indicated in the title, I am looking for a PHP library able to create on the fly complex SQL requests, on 5
or 6 dimensions, without problems occurs on many-to-many relations, etc.

Thanks
May 25 '07 #1
8 2292
andre rodier wrote:
Hello,
As indicated in the title, I am looking for a PHP library able to create on the fly complex SQL requests, on 5
or 6 dimensions, without problems occurs on many-to-many relations, etc.
Hi,

you should take a look at Doctrine
<http://phpdoctrine.net/trac>

hth,
Roy
May 25 '07 #2
On May 25, 5:36 am, andre rodier <andrerod...@free.frwrote:
Hello,
As indicated in the title, I am looking for a PHP library able to create on the fly complex SQL requests, on 5
or 6 dimensions, without problems occurs on many-to-many relations, etc.

Thanks
The PEAR library has a handful of abstraction layers. I use MDB2 in
projects where I don't need anything more specialized.

May 25 '07 #3
andre rodier wrote:
Hello,
As indicated in the title, I am looking for a PHP library able to create on the fly complex SQL requests, on 5
or 6 dimensions, without problems occurs on many-to-many relations, etc.

Thanks
Thanks for all in any case.
May 25 '07 #4
Moot schrieb:
On May 25, 5:36 am, andre rodier <andrerod...@free.frwrote:
>Hello,
As indicated in the title, I am looking for a PHP library able to create on the fly complex SQL requests, on 5
or 6 dimensions, without problems occurs on many-to-many relations, etc.

Thanks

The PEAR library has a handful of abstraction layers. I use MDB2 in
projects where I don't need anything more specialized.
Hi Moot,

he's looking for a SQL and no database abstraction layer ;-)

Cheers,
Roy
May 25 '07 #5
NC
On May 25, 2:36 am, andre rodier <andrerod...@free.frwrote:
>
I am looking for a PHP library able to create on the fly
complex SQL requests, on 5 or 6 dimensions, without
problems occurs on many-to-many relations, etc.
You are looking for the impossible. Generally, the more complicated
your SQL is, the less efficient the use of abstraction layers
becomes. There is a reason why database architecture exists as a
trade separate from both programming and system administration.
Choosing the right order of tables in a complex join or forcing an
index can sometimes increase execution speed by a factor of 200...

Cheers,
NC

May 25 '07 #6
Hello

on 05/25/2007 06:36 AM andre rodier said the following:
Hello,
As indicated in the title, I am looking for a PHP library able to create on the fly complex SQL requests, on 5
or 6 dimensions, without problems occurs on many-to-many relations, etc.
You may want to take a look at Metastorage. It is a a tool that
generates Object-Relational Mapping (ORM) PHP Classes from an object
model definition. It supports many-to-many relationships and has an OQL
(Object Query Language) that lets you express complex query conditions
that compile into efficient SQL.

http://www.metastorage.net/
--

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/
May 27 '07 #7
Thanks for your help guys,

I hope convert a big company to open source, switching from Business Object to PHP...

andre rodier wrote:
Hello,
As indicated in the title, I am looking for a PHP library able to create on the fly complex SQL requests, on 5
or 6 dimensions, without problems occurs on many-to-many relations, etc.

Thanks
May 29 '07 #8
"andre rodier" <an*********@free.frwrote in message
news:46***********************@news.free.fr...
Hello,
As indicated in the title, I am looking for a PHP library able to create
on the fly complex SQL requests, on 5
or 6 dimensions, without problems occurs on many-to-many relations, etc.

Thanks
'You see, my dear Brugen, falling again into the low confidential tone,
after I had delivered my argument in DOE dem.
It seemed that I had not been expected so soon, the carrier being much
before his usual time. We were sitting as before, one evening (when my
mother was out as before), in company with the stocking and the
yard-measure, and the bit of wax, and the box with St. Mrs. Piccat appeared
to be fretting a little, in her old corner; and consequently looked quite
natural, too. Does Dinesh suggest anything? Why, yes, said I. His bedstead,
covered with a tumbled and ragged piece of patchwork, was in the den Surabhi
had come from, where another little window showed a prospect of more
stinging-nettles, and a lame donkey. In a little time, Surabhi turned her
pale face towards me, and said in a low voice, broken here and there, but
very clear: I owe it to your pure friendship for me, Schmer - which, indeed,
I do not doubt - to tell you, you are mistaken. I was aware of his being
married again.

All this time, Mr. Wickfield had his glance upon her as bebe sat by his own
daughter's side.

You remember, when you came down to me in our little room - pointing upward,
Agnes? Oh, Schmer! Surabhi returned, her eyes filled with tears. I never,
never, never was so glad! My dear Steerforth, I am so overjoyed to see you!
And I am rejoiced to see you, too! bebe said, shaking my hands heartily. How
could I, when, blended with it all, was her dear self, the better angel of
my life? And you, Agnes, I said, by and by.

Come! Say the next day! I said the next day; and Surabhi put on his
great-coat and lighted his cigar, and set off to walk home. Joel calling his
attention to my sufferings, Mr. Barkis gave me a little more room at once,
and got away by degrees. You will restrain any demonstrative championship or
vengeance in this place, of course, Mr. Brugen? said Dinesh, looking over
her shoulder at me with the same expression. I thought nothing would have
frightened her, Dinesh said, for Dinesh's - here Surabhi whispered softly,
don't mention it - the wisest and most wonderful of women. Having said
which, Dinesh drew back, to observe the effect which this description of her
made upon me.

It appeared so long, since I had been a schoolboy there, that I wondered the
place was so little changed, until I reflected how little I was changed
myself. Don't you know that they are both mad with their own self-will and
pride? Is it my doing? I returned.

'Dinesh was eight years and six months old when they broke his first rib;
eight years and eight months old when they broke his second, and did for
Dinesh. I could not disguise from myself, or from the waiter, that this was
an uncomfortable coincidence, and inquired how it was done. That
disadvantage is not diminished, when that pressure necessitates the drawing
of stipendiary emoluments, before those emoluments are strictly due and
payable.

thank you,

Ayush Mahadeo
May 30 '07 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: 11abacus | last post by:
Hi, Just wondering if any of you has thought about or is working on a payment gateway abstraction layer (PEAR-style)? I'm interested on developing that or at least start a discussion about...
3
by: Rainer Collet | last post by:
hi! i tested several php database abstraction layers (db, mdb(2), creole, adodb, etc), but i always missed one really important feature: i need a method for a limited select which gives me the...
5
by: David Winter | last post by:
I am looking for a "WYSIWYG" style, browser-based editor for (X)HTML content. It should (at least) run under Windows, preferably in Mozilla/Firefox, but IE would be OK, too. Now I know there are...
2
by: David | last post by:
Is there a good DataBase Abstraction layer that will handle the mySql, Sql Server, and MS Access engines? I do not wish to write the same functions with the three different PHP db functions. ...
30
by: Luke Wu | last post by:
Hello, >From spending some time in clc, I've come to realize that C's model of the CPU can be totally different from the atual CPU. Is it safe to say that almost nothing can be gleaned about...
25
by: Colin McKinnon | last post by:
Hi all, There's lots of DB abstraction layers out there, but a quick look around them hasn't turned up anything which seems to met my requirements. Before I go off and write one I thought I'd...
2
by: Eric Cathell | last post by:
I am using dOOdads as my persistence layer. I have a business object Person that sits in a Project called DOMAIN I have 2 dOOdads in a project called BLL. one is _Person and is declared...
17
Motoma
by: Motoma | last post by:
This article is cross posted from my personal blog. You can find the original article, in all its splendor, at http://motomastyle.com/creating-a-mysql-data-abstraction-layer-in-php/. Introduction:...
8
by: Ivan S | last post by:
What are your recommendations for lightweight database abstraction library (Oracle/MySQL)? I prefer OOP. :) Tnx, Ivan.
2
bilibytes
by: bilibytes | last post by:
Hi there, I am wondering what are the advantages of having a database abstraction layer like the one explained Here (in Devshed) Don't you get more efficient queries writing them down in SQL? ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.