Do you use an ORM framework? What about a second-level distributed cache? Do you advise using PostGres instead of other databases like MySQL? If so, why?
Just a couple of notes:
- I'm asking about PostGres because I'm completely ignorant about it. I have experience in MySQL 5.1 and other databases like SQLServer and Oracle.
- In our solution, most of the content creation and timeline management will be fully automated. We expect to have significant read operations but also a heavy workload with write operations, namely in reprogramming the timelines. We have no idea regarding those workloads; I'm sure you have metrics from your experience with MediaHybrid (our solution will also be placed in AWS), if you can provide some overall idea it would be greatly appreciated.
- It seems clear a RDBMS is far more appropriate than a NoSQL database. However, we may find it interesting to use object serialization or something similar in very specific cases.
Thanks,
Joao Correlo
