4 ms·

Doing application programming in Dynamodb is a nightmare.

• gnulinux 4y ago
  I personally found DynamoDB enjoyable but the trick is you need to understand DynamoDB gives you exactly no way to have analytics, so you have to have a separate and robust story for analytics e.g. we periodically dump our DynamoDB into a RedshiftDB so we get best of the both worlds. I personally find it enjoyable to program, and had a better experience than when everything was Postgres.
  • rmbyrro 4y ago
    Same experience. From an OLTP standpoint, the limitations to query the data are actually amazing, because it forces you to think about the right questions from the beginning. On more flexible DBMS like Postgres, it's very very easy to shoot yourself in the foot. I find it easier to understand and take into consideration the DynamoBD constraints (explicit) than SQL shortcomings (implicit).
    • Scarbutt 4y ago
      because it forces you to think about the right questions from the beginning. For many apps thinking that you can have the right questions from the beginning is delusional.
      • gnulinux 4y ago
        > For many apps thinking that you can have the right questions from the beginning is delusional. Strong disagree, I think you might be approaching this from a traditional angle where analytics questions are also questions of the system. In DynamoDB you only focus on access patterns you need for system to work real-time, without bothering with analytics (as stated above). Any question you want to ask on data outside of the operational code is out of the scope.