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

221–230 of 433 posts

Re: Postgres IDE in VS Code

#221

Post by epolanski »

pphysch wrote: post #89
pjmlp wrote: post #84

Earlier quoted context omitted.

Monetarily, Visual Studio. There are tons of enterprise development workflows, and plugins, that probably will never be ported into VSCode, from their .NET and COM implementations. Now in terms of mindshare, and gateway drug into Microsoft ecosystem, definitely VSCode. It is also the best Web IDE, for the return of timesharing development, sorry cloud. That alone means everyone that is on Github and Azure, gets to us…

How is VSCode a "gateway drug" into the MS ecosystem? It's good PR, for sure, but it has little to no conceptual/GUI overlap with, say, Windows. FWIW I use it via Linux .deb and integrate with a private GitLab.

Because it opens the gate up to the rest of Microsoft tools.

Once you're gonna play with azure, GitHub, vsc, you're bit by bit invested in the ecosystem and opening the wallet for that other feature or integration.

Re: Postgres IDE in VS Code

#222

Post by kstrauser »

ldjkfkdsjnv wrote: post #101
kstrauser wrote: post #58

Earlier quoted context omitted.

Anyone who works in risk management and/or threat modeling for a living does.

thats such a small percentage of people

There aren't that many doctors, either, as a percentage of the population, but if they tell you not to eat paint, you might consider their opinion.

Re: Postgres IDE in VS Code

#223

Post by epolanski »

dist-epoch wrote: post #213
Toritori12 wrote: post #64

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

> where you were supposed to move to Visual Studio after you became a real dev It was never marketed like that, for the simple reason that popular VSCode languages like Python/HTML/Javascript were never well supported by regular Visual Studio, so there is no way to move to "proper" Visual Studio if you do Python/web development.

VS could do web okay 5 years ago, haven't run it since.

Re: Postgres IDE in VS Code

#225

Post by polishdude20 »

FeloniousHam wrote: post #148
qntmfred wrote: post #24

will definitely be taking a look at this. i started my career on mostly SQL Server and using SSMS fits my brain like a glove. i've been so dissatisfied with the typical options (pgadmin, dbeaver, datagrip, etc) for managing/querying postgres since i started using it probably like 10 years ago. postgres itself is great (don't get it twisted either, SQL Server is fantastic. just costs money) but i never understood why…

I've found Datagrip to be far and away the most impressive universal database tool. I feel like I've tried them all, and they all have a quality of having been developed by database people, rather than IDE designers. The depth of capability, extensibility, pace of improvement--I'm a very happy customer. I don't want to poop on open source, but pgadmin and dbeaver and not even close to playing in the same league. I wo…

I'd love to try datagrip, what are some advantages over pgadmin or others?

Re: Postgres IDE in VS Code

#227

Post by scirob »

the copilote being aware of postgres schema is a thing I manually have to deal with in cursor rules. I keep all the SQL DLL files that created any table in context but then also its best to have cursor rules to tell it to use one orm if possible

Re: Postgres IDE in VS Code

#228

Post by codeulike »

AdrianB1 wrote: post #207
magicalhippo wrote: post #35

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

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 i…

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

Re: Postgres IDE in VS Code

#229

Post by senderista »

CharlieDigital wrote: post #141
harrall wrote: post #132

Earlier quoted context omitted.

SQL Server is technically very, very good. But they charge you an arm and a leg for the pleasure, but it can be worthwhile for enterprise.

I spent the early part of my career in MSSQL and the current part in Pg. MSSQL is extremely, extremely capable as a database engine. But it also costs an arm and a leg. People who haven't used it don't know just how capable it is.

I have worked with multiple ex-SQL Server engine devs and holy shit are they good.
Post reply on HN