SQL Abstraction layer

[andre rodier]

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

[Roy Kaldung]

Re: SQL Abstraction layer

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

[Moot]

Re: SQL Abstraction layer

On May 25, 5:36 am, andre rodier <andrerod...@fr ee.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.

[andre rodier]

Re: SQL Abstraction layer

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.

[Roy Kaldung]

Re: SQL Abstraction layer

Moot schrieb:

On May 25, 5:36 am, andre rodier <andrerod...@fr ee.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

[NC]

Re: SQL Abstraction layer

On May 25, 2:36 am, andre rodier <andrerod...@fr ee.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

[Manuel Lemos]

Re: SQL Abstraction layer

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/

[andre rodier]

Re: SQL Abstraction layer

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

[Ayush Mahadeo]

Re: SQL Abstraction layer

"andre rodier" <andrerodier@fr ee.frwrote in message
news:4656ae14$0 $14487$426a74cc @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