Postgresql with QCubed

Login or register to post comments
4 replies [Last post]
marcosdsanchez's picture
Offline
Joined: 03/31/2008

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

Offline
Joined: 11/07/2008

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

Offline
Joined: 11/07/2008

Oops, double reply.

Comment posting seems to be extremely slow right now...

Offline
Joined: 11/20/2009

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

Offline
Joined: 04/22/2009

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