News for hackers. Stuff that matters.

A comment on “Fashion Is Hard. PostgreSQL Is Easy” [video]. Parent comment

Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by marcosdumay on Thursday June 18, 2015 @10:53AM (#9738877)
Count another vote for the pgadmin.

I hate the backslash commands of postgres, about as much as I hate the show commands of mysql (what's not nearly as much as I hate the oracle introspection tools).

Why couldn't SQL standardize database introspection?

[ Parent | on HN ]
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by baq on Thursday June 18, 2015 @11:01AM (#9738941)
it did.

https://en.wikipedia.org/wiki/Information_schema

[ Parent | on HN ]
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by marcosdumay on Thursday June 18, 2015 @08:41PM (#9742441)
I didn't know it was a standard, nor that it was widely supported.

Thanks.

[ Parent | on HN ]
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by WorldWideWayne on Thursday June 18, 2015 @11:10AM (#9739010)
This whole thread makes me happy to be a SQL Server user, where the UI tools are standard and robust.

90% of the time, I don't need to remember any special commands for introspecting and since it's on Windows - I can use the keyboard to navigate the entire UI with ease. When I write SQL, I get glorious Intellisense (that's autocomplete to you) for every single object (edit: and command) in the db.

[ Parent | on HN ]
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by kaolinite on Friday June 19, 2015 @05:10AM (#9743708)
I have no idea how they compare but the open-source databases has proprietary database tools too, such as Navicat, which have auto-complete, a good UI (Navicat is hardly beautiful but it works well), etc. There are a few other options too.
[ Parent | on HN ]
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by jqm on Thursday June 18, 2015 @11:08PM (#9742807)
I don't know why you are getting downvoted. I'm not personally crazy about SQL Server, but a lot of big companies are. In this situation some of us find ourselves in from time to time, SQL Management Studio is pretty handy.
[ Parent | on HN ]