Ask Your Question

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

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

ZakGottlieb's avatar

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

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

Evgeny's avatar

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

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


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

Seen: 346 times

Last updated: Feb 10 '11