Ask Your Question
2

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

asked 2011-02-10 18:55:14 -0600

ZakGottlieb gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2011-02-10 19:07:30 -0600

Evgeny gravatar image

updated 2011-02-10 19:12:23 -0600

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.

edit flag offensive delete link more

Your Answer

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

Add Answer

Question Tools

Stats

Asked: 2011-02-10 18:55:14 -0600

Seen: 232 times

Last updated: Feb 10 '11