Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Postgres IDE in VS Code

techcommunity.microsoft.com

Post reply on HN
Print view View original

141–150 of 433 posts

Re: Postgres IDE in VS Code

#141

Post by CharlieDigital »

harrall wrote: post #132
coliveira wrote: post #125

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.

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.

Re: Postgres IDE in VS Code

#142

Post by helpfulContrib »

Has there been a final solution to the VSCode phoning-home problem?

Last time I tried to use it in my environment, it triggered too many 'external network requests' for the liking of our IT guy. We relegated it to the "Do Not Use" pile as a result.

Has this been resolved? Nobody in my team wants to use an IDE that sends data back to its masters ..

Re: Postgres IDE in VS Code

#143

Post by teruakohatu »

90s_dev wrote: post #126
pier25 wrote: post #8

Oh woah this looks great. Quite amazing they put the effort into this for Postgres instead of SQL Server. The demand must be a lot higher.

Microsoft seems to be going all in on open source over the past 10-15 years. From a consumer perspective, we're almost all benefiting. From a business perspective, they get unpaid help and community brownie points.

> going all in on open source over the past 10-15 years.

Given that there are many Microsoft closed source extensions for VS Code, that cannot legally be used with the open source Version of VS Code, I would say they are not going all in. Knee deep maybe.

Re: Postgres IDE in VS Code

#144

Post by pjmlp »

pphysch wrote: post #89
pjmlp wrote: post #84

Earlier quoted context omitted.

Monetarily, Visual Studio. There are tons of enterprise development workflows, and plugins, that probably will never be ported into VSCode, from their .NET and COM implementations. Now in terms of mindshare, and gateway drug into Microsoft ecosystem, definitely VSCode. It is also the best Web IDE, for the return of timesharing development, sorry cloud. That alone means everyone that is on Github and Azure, gets to us…

How is VSCode a "gateway drug" into the MS ecosystem? It's good PR, for sure, but it has little to no conceptual/GUI overlap with, say, Windows. FWIW I use it via Linux .deb and integrate with a private GitLab.

Worrying about Windows is fighting the last war.

Azure, Github, CoPilot, .NET (why do you think it is cross-platform), Java (yes, MS is back in Java land, they were the ones with initial ARM support), Go (they have their own FIPS compliant distro), Python (although with layoffs maybe not anymore), Rust, npm, Powershell, Powerapps, 365 AddIns, Teams plugins, clang/cmake (part of Visual Studio installer), Azure Linux, Sphere OS,....

Re: Postgres IDE in VS Code

#145

Post by pjmlp »

tempodox wrote: post #95
pjmlp wrote: post #84

Earlier quoted context omitted.

Monetarily, Visual Studio. There are tons of enterprise development workflows, and plugins, that probably will never be ported into VSCode, from their .NET and COM implementations. Now in terms of mindshare, and gateway drug into Microsoft ecosystem, definitely VSCode. It is also the best Web IDE, for the return of timesharing development, sorry cloud. That alone means everyone that is on Github and Azure, gets to us…

Erich Gamma

Thanks for the correction.

Re: Postgres IDE in VS Code

#147

Post by solarkraft »

J_McQuade wrote: post #87
Toritori12 wrote: post #64

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...).

Easily VSCode, if we're talking about developer reach. I'm not big into Microsoft stuff, but almost every 'serious' .Net developer I personally know is using Rider, so I can only assume that Visual Studio is retreating to the same space occupied by Eclipse and Netbeans, i.e. still used, but mostly only in places where change is hard. I'm an emacs user and even I keep a copy of VSCode installed just because I occasion…

Most .Net devs I know use VS, I used Rider because it’s so much less awful.

Re: Postgres IDE in VS Code

#148

Post by FeloniousHam »

qntmfred wrote: post #24

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 work in Oracle and Datagrip saved my sanity.

Re: Postgres IDE in VS Code

#149

Post by ahartmetz »

teruakohatu wrote: post #143
90s_dev wrote: post #126

Earlier quoted context omitted.

Microsoft seems to be going all in on open source over the past 10-15 years. From a consumer perspective, we're almost all benefiting. From a business perspective, they get unpaid help and community brownie points.

> going all in on open source over the past 10-15 years. Given that there are many Microsoft closed source extensions for VS Code, that cannot legally be used with the open source Version of VS Code, I would say they are not going all in. Knee deep maybe.

Because of the closed extensions situation, the open source part feels insincere. Sort of like a free plan up to 10 users and then pretty expensive situation. The purpose isn't the free plan, it's just an advertising measure to get people to where you really benefit eventually.
Post reply on HN