4 ms·
I work with about a 600 table 2 TB PostgreSQL database and I started to use DataGrip, when it was in beta, for constructing complex queries. It's quite good for
by gabriel 10y ago
I work with about a 600 table 2 TB PostgreSQL database and I started to use DataGrip, when it was in beta, for constructing complex queries. It's quite good for writing larger queries, but also taking auto-generated queries from an ORM and re-formatting them to help with debugging application behavior.
For db-specific operations I still use PostgreSQL's command-line client psql. It's an invaluable tool, but it's really nice to have options.
I also like the ability to pin query results so that I can quickly compare result sets in slightly-modified queries that I'm trying to fix.
Not so great at exploring the schema. Could be that I just didn't learn the tool enough to make that easier.
- bigtunacan 10y agoI'll second the exploring the schema bit. Overall I'm really impressed with JetBrains tools, in this case however not so much. Schema exploration is pretty critical in a database tool. While it is useful; it isn't able to replace other database tools I need so I've just continued working with my existing tools rather than adding yet another to the mix.
- Lord_Cheese 10y agoI found the SB Navigator plugin solved the weirdness of navigating a schema. I've been using DataGrip for Oracle and MySQL a lot lately and absolutely love it!