I was tasked with re-writing a project that's build with jQuery (front-end), C#.NET (backend) and MS SQL Server (data storage).
I wanted to re-write in Go or Python/Django. What is a satisfactory data store to go with this? Note: It needs to be relational as there are monetary transactions involved.
Thanks
Either MySQL or PostGres will work just fine. I personally find MySQL to be more accessible if you're new to both storage engines, however they both will serve you well given the scope of the project you've described.
You will most likely get a different answer from most people you ask, however do know that they are functionally the same for any reasonable application where you are not specifically trying to leverage the performance of minute inner workings of the engines.
Whatever route you choose, I highly recommend using a datastore that supports transactions ( i.e. BEGIN... COMMIT... ROLLBACK...
) to ensure your reads and writes happen as you expect them to, and the data comes back out the way it looked going in. PostGres supports this by default I believe, while with MySQL, you'll want to specifically use the INNODB engine:
CREATE TABLE customers (
a INT,
b CHAR (20),
INDEX (a)
) ENGINE=InnoDB;
BEGIN;
INSERT INTO `customers`(`a`,`b`) VALUES(...)
COMMIT;