Hello, is anybody using PostgreSQL as backend?
In our evaluation process we found some limitations using mysql which postgresql seems not to suffer (limited number of index for instance).
Can you please share your opinion/experience if any?
The only person which seems to use PostgreSQL is Bob Cart see [autocommit issue PostgreSQL 7.4 - Classic Servoy - Servoy Community].
And as a generic question, do you (Servoy Team) have a statistic on backend usage among the servoy community?
In advance, thank you for helping us make the good choice.
We’re using PostgreSQL as a backend database to house our borehole and well information - the server runs very well on a G4 Mac under OS X. We are currently using v 7.3 but are planning to upgrade one of these days. Our choice of PostgreSQL over MySQL was the ability to add geospatial extensions through PostGIS (PostgreSQL also has its own geometry data types as well), plus the capability of backend trigger functions and the ability to handle subselects.
The database works fine with Servoy. One problem, however, is that Servoy does not handle the PostgreSQL boolean data type - it converts it to integer which causes an SQL error when you try to display or edit a boolean field in a form. You can get around this by using integer fields in PostgreSQL instead, but in our case we rely on booleans in other parts of our application so our workaround is kludgy and limited. Hopefully Servoy will correct this problem soon.
Thank you for your kind and informative answer.
We are now in the process of testing several backends with servoy, using a subset of our solution already translated to servoy.
