Postgresql with QCubed
Wed, 12/17/2008 - 19:52
Hey all,
I would like to start a new system from scratch and I would like to use Postgresql as the database. I haven't used Qcubed/Qcodo with Postgresql. Is the adapter for Postgresql working ok? Any feedback/suggestions ?
Cheers,
Marcos

I use Postgres exclusively with Qcodo, and it seems good.
The only caveats I know of:
* Timestamp with time zone type is not recognized (though this is pretty easy to add)
* ILIKE is not available as a QQ::Condition (though again, it's easily added)
* And as mentioned on this forum, ARRAY types are not supported
James
Oops, double reply.
Comment posting seems to be extremely slow right now...
Sorry to "resurrect" a rather old thread. I just would like to follow on whatever was already discussed.
Is there anyone in this community who has developed systems based on QCubed/Qcodo with a PostgreSQL backend?
Thank you.
Roslen
Hello Roslen,
I am using QCubed with Postgres. There are some issues but I coudl provide workarounds for the ones I have encountred:
- Grouping in selects is an issue
- data type ARRAY, bytea is not supported
- The adapter does not support schemas
for the first two tickets do exists and solutions might be built in to the next QCubed version.
Cheers
Helge