3 ms·
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
by Findeton 6y ago
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 6y agoI'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 6y agoDo 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.