Postgres IDE in VS Code • Hacker News Board

Re: Postgres IDE in VS Code

#91

Post by shawnz » Fri, May 23, 2025, 4:42 PM UTC

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.

There is already a Microsoft SQL server extension for VS Code and this looks to effectively be a clone of it. After giving this a quick spin, it looks and feels the same as the SQL server extension, with the same menus, dialogs, etc. The SQL server extension I believe is what formed the basis of the now-deprecated Azure Data Studio (which was a VS code fork).

See here for the SQL server extension: https://marketplace.visualstudio.com/items?itemName=ms-mssql...

Re: Postgres IDE in VS Code

#92

Post by gniting » Fri, May 23, 2025, 4:42 PM UTC

saqadri wrote: post #74

This is so cool. A big reason I used prisma was for prisma studio. Having this kind of support in vscode is nice to see

(prisma team member)

We're going to be rolling out Prisma Studio as a VS Code extension soon!

Re: Postgres IDE in VS Code

#93

Post by abetaha » Fri, May 23, 2025, 4:43 PM UTC

This looks great. Would all the functionality work if the databases are hosted on other cloud providers?

Re: Postgres IDE in VS Code

#94

Post by acdha » Fri, May 23, 2025, 4:43 PM UTC

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.

Azure and GitHub are large Microsoft revenue sources. Both have first-class VSC integration.

Re: Postgres IDE in VS Code

#95

Post by tempodox » Fri, May 23, 2025, 4:43 PM UTC

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…

Erich Gamma

Re: Postgres IDE in VS Code

#96

Post by [deleted] » Fri, May 23, 2025, 4:43 PM UTC

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.

[deleted]

Re: Postgres IDE in VS Code

#97

Post by lolinder » Fri, May 23, 2025, 4:45 PM UTC

dang wrote: post #83

lolinder wrote: post #55

Earlier quoted context omitted.

[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.ycomb…

I didn't mean it to be haranguing, but OP was giving what amounted to legal advice that was actually wrong and dangerous. I do think that needs to be called out and clarified—not as a personal attack on OP but just as a matter of safety for readers.

I'll acknowledge that kstrauser may have done a better job of sounding friendly about it, but I don't think my question was out of line nor even particularly aggressive given the circumstances.

Re: Postgres IDE in VS Code

#98

Post by barfolomew » Fri, May 23, 2025, 4:46 PM UTC

I will be using this. 100%. very handy

Re: Postgres IDE in VS Code

#99

Post by Rastonbury » Fri, May 23, 2025, 4:47 PM UTC

kstrauser wrote: post #47

pier25 wrote: post #44

Earlier quoted context omitted.

Probably a copypasta mistake? Why would they spend money into this extension if 99% of developers can't use it?

Maybe, but darned if I'm going to be the one to take the legal risk of installing it.

I'm willing to put good money that MS is not going to sue anyone for using this

Re: Postgres IDE in VS Code

#100

Post by getgalaxy » Fri, May 23, 2025, 4:49 PM UTC

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.

try galaxy instead ;) getgalaxy.io