Postgres IDE in VS Code • Hacker News Board

Re: Postgres IDE in VS Code

#41

Post by pier25 » Fri, May 23, 2025, 4:06 PM UTC

magicalhippo wrote: post #35

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.

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

Re: Postgres IDE in VS Code

#42

Post by nico » Fri, May 23, 2025, 4:07 PM UTC

Nice. The few db managers I’ve tried in VS Code are so awkward, creating files for queries and opening multiple panes that barely fit in the crowded IDE space

It makes me wish for something like phpmyadmin or adminer

Re: Postgres IDE in VS Code

#43

Post by Wojtkie » Fri, May 23, 2025, 4:08 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.

The copilot integrations look sweet, as does the schema view. The MSSQL extension doesn't have those, but the rest of it looks similar to the Postgres one.

Re: Postgres IDE in VS Code

#44

Post by pier25 » Fri, May 23, 2025, 4:11 PM UTC

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…

Probably a copypasta mistake?

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

Re: Postgres IDE in VS Code

#45

Post by jasonthorsness » Fri, May 23, 2025, 4:11 PM UTC

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?

I'm sure these restrictions will lift once it's out of preview. They have a huge Postgres hosting business in Azure that couldn't benefit from this if it's restricted to non-commercial.

Re: Postgres IDE in VS Code

#46

Post by nrmitchi » Fri, May 23, 2025, 4:12 PM UTC

[flagged]

Re: Postgres IDE in VS Code

#47

Post by kstrauser » Fri, May 23, 2025, 4:12 PM UTC

pier25 wrote: post #44

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…

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.

Re: Postgres IDE in VS Code

#48

Post by mixmastamyk » Fri, May 23, 2025, 4:12 PM UTC

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…

[flagged]

Re: Postgres IDE in VS Code

#49

Post by 85392_school » Fri, May 23, 2025, 4:12 PM UTC

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?

> PRE-RELEASE SOFTWARE. The software is a pre-release version. It may not operate correctly. It may be different from the commercially released version.

Re: Postgres IDE in VS Code

#50

Post by lossyrob » Fri, May 23, 2025, 4:13 PM UTC

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…

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.