February 24, 2024, 11:13:49 AM
Welcome, Guest. Please login or register
News: Join us for a FREE Webinar this Thursday at http://webinar.digitalsignage.com

MediaSignage support forum

Author Topic: Data persistence layer  (Read 4529 times)


  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
Data persistence layer
« on: May 13, 2014, 10:48:36 AM »
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.

Joao Correlo
« Last Edit: May 13, 2014, 03:18:30 PM by joaocorrelo »


Carbonate design by Bloc
variant: carbon
SMF 2.0.12 | SMF © 2016, Simple Machines