I love both but don't know witch to use for my project!
I've already made the decision not to use MySQL but I also don't want to be locked when migrating out of AWS if I ever need to when using DynamoDB. Using PostgreSQL could potentially be more expensive in the start if I use AWS RDS!
A solution might be to have a LightSail or EC2 instance run both PostgreSQL and the application, but is this a good idea?
What do you think?
Discussion (1)
I think I'm leaning towards the PostgreSQL option, I've seen an article that PostgreSQL is fast on writes and slower on reads, is this true? If so how slow is it?