Ask Your Question
0

PostgreSQL vs MySQL - Which is better for Askbot?

asked 2012-06-02 06:10:42 -0600

naavi gravatar image

updated 2012-06-02 14:46:06 -0600

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?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2012-06-02 14:49:18 -0600

Evgeny gravatar image

updated 2012-06-02 14:49:33 -0600

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.

edit flag offensive delete link more

Comments

Thanks. To be true, I didn't get "transactions" and "full text search". If I go ahead with MYSQL, the realtime search feature of Askbot is not going to work? May I know the consequences of using the one over another?

naavi gravatar imagenaavi ( 2012-06-02 14:52:30 -0600 )edit

No the search will work, but not as well. Also you will not have transaction support, which means that the data can more easily become inconsistent. We are planning to support Haystack - then you'll be able to use Solr and some other search engines and will then be able to use transactions in MySQL.

Evgeny gravatar imageEvgeny ( 2012-06-02 14:55:50 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2012-06-02 06:10:42 -0600

Seen: 469 times

Last updated: Jun 02 '12