Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by katnegermis on Friday February 12, 2021 @03:44PM
(#26118335)
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/
Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by dragonwriter on Friday February 12, 2021 @09:57PM
(#26120998)
> 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.
Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by e12e on Saturday February 13, 2021 @10:55AM
(#26124297)
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?
Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by rbanffy on Saturday February 13, 2021 @05:07AM
(#26122644)
Uppercasing keywords makes it easier to read the code. Apple's Pascal tooling did that, IIRC.
Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by Quarrelsome on Friday February 12, 2021 @04:39PM
(#26118868)
because fuck the shift key. RSI sufferers unite!
but in all seriousness, I don't know.
Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by bdcravens on Friday February 12, 2021 @01:16PM
(#26116668)
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)
Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by pimeys on Saturday February 13, 2021 @02:50AM
(#26122110)
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.
Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by dragonwriter on Friday February 12, 2021 @09:56PM
(#26120993)
> 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.
Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by NDizzle on Friday February 12, 2021 @12:11PM
(#26115886)
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.
Re:AWS Babelfish: The Elephant in the PostgreSQL Room?
by sergioramos on Saturday February 13, 2021 @04:57AM
(#26122597)
You should try Postico
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.