Live data from Hacker News

Postgres IDE in VS Code

techcommunity.microsoft.com

211–220 of 433 posts

Re: Postgres IDE in VS Code

#211
post #196

I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries. Does anyone here feel that the graphical editors actually save them time or make their lives easier?

You don't use it but still it's nice feature to have, isn't it?

Oh sure, I'm not criticizing its existence.

Re: Postgres IDE in VS Code

#212

Earlier quoted context omitted.

MS SQL server is a legacy system. I don't think any business would create a new database using SQL server unless, for some technical reason, they don't have any other option.

SQL Server is technically very, very good. But they charge you an arm and a leg for the pleasure, but it can be worthwhile for enterprise.

SQL Server is very good, while cheaper than Oracle. This is a good selling point for enterprises that care about cost (or are too cheap).

Re: Postgres IDE in VS Code

#213

I wonder what is the most "valuable" IDE right now for MS. A few years ago VsCode was marketed essentially as "Visual studio for beginners", where you were supposed to move to Visual Studio after you became a real dev, but since then VSCode has been growing and growing and stands now as the most used "IDE", where Visual Studio is mostly seen as "legacy" (oversimplification, great IDE for CPP and .NET but still...).

> where you were supposed to move to Visual Studio after you became a real dev

It was never marketed like that, for the simple reason that popular VSCode languages like Python/HTML/Javascript were never well supported by regular Visual Studio, so there is no way to move to "proper" Visual Studio if you do Python/web development.

Re: Postgres IDE in VS Code

#214

Earlier quoted context omitted.

SQL Server is technically very, very good. But they charge you an arm and a leg for the pleasure, but it can be worthwhile for enterprise.

I spent the early part of my career in MSSQL and the current part in Pg. MSSQL is extremely, extremely capable as a database engine. But it also costs an arm and a leg. People who haven't used it don't know just how capable it is.

The Express Edition is a SQL database engine with some limitations on CPU count and memory and missing SQL agent. It is free. I installed the version 2017 on some servers 7 years ago and they still run some supplier portal on it, that team was too lazy to even upgrade to newer versions.

Re: Postgres IDE in VS Code

#215

will definitely be taking a look at this. i started my career on mostly SQL Server and using SSMS fits my brain like a glove. i've been so dissatisfied with the typical options (pgadmin, dbeaver, datagrip, etc) for managing/querying postgres since i started using it probably like 10 years ago. postgres itself is great (don't get it twisted either, SQL Server is fantastic. just costs money) but i never understood why…

I've found Datagrip to be far and away the most impressive universal database tool. I feel like I've tried them all, and they all have a quality of having been developed by database people, rather than IDE designers. The depth of capability, extensibility, pace of improvement--I'm a very happy customer. I don't want to poop on open source, but pgadmin and dbeaver and not even close to playing in the same league. I wo…

[deleted]

Re: Postgres IDE in VS Code

#216
post #133

Earlier quoted context omitted.

SQL Server, like Oracle, is technically fantastic. They were both ahead of Postgres for a long time and many people would argue they still are. The reason people don't use them more often is that they're not free or even inexpensive.

I mean they should be, they backed by huge corporation plus they can take notes from Open source DB like postgress and improve their system better

The MS SQL Server engine is an improvement over the years of a branch that was always more technically advanced than Postgres. I don't think there is anything to steal from it.

Re: Postgres IDE in VS Code

#217

Earlier quoted context omitted.

We're working the details out right now, but the change will make it clear that the extension has a free license without restrictions. Stay tuned!

You're a dev on the project and consider yourself authorized to speak on behalf of the project, on a legal matter, on Hacker News. Are you authorized to do the same on a blog hosted on microsoft.com? A lot of people would treat that as authoritative even if bigger enterprises will wait for the shrink-wrap to be updated.

Solid point. That would be a "promissory estoppel" defense if MS changed their mind and decided to run amok with this.

Good: "Your honor, here's a copy of their official blog where they said the license terms are a temporary glitch but that we're fully allowed and encouraged to use the product."

Not good: "Your honor, an anonymous new account on Hacker News said it's totally fine to use this even though the license forbids it."

I'd cheerfully take my chances with the former. The latter? Not so much.

(As mentioned elsewhere, I don't for a second think MS is going to track me down and sue me for using this against the terms of the license. I'd feel a whole lot better if someone officially put that in writing, though.)

Re: Postgres IDE in VS Code

#218
post #196

I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries. Does anyone here feel that the graphical editors actually save them time or make their lives easier?

You don't use it but still it's nice feature to have, isn't it?

I think he went a long way to simply ask what do these tools do that a cli won't.

Re: Postgres IDE in VS Code

#219

will definitely be taking a look at this. i started my career on mostly SQL Server and using SSMS fits my brain like a glove. i've been so dissatisfied with the typical options (pgadmin, dbeaver, datagrip, etc) for managing/querying postgres since i started using it probably like 10 years ago. postgres itself is great (don't get it twisted either, SQL Server is fantastic. just costs money) but i never understood why…

In my experience most SQL developers don't care too much about tooling. In most cases someone designs the database and tables, developers don't care about databases and care mostly about tables and views, rarely about indexes. The ones that care, and need tooling, are usually called development DBAs and they are very rare. Rare enough I was never able to hire one and keep them (we don't pay enough for how rare they are).

Re: Postgres IDE in VS Code

#220

I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries. Does anyone here feel that the graphical editors actually save them time or make their lives easier?

Using a UI to explore data is like looking at the picture instead of someone describing the picture with words.
Post reply on HN