[rt-users] postgres vs mysql

Vivek Khera khera at kcilink.com
Wed Oct 9 12:21:37 EDT 2002


>>>>> "SC" == Simon Cozens <rt at netthink.co.uk> writes:

SC> Two major reasons:
SC>     1) Postgres is big, grand, and feature-complete. mysql is lightweight,
SC>     fast and does just enough SQL for RT to be happy.
SC>     2) Postgres can't handle embedded nulls in binary objects, so RT has to
SC>     muck about with base 64 encoding in some cases, which is slow.

If you've already got a postgres installation running, then use it.
There's no reason to add mysql to your maintanance issues in that
case.  If you're starting from scratch, then either one will do,
really.  Personally, I use postgres since that is our standard
database here.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/



More information about the rt-users mailing list