Live data from Hacker News

Postgres IDE in VS Code

techcommunity.microsoft.com

121–130 of 433 posts

Re: Postgres IDE in VS Code

#121
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 wish there was something similar for SQLite.

Re: Postgres IDE in VS Code

#123
post #5

Very nice and long awaited. Thanks Ms. There are basic features available now (visualisations and query). Looking ahead for more, such table/data editing etc.

I like that I can run this remotely with the vscode ssh extension to my remote systems. But compared to dbeaver, I miss some of the features of dbeaver. Like showing an estimate of large each table is, and seeing how many rows in the 'properties tab'. And being able to see the ERD graphics for individual tables (to show foreign keys, etc).

Also like with dbeaver that you can take the results and export them in many different formats. like directly to excel for some of my co-workers who live and die in excel.

Re: Postgres IDE in VS Code

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

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.

Re: Postgres IDE in VS Code

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

Microsoft seems to be going all in on open source over the past 10-15 years.

From a consumer perspective, we're almost all benefiting.

From a business perspective, they get unpaid help and community brownie points.

Re: Postgres IDE in VS Code

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

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.

Legal, compliance, high performance, and familiarity are all valid reasons. (I'm actually not a fan, but less opposed now that it can run on Linux)

Re: Postgres IDE in VS Code

#128

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

> 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, When was that?

Yeah I’ve been using it since it was released and can’t ever remember it being marketed as such.

Re: Postgres IDE in VS Code

#129

Looks nice enough. I only wish there was an easy way to spread VS Code across multiple monitors. I commonly will work in code on one monitor, and the database tool (DataGrip currently) on another.

Have you thought about just solving the problem with hardware? I.e. one giant 38" wide screen?

Re: Postgres IDE in VS Code

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

Microsoft seems to be going all in on open source over the past 10-15 years. From a consumer perspective, we're almost all benefiting. From a business perspective, they get unpaid help and community brownie points.

Also, given that they recently bought github, they have financial incentive to keep people there, who might upgrade to pro accounts or grow to need enterprise.
Post reply on HN