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

81–90 of 433 posts

Re: Postgres IDE in VS Code

#81

Post by dragonwriter »

krferriter wrote: post #33
kstrauser wrote: post #27

It has a proprietary license[0]. That makes it a non-starter. Too bad: it looks nifty! > The software is licensed, not sold. Microsoft reserves all other rights. Unless applicable law gives you more rights despite this limitation, you will not (and have no right to):[…] d) use the software for commercial, non-profit, or revenue-generating activities Oops. Better not install this on your work laptop! [0] https://marke…

Can't use it for commercial, non-profit, or revenue-generating activities? Uh, this actually seems insane to me? What is it for then?

> Can't use it for commercial, non-profit, or revenue-generating activities? Uh, this actually seems insane to me? What is it for then?

Its a public preview, for which Microsoft probably does not wish to accept non-disclaimable liabilities for defects when used in those circumstances.

It is for previewing. By people who are interested in what is in the pipeline for a more general release.

Re: Postgres IDE in VS Code

#82

Post by uludag »

someothherguyy wrote: post #9

https://github.com/Microsoft/vscode-pgsql no source, not a promising privacy policy https://github.com/microsoft/vscode-pgsql/blob/main/PRIVACY

I imagine this is part of Microsoft's plan to the vscode forks: open sourcing copilot to rally developers round it, along with pushing premium closed sourced extensions, which will almost definitely be incompatible with the forks.

Re: Postgres IDE in VS Code

#83

Post by dang »

lolinder wrote: post #55
lossyrob wrote: post #50

Earlier quoted context omitted.

Dev on the project here - I'll mention that this language is due to corporate boilerplate public preview licensing. It is absolutely available and encouraged for use in commercial etc. activities. The licensing language needs to be fixed.

[flagged]

Please don't harangue new users as soon as they show up to HN. Whatever legitimate point you have is drowned out by the atmosphere of hostility you create.

Not only that but it damages the reputation of this community.

You (https://news.ycombinator.com/newsguidelines.html). There's no reason why you can't make your substantive points while doing so. (Edit: you needn't look far for a good example: https://news.ycombinator.com/item?id=44074135.)

It might also be good to remember that everyone makes mistakes, that project launches don't always go perfectly, and that HN is for discussing the interesting aspects of a submission.

Re: Postgres IDE in VS Code

#84

Post by pjmlp »

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

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 use it as the modern version from X Windows and RDP/Citrix sessions.

Not bad, for Eclipse v2 (Enrich Gamma is one of the main architects), pity the whole Electron shell though.

Re: Postgres IDE in VS Code

#85

Post by dpflan »

codingjerk wrote: post #57

Looks promising, but I'll probably stick to `psql`

I wonder about people’s development workflows. If you are using a tool like this, how much time are you spending in the command-line (where all such tools can be interfaced)? Are most tools used wrapped in some layer like this?

Re: Postgres IDE in VS Code

#86

Post by dang »

franktankbank wrote: post #67
lolinder wrote: post #55

Earlier quoted context omitted.

[flagged]

[flagged]

"Please don't post insinuations about astroturfing, shilling, bots, brigading, foreign agents and the like. It degrades discussion and is usually mistaken. If you're worried about abuse, email hn@ycombinator.com and we'll look at the data."

https://news.ycombinator.com/newsguidelines.html

https://hn.algolia.com/?sort=byDate&dateRange=all&type=comme...

Re: Postgres IDE in VS Code

#87

Post by J_McQuade »

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 occasionally have to interact with SQL Server and it's really the best way to do that on non-windows systems now that they're winding down ADS.

Re: Postgres IDE in VS Code

#88

Post by jasonthorsness »

codingjerk wrote: post #60
jasonthorsness wrote: post #36

I use DataGrip, but only for very simple tasks and only against PG and occasionally SQLite and it has always felt like way overkill for me (and it's a heavy app). This will be a more convenient option!

DataGrip would be perfect if it had a community edition. As someone who connects to a database only two or three times a week, I’m not willing to pay for it.

Yeah I already have the all-products pack for Goland, Clion, and Resharper, I wouldn't have purchased DataGrip separately

Re: Postgres IDE in VS Code

#89

Post by pphysch »

pjmlp wrote: post #84
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...).

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.

Re: Postgres IDE in VS Code

#90

Post by WorldMaker »

lolinder wrote: post #28
_ink_ wrote: post #17

> [...] all without ever leaving your favorite code editor. That's cool. How do I get this into JetBrains IDEs?

This is Microsoft catching up to what JetBrains has had all along (in their paid products). There's DataGrip but I was also using all these features (minus the AI stuff) in IntelliJ Ultimate and PyCharm 5+ years ago. The main difference is that JetBrains supports a bunch of databases, not just one.

Microsoft has had official Microsoft SQL Server, Azure Storage, CosmosDB and more extensions for VS Code for a long while now. The surprise is building an official branded Postgres extension rather than leaving that to all the (many) third party and/or open source extensions. I suppose it is a nice side-effect of "AI all the things" efforts that "GitHub Copilot support" was enough reason to grab resources for a postgres query editor and other tools.

(I thought it was particularly nice when you could install most to the VS Code DB extensions standalone as "Azure Data Studio"; you can build separate VS Code profiles for your coding and DBA hats of course, but it's not quite the same feel as launching a separate, dedicated application. Though "Azure Data Studio" was often overlooked because it worked just fine on non-Azure hosted databases.)

Post reply on HN