4 ms·

I worked with SQL Server, Oracle, MySQL and many other DBMSes. Nothing can beat PostgreSQL. Oracle's SQL Developer is the worst IDE for databases I ever seen.

I worked with SQL Server, Oracle, MySQL and many other DBMSes. Nothing can beat PostgreSQL. Oracle's SQL Developer is the worst IDE for databases I ever seen. Oracle DB doesn't support "TOP N" or "LIMIT N" notations and many other useful features... I like SQL Server more than Oracle and Microsoft provides 2 good IDEs for it (SQL Management Studio and Azure Data Studio). But it has some bad limitations - you can't define ON ... CASCADE on more than one path. You also can't create CTEs with inserts/updates. PostgreSQL doesn't have a good IDE out of the box. I heard that Azure Data Studio now support it, but didn't try it yet, because I already paid for a commercial IDE that supports PostgreSQL. PostgreSQL also doesn't have a good high availability tooling, but all major cloud providers do this for you. Considering that you get it for free, it is a much better choice than Oracle or SQL Server.

NDizzle 6y ago
Devart makes good SQL IDEs. They came out with one for Postgres ... recently? In the last year or two. If it's similar quality to their mysql ide, I'd recommend it. https://www.devart.com/dbforge/postgresql/studio/ https://www.devart.com/dbforge/postgresql/studio/
- deleted 6y ago
  [deleted]
bdcravens 6y ago
Working with the big 3 on a regular basis, DataGrip is the best tool I've found. (It lacks some management features, but it's been years since I needed those)
- pimeys 6y ago
  I'm working with many SQL Server, MySQL, PostgreSQL, SQLite and soon Mongo versions daily, and I have to say Datagrip is worth it's price tag easily. It is the only non-open tool I work with because it really makes work with multiple databases a lot easier.
katnegermis 6y ago
I really love using dbeaver[1] as a Postgres IDE. It requires a small bit of configuration for me to use it (why are the defaults to automatically lowercase all of my SQL?!). Other than that it's excellent! [1]: https://dbeaver.io/ https://dbeaver.io/
- Quarrelsome 6y ago
  because fuck the shift key. RSI sufferers unite! but in all seriousness, I don't know.
- dragonwriter 6y ago
  > why are the defaults to automatically lowercase all of my SQL? Because yelling at the database server doesn't make it work better, and just makes uglier code.
  - rbanffy 6y ago
    Uppercasing keywords makes it easier to read the code. Apple's Pascal tooling did that, IIRC.
  - e12e 6y ago
    It's a surprising default - for better or worse history made the convention that SQL KEYWORDS be uppercase (when pretty printed). I assume it stems from case being irrelevant and a time of green screens and monochrome printouts - but it's still the most common formatting/presentation of sql?
iamAtom 6y ago
Intellij have amazing extensions for database.
dragonwriter 6y ago
> Oracle DB doesn't support "TOP N" or "LIMIT N" notations and many other useful features... Instead of those nonstandard notations Oracle supports SQL-standard notation OFFSET and FETCH clauses (Postgres supports both LIMIT/OFFSET and OFFSET/FETCH, but not TOP.) OFFSET/FETCH is, IIRC, slightly more powerful than the nonstandard ones.
sergioramos 6y ago
You should try Postico https://eggerapps.at/postico/ https://eggerapps.at/postico/
- e12e 6y ago
  ... If you're running Mac os.

NDizzle 6y ago

Devart makes good SQL IDEs. They came out with one for Postgres ... recently? In the last year or two. If it's similar quality to their mysql ide, I'd recommend it. https://www.devart.com/dbforge/postgresql/studio/ https://www.devart.com/dbforge/postgresql/studio/

deleted 6y ago
[deleted]

bdcravens 6y ago

Working with the big 3 on a regular basis, DataGrip is the best tool I've found. (It lacks some management features, but it's been years since I needed those)

pimeys 6y ago
I'm working with many SQL Server, MySQL, PostgreSQL, SQLite and soon Mongo versions daily, and I have to say Datagrip is worth it's price tag easily. It is the only non-open tool I work with because it really makes work with multiple databases a lot easier.

katnegermis 6y ago

I really love using dbeaver[1] as a Postgres IDE. It requires a small bit of configuration for me to use it (why are the defaults to automatically lowercase all of my SQL?!). Other than that it's excellent! [1]: https://dbeaver.io/ https://dbeaver.io/

Quarrelsome 6y ago
because fuck the shift key. RSI sufferers unite! but in all seriousness, I don't know.
dragonwriter 6y ago
> why are the defaults to automatically lowercase all of my SQL? Because yelling at the database server doesn't make it work better, and just makes uglier code.
- rbanffy 6y ago
  Uppercasing keywords makes it easier to read the code. Apple's Pascal tooling did that, IIRC.
- e12e 6y ago
  It's a surprising default - for better or worse history made the convention that SQL KEYWORDS be uppercase (when pretty printed). I assume it stems from case being irrelevant and a time of green screens and monochrome printouts - but it's still the most common formatting/presentation of sql?

iamAtom 6y ago

Intellij have amazing extensions for database.

dragonwriter 6y ago

> Oracle DB doesn't support "TOP N" or "LIMIT N" notations and many other useful features... Instead of those nonstandard notations Oracle supports SQL-standard notation OFFSET and FETCH clauses (Postgres supports both LIMIT/OFFSET and OFFSET/FETCH, but not TOP.) OFFSET/FETCH is, IIRC, slightly more powerful than the nonstandard ones.

sergioramos 6y ago

You should try Postico https://eggerapps.at/postico/ https://eggerapps.at/postico/

e12e 6y ago
... If you're running Mac os.