does this work for non-Azure?
PM on the project here - Yes! It works on any Postgres, on-prem or cloud
Hi maxlux,
is it possible to configure a connection over SSH?
Postgres IDE in VS Code
201–210 of 433 posts
Re: Postgres IDE in VS Code
#202Earlier quoted context omitted.
I'm using CLIs like A LOT, but still would be happy to get _good_ autocomplete for SQL. `psql` is pretty bad at it and in `\e` you will just end up in an editor, which will probably don't know about your schema. I've tried many tools, but seems like I like DataGrip (or databases in PyCharm Professional) the most, so I use EAP from time to time, when I'm going to write a lot of SQL.
Hm, is there a psql extension to augment the CLI and provide better autocomplete, maybe even interface with LLM? And then it just stores whatever metadata (like queries you want to save) in its own tables...
I’m really surprised that some rabid rustacean or something hasn’t written an entirely new and aesthetic CLI replacement for psql with all the modern comforts. Autocomplete menus, graphic icons, colors, etc…
Re: Postgres IDE in VS Code
#203Earlier quoted context omitted.
They already have the SQL Server Management Studio[1], which seems to cover similar ground? I'm assuming they might want to move SSMS to VSCode in time, so trying it out by covering new ground, PostgreSQL, makes sense to me. [1]: https://learn.microsoft.com/en-us/ssms/sql-server-management...
But it's only for Windows
In my experience, MSSQL shops are far more likely to be using Windows already than PGSQL shops, so that's just yet another reason for why PGSQL was a good first choice for a VSCode plugin IMHO.
Re: Postgres IDE in VS Code
#204Earlier quoted context omitted.
but they appear to have made the account just to make that comment People making accounts so they can talk about their work is one of the best reasons for people to make an account and a big part of what makes HN threads interesting. people claiming to be official advocates that could do real damage to your company if legal wanted to bone you. That seems like the opposite of assuming good faith.
> People making accounts so they can talk about their work is one of the best reasons for people to make an account and a big part of what makes HN threads interesting. Uhuh but coming in to give bad legal advice as your first comment for the benefit of the largest most litigious corp on the planet, is that what makes HN threads interesting? > That seems like the opposite of assuming good faith. That wasn't a stateme…
It's not legal advice. People can just be wrong and you can tell them you think that without coming off as a jerk.
That wasn't a statement towards the individual. That was a statement of what could befall someone who took their advice.
No, I don't think that's true - it's just a catastrophizing rationalization for reflexive dickishness. We all suffer from reflexive dickishness so of course it happens and it's not that big of a deal but trying to pass it off as some sort of virtue is a mistake.
Re: Postgres IDE in VS Code
#205Earlier quoted context omitted.
PM on the project here - Yes! It works on any Postgres, on-prem or cloud
Hi maxlux, is it possible to configure a connection over SSH?
Not directly in the extension connection object, but it's in on the roadmap. In the meantime, you can create ssh tunnel using vscode remotes and then just connect through it.
Re: Postgres IDE in VS Code
#206I 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…
I work at a mostly .NET firm and almost all the developers on that side of things are on Visual Studio. Rider has less penetration than PyCharm has among the Python devs.
Re: Postgres IDE in VS Code
#207Oh 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.
They already have the SQL Server Management Studio[1], which seems to cover similar ground? I'm assuming they might want to move SSMS to VSCode in time, so trying it out by covering new ground, PostgreSQL, makes sense to me. [1]: https://learn.microsoft.com/en-us/ssms/sql-server-management...
No, it has a different purpose; VS Code extension and the former ADS are targeted for development, while SSMS is for server and database administration. I am a heavy user of SSMS and can do everything I ever need there, I don't use the VS Code extension for MS SQL even if I have it installed and I use VS Code quite a lot. This is because I am also acting as a backup and supervisor for our DBA team, so I am involved in DBA work.
Re: Postgres IDE in VS Code
#208Earlier quoted context omitted.
That's good to know! Right now it's pretty much illegal for anyone to use it in the situations most people would want to use it for. Any idea what the eventual license will be?
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.
Re: Postgres IDE in VS Code
#209Isn't PGAdmin good enough? Not hating, but I'm not a database guy either so just curious why create a VSCode extension for GUI stuff.
I love PGAdmin. For me it works very well. And then there are other tools when I need to work with schema etc. I always feel PGAdmin is an open source product that the team is most actively working on, always keep releasing fixes and updates. I don't want it in my IDE yet.
Re: Postgres IDE in VS Code
#210Graphical schema image generation was in IntelliJ for like 15 years at least? Since the times with all the craze about UML "disrupting" software engineering.