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

421–430 of 433 posts

Re: Postgres IDE in VS Code

#421

Post by throwaway7783 »

ecb_penguin wrote: post #418
scott_w wrote: post #417

Earlier quoted context omitted.

No, it’s not obvious the DB changes because the team depending on that schema doesn’t necessarily talk to your team much, and you might not even know that team exists. The same is true for API contracts but the culture of changing an API is much more understood as something that must be communicated and processes are more rehearsed.

> No, it’s not obvious the DB changes because the team depending on that schema doesn’t necessarily talk to your team much, and you might not even know that team exists. Literally everything you just said applies to services and API contracts as well. You haven't solved anything. > the culture of changing an API is much more understood as something that must be communicated and processes are more rehearsed You're jus…

It is more that services allow more backward compatibility than direct DB changes, because you can also code additional logic to maintain that.

Of course in a narrow case where all apps that need the same DB need to be upgraded/fixed in lockstep, maybe you can get away by directly updating the database. But more than 2 teams, it will quickly be a nightmare of conflicting priorities across teams, amount deployment coordination required.

"Oh you cannot change this schema right now because 3 other apps depend on it and they dont have time to make the necessary changes in their app to accommodate this right now, for the next 6 months"

Re: Postgres IDE in VS Code

#422

Post by d0100 »

joseda-hg wrote: post #404
d0100 wrote: post #226

So it's just Azure Data Studio where it lacks SSH tunneling... I got my hopes up for nothing

Doesn't VSCode have first party SSH tunneling support [1]? What are you missing? [1] https://code.visualstudio.com/docs/remote/tunnels

I can also create them with ssh

But I prefer to keep that info with the db connection, and have it automatically run when I connect

It's a pretty standard expectation (Navicat, DBeaver, etc)

Re: Postgres IDE in VS Code

#423

Post by lossyrob »

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…

The license has been updated to remove this restrictive language: https://marketplace.visualstudio.com/items/ms-ossdata.vscode...

Re: Postgres IDE in VS Code

#424

Post by lossyrob »

kstrauser wrote: post #192
lossyrob wrote: post #182

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!

Right on. I'll keep an eye out for it!

We've updated the license, thanks for the patience: https://marketplace.visualstudio.com/items/ms-ossdata.vscode...

Re: Postgres IDE in VS Code

#425

Post by croblesm »

shawnz wrote: post #91
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…

That’s correct—I’m the lead PM for the SQL extension in Visual Studio Code. We’ve been working closely with the PostgreSQL team; in fact, their extension is essentially a fork of ours, as you pointed out correctly.

Just to clarify on the Azure Data Studio (ADS) point: the MSSQL extension includes many of the core features from ADS, but our strategy is slightly different and focused on a modern, developer-first experience.

Here’s the link to our open roadmap—would love to hear your thoughts: https://aka.ms/vscode-mssql-roadmap

Re: Postgres IDE in VS Code

#426

Post by croblesm »

pamelafox wrote: post #255
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.

I'm a developer advocate at Microsoft, and from my perspective, both teams have been putting in a bunch of effort improving their extensions. I participated in usability studies with both the teams behind the SQL Server extension and new PostgreSQL extension, and then once they were ready, I participated in bug bashes. Both teams seem to very much want developers to enjoy their tools, so please do send them feedback…

Thank you so much, Pamela! You’ve been an amazing and key partner in our journey—your feedback and support have truly made a difference.

Re: Postgres IDE in VS Code

#427

Post by croblesm »

jiggawatts wrote: post #273
pamelafox wrote: post #255

Earlier quoted context omitted.

I'm a developer advocate at Microsoft, and from my perspective, both teams have been putting in a bunch of effort improving their extensions. I participated in usability studies with both the teams behind the SQL Server extension and new PostgreSQL extension, and then once they were ready, I participated in bug bashes. Both teams seem to very much want developers to enjoy their tools, so please do send them feedback…

The problem customers have with these Shiny New Things that Microsoft keeps trying get us to switch to is that they drop features and entire product suites on the floor, even those that aren't officially deprecated and have no equivalent replacements. It's common to see SSRS, SSIS, SSAS in multidimensional mode, etc... simply forgotten about like they no longer exist. Not to mention that SQL "SDK-style" projects only…

Thanks for your feedback! I’m a PM on the SQL Experiences team, and if you’re open to it, I’d be happy to connect you with the PM leading the SSDT (VS) effort.

Feel free to connect with me on LinkedIn, and we can go from there: https://www.linkedin.com/in/croblesm/

Re: Postgres IDE in VS Code

#428

Post by croblesm »

shawnz wrote: post #315
jiggawatts wrote: post #273

Earlier quoted context omitted.

The problem customers have with these Shiny New Things that Microsoft keeps trying get us to switch to is that they drop features and entire product suites on the floor, even those that aren't officially deprecated and have no equivalent replacements. It's common to see SSRS, SSIS, SSAS in multidimensional mode, etc... simply forgotten about like they no longer exist. Not to mention that SQL "SDK-style" projects only…

I totally agree and I beg you to consider this feedback if you are reading @pamelafox. The biggest problem with the usability of Microsoft products today is short-sighted thinking. New features, platforms, frameworks etc are launched and then forgotten about just a few years later with no effort to tie into the groundwork of what came before. You might think this is only a problem for old customers who are already ac…

Thanks for sharing this thoughtful feedback.I’d be happy to connect you with the PM leading that area, so your insights can be heard directly—feel free to reach out if you’re interested.

Feel free to connect with me on LinkedIn, and we can go from there: https://www.linkedin.com/in/croblesm/

Re: Postgres IDE in VS Code

#429

Post by croblesm »

nevi-me wrote: post #26
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.

I speculate that it's because the MSSQL tools have been maintained as part of Azure Data Studio, and were in better shape. ADS is being sunset, and I was surprised when trying to install the Postgres extension on VS Code to find that it had its last meaningful contribution 6 years ago [0]. It couldn't work on newer VS Code versions. I use ADS with both Postgres and MSSQL, prior to this announcement, I kept using ADS…

You’re right—the old PostgreSQL extension was outdated. The team recently forked our modern MSSQL extension (I’m the Lead PM) to build a new one for PostgreSQL. It’s a fresh start, built on the same foundation we’re actively improving.

We’re still working on bringing over some Azure Data Studio features to the VS Code extension, especially around import/export (like flat file and DACPAC). I’d love to hear what else you think is missing.

If you’re interested, here’s our open roadmap: https://aka.ms/vscode-mssql-roadmap

Re: Postgres IDE in VS Code

#430

Post by croblesm »

dehugger wrote: post #328
codeulike wrote: post #228

Earlier quoted context omitted.

SSMS is also for Development, I've been using it for that for 20 years

I agree, I work on an application with a lot of business logic in SQL and SSMS ends up being my primary development IDE because of that.

Lead PM for SQL in VS Code here. I’m glad to hear SSMS is working well for you! I’d love to better understand why VS Code doesn’t meet your needs in the same way.

We’re actively working to improve the experience, and learning what works for you in SSMS would be incredibly valuable.

Post reply on HN