[Findeton]

I work at a startup, we are 6 engineers, 2 of us are back-end engineers. I use PostgreSQL everyday. We tried using an ORM, and creating our own ORM, but it wasn't worth it for us. When you are dealing with medium-large databases, you're going to want to use indexes, to do custom queries with joins etc and it's just not worth it trying to use ORMs.

[ahpearce]

I've found Hibernate within Spring has been fairly easy to use and adapt. Pretty easy to just add @Query(<native query>) to a method if you really need to drop into your own SQL. It also generates schemas and with something like Liquibase or Flyway, you can manage the migrations pretty easily as well.

[ElCapitanMarkla]

Do you have a decent GUI client you use? It’s always something I’ve found a complete hassle when working with Postgres over MySQL. I usually use SequelPro on Mac and Heidi on my Windows machine.