PostgreSQL support #44
Description
At #36 @robinson-rso raised an interesting question, can we handle schemas.
@tuliobraga raised #40 there are problems with lastInsertId.
This made me realise that I have never tested this against postgres as a matter of fact I don't even have a php instance compiled --with-pdo-pgsql. Postgres has always been the rock solid alternative but they've really stepped up their game as far as ease of installation and accessibility is concerned. This is not something to take lightly if we care at all about this project.
These are some actions actions we can take to remedy this:
- Run unit tests against PostgreSQL and publish the results
- Investigate if travis is capable and update config to test against PostgreSQL and others
- Extend test cases to scrutinise PostgreSQL specific problems where required
- Identify additional features perhaps unique to PostgreSQL and discuss their possible inclusion
I urge everyone with PostgreSQL capabilities to please help out with this issue, run the tests and submit the results.
@Respect can we treat this with the highest priority.