mysql or postgresql for Ubuntu + Java trading system?

Lost User

I am building a trading system and seem like other than C++, Java + Ubuntu is the ideal choice. I have no idea which one is a better open source database for speed and stability. Any idea?

Rutvik Dave

MySql and Postgre are both very good choice. If your database is going to be less than 10 GB then you might want to consider Oracle Express edition. But instead of Ubuntu I would suggest CentOS. Because it's a free version of RHEL, you will find much more help/tutorials/guidance/product support for CentOS than Ubuntu. Every single Product Configuration Guide or Tutorial for RHEL will automatically apply to CentOS.

Remind Me This - Manage, Collaborate and Execute your Project in the Cloud

Matthew Faithfull

When deciding between MySQL or Postgresql look at the granularity of your data. Postressql is designed for big lumps of data like astronomy images or video streams, MySQL for small lumps of data like account information. Both will likely work but the thinking behind each is different and this will be reflected in performance and ease of use.

"The secret of happiness is freedom, and the secret of freedom, courage." Thucydides (B.C. 460-400)

Lost User

my data would be many small size data like a column of "open price", another column of "highest price of that day", something like that.

Bernhard Hiller

Also consider the operations to be performed on the database. If it's only create-retrieve-update-delete, MySQL will cope with lots of data. But when you want to do some reporting, MySQL becomes too slow early. And for more complicated reports based on several joined subqueries, also Postgres won't do the job - Oracle can handle that (but otherwise Oracle is quite a PITA).