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

251–260 of 433 posts

Re: Postgres IDE in VS Code

#251

Post by dragonwriter »

SahAssar wrote: post #188
dragonwriter wrote: post #81

Earlier quoted context omitted.

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

> non-disclaimable liabilities So you are saying that MIT/ISC/GPL/Apache2 and all the other OSS licenses do open you up to liabilites?

I am saying being a merchant in the field of software and supply software opens you up to liabilities, and saying “Not my responsibility” does not, in most jurisdictions, actially completely shield you from all of them, correct.

This may also, to a lesser extent, be true of people who are not merchants in the field of the product supplied.

It’s not the license creating the liability, in either case.

Re: Postgres IDE in VS Code

#252

Post by timewizard »

harrall wrote: post #220
tombert wrote: post #187

I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries. Does anyone here feel that the graphical editors actually save them time or make their lives easier?

Using a UI to explore data is like looking at the picture instead of someone describing the picture with words.

Yet the picture at the top of the article is incomprehensible to me. Why is the "session_speakers" table positioned there? It relates speakers and sessions and then has a geometric layout that completely fails to convey that.

You put too many bezier curves on a page on my eyes go cross. They don't even bother to make the lines different colors. Just a bunch of white curves against a fixed grid layout. Wut?

It's taking well structured data and then destructuring it into an inaccurate sloppy picture. I don't get it.

Re: Postgres IDE in VS Code

#254

Post by abetaha »

maxluk wrote: post #139
abetaha wrote: post #93

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

I am PM from the project - short answer is yes - you can connect to any Postgres endpoint. There are some Azure specific features, like EntraID supported by the extension that don't exist in other cloud providers.

Thank you, this is great

Re: Postgres IDE in VS Code

#255

Post by pamelafox »

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 on what you need out of the tools.

Follow Carlos Robles if you want SQL server extension news: https://www.linkedin.com/in/croblesm/

Follow Joshua Johnson for PostgreSQL server extension news: https://www.linkedin.com/in/johnsonjoshuae/

Re: Postgres IDE in VS Code

#256

Post by pamelafox »

Congrats to the team on launching this! I was actually the first to demo it, as part of our sponsored session at Microsoft last week.

Here's the talk where I used it: https://www.youtube.com/watch?v=k6Vm2hakkV4

I also did a theater session at our MSFT booth, but the recording isn't up yet. You can follow the steps in this repo to check out all the features that I demo'd, however: https://github.com/Azure-Samples/postgresql-extension-playgr...

Let the team know about any issues here: https://github.com/microsoft/vscode-pgsql/issues

Re: Postgres IDE in VS Code

#257

Post by pamelafox »

todotask2 wrote: post #165

There seems to be a bug — I can't re-run the query from the query history panel; it returns no results. New query could still get results. Overall, it should have been a separate app because you can't really see all the results in a small panel.

Please file that bug in the issue tracker: https://github.com/microsoft/vscode-pgsql/issues

The team is very receptive to feedback, in my experience.

Re: Postgres IDE in VS Code

#258

Post by pamelafox »

tombert wrote: post #187

I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries. Does anyone here feel that the graphical editors actually save them time or make their lives easier?

The schema visualization is a feature of the extension, not the primary mode of navigation. Lots of people love visualization, but not everyone does - totally cool to not use it. I think it's a fun way to browse a database that's new to me, to see roughly how things are connected.

Re: Postgres IDE in VS Code

#259

Post by srigi »

paulirwin wrote: post #161
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.

Azure SQL Database for a long while has been the most cost-effective way of running SQL Server as a PaaS database, and still is if you choose the DTU-based modes, making it a very attractive option. Combined with the rich feature set and maturity and reliability of SQL Server, it is hardly legacy; in fact it's very capable and continues to get new updates like vector operations. I've helped create apps that support m…

Yeah, I remember that option - basic tier of DTU DB with 250GB of storage - free for one year, then continue for $15/m.

When the client brought some 3rd party expert and he advised rewriting to MySQL, I quickly did the math and it was like $60/m, without a free year.

We continued with DTU MSSQL with Prisma ORM and never regreted.

Re: Postgres IDE in VS Code

#260

Post by maxluk »

timewizard wrote: post #252
harrall wrote: post #220

Earlier quoted context omitted.

Using a UI to explore data is like looking at the picture instead of someone describing the picture with words.

Yet the picture at the top of the article is incomprehensible to me. Why is the "session_speakers" table positioned there? It relates speakers and sessions and then has a geometric layout that completely fails to convey that. You put too many bezier curves on a page on my eyes go cross. They don't even bother to make the lines different colors. Just a bunch of white curves against a fixed grid layout. Wut? It's takin…

Isn't it a problem with many-to-many relationships in relational algebra? You have to have this artificial table to relate things in many-to-many way. How would you display it in a better way?
Post reply on HN