I'm looking to install setup askbot for the first time on website indiabot.com and would like to settle down on the database to be used. Askbot recommends PostgreSQL and my system is already using MYSQL for drupal. Let me know why should I go ahead with one type keeping in view the resource usage and speed. Is it possible to migrate from one type of database to another in future?
PostgresQL is better. The most significant difference is that postgres supports transactions and full text search simultaneously, while MySQL does not.
We don't yet have working migration from one database type to another, but there is code for that on one of the forks on github.
Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.create your Q&A site
Asked: 2012-06-02 06:10:42 -0500
Seen: 195 times
Last updated: Jun 02 '12