search

Respect / Relational

A fluent, intuitive ORM for any relational database engine
http://respect.github.io/Relational
Other
243 stars 32 forks source link

PostgreSQL Schema #36

Open robinson-rso opened 11 years ago

robinson-rso commented 11 years ago

Is Relational capable of dealing with PostgreSQL Schemas? I am not sure if I can map the schemas and tables properly. I have used variables instead methods to map schemas:

$vendor = 'og0001.vendor'; $array = $mapper->$vendor->fetchAll();

Will Relational support schemas?

Thanks!

nickl- commented 11 years ago

Relational uses PDO so anything that PDO supports should work as expected.

Please let us know what you find, I do know that it works on MySQL and Sqlite but haven't personally tested the rest.

robinson-rso commented 11 years ago

There are several databases that supports PDO, but there are some important differences between PostgreSQL and MySQL. Including the fact that PostgreSQL supports schemas (whereas MySQL uses separate database). Some ORMs like Doctrine for example, is capable of dealing with this.

https://groups.google.com/forum/#!topic/doctrine-user/qFid2rgRH-s

nickl- commented 11 years ago

AFAIK PDO does not make any special provisioning for PostgreSQL schemas and I would imagine that they are simply treated the same way as MySQL would for databases. That said I am not sure if we can do different databases or not?

We have not tested on postgres and I think we should also ensure that mapper works across multiple databases.

@robinson-rso thank you for pointing this out, please don't hesitate to bring more items under scrutiny. You may consider this a huge contribution. something we likely would not have considered on our own for a long time.

Thank you for your help!