From: Krabina Bernhard <krabina@kd...> - 2013-05-07 15:17:12
I am on a project with the Vienna City Administration using SMW for the first time. As their strategic choice for databases is PostgreSQL (not MySQL) the might consider testing SMW on their environment (RedHat 6 Enterprise, PostgreSQL 9.1.6).
Unfortunately, I just read that the PostgreSQL support seems to be broken altogehter:
Can anyone help us out? Does the patch work? Is the database problem something you can fix during installation or are more problems to be expected once you are running SMW? What is the reason for the broken PostgreSQL support?
As I don't think it is a good idea to do the project with SMW 1.7.1 it would be important to get some more insight and community support in order to get this working again.
What were your experiences with PostgreSQL support in earlier SMW versions?
From: Jeroen De Dauw <jeroendedauw@gm...> - 2013-05-07 17:07:20
I would not run with PostgreSQL until there is decent support for this on
smw master AND there are tests on our CI system to ensure things don't
break. Right now support for this is very flaky and fixing some random
errors is not going to fix that. If you really want to run on PostgreSQL,
the best thing to do is probably throw some dev resources at getting
PostgreSQL fixed in SMW itself (not just the code you have checked out).
Once the main issues are fixed and this is probably integrated in our CI,
we can easily maintain it and then it ought to not break in the next
release (as has happened in the past).
I spend some time doing exactly that for SQLite, for which we now have full
support. PostgreSQL might however be a bit more tricky.
Jeroen De Dauw
Don't panic. Don't be evil.