Bye Bye Mongo, Hello Postgres

Re:Bye Bye Mongo, Hello Postgres by inferiorhuman on Wednesday December 19, 2018 @09:50PM (#18722118)

I can't speak to every ORM or database interface in existence but ActiveRecord will happily handle Postgres arrays and let you use the built-in array functions just handily without having to write queries by hand. Ecto is less elegant, but you can still finangle some arrays with it.

As far as views are concerned, I don't know what to tell you. Sure, you'll probably have to craft the view itself by hand. The result is that you can then use most abstractions of your choosing on top of it though.

[ Parent | on HN ]

Re:Bye Bye Mongo, Hello Postgres by bonesss on Thursday December 20, 2018 @07:08AM (#18724202)

There's also the possibility of using automation to create, update, and manage views. That lets your app be 'dynamic' with regards to new data and new datatypes, but also preserves the performance, debugging, segregation, and maintenance benefits of the underlying DB.

[ Parent | on HN ]