First time here? Check out the FAQ!
2

Which is a better database to use for Askbot, PostgreSQL or MySQL, and why?

Also, is it an easy enough process to transfer between the two?

ZakGottlieb's avatar
45
ZakGottlieb
asked 2011-02-10 18:55:14 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

1

PostgresQL is better because it supports transactions and full text search at the same time.

MySQL does not support both at once. MySQL has a few choices of data storage backends - and none of the backends supports those two things at simultaneously.

Postgres has very deep support of full text searching - including word stemming, thesaurus matching, ranking, etc.

Transactions help to keep data internally consistent and avoid race conditions - when two or more users read and write data simultaneously.

P.S. This site still runs or MySQL, my bad. If you use Postgres, the only visible change will be "sort by relevance" option in the question list, that will appear when some search term is typed. MySQL does not have ranking, so no such option.

Evgeny's avatar
13.2k
Evgeny
updated 2011-02-10 19:12:23 -0500, answered 2011-02-10 19:07:30 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments