Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product

Ready to contribute?

Amazing! Sign our contributors' agreement and then join us on GitHub.

Please upgrade to 2.1.x here. The 2.0 branch is no longer being updated.
Current version is 2.1.11, released 12 June.

Postgresql DB Driver

edited December 2011 in Vanilla 2.0 Help

Hi everyone, im a pretty savvy developer, however short on time. I'm looking for someone who has successfully used PostgreSQL for their vanilla forum. If you have done so please let me know as i would love to gain insight or get a copy of your files.

Many thanks!
Jon

Best Answer

  • ToddTodd Chief Product Officer Vanilla Staff
    Answer ✓

    We originally planned on making Vanilla work with multiple databases, but abandoned that path long ago. There are specific SQL queries in the code now and it would be very difficult to port to PostgeSQL.

Answers

  • ToddTodd Chief Product Officer Vanilla Staff
    Answer ✓

    We originally planned on making Vanilla work with multiple databases, but abandoned that path long ago. There are specific SQL queries in the code now and it would be very difficult to port to PostgeSQL.

  • FWIW, this is a shame, as when you are dealing with a very large amount of data MySQL's inability to handle schema changes without table locks makes migrations and upgrades painful at best and intractable at worst: projects like this should not be using MySQL. :(

Sign In or Register to comment.