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

261–270 of 433 posts

Re: Postgres IDE in VS Code

#261

Post by pjmlp »

codeulike wrote: post #228
AdrianB1 wrote: post #207

Earlier quoted context omitted.

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

Same here, much better than the VS tooling for SQL Server, including all the Transact-SQL support.

Re: Postgres IDE in VS Code

#262

Post by pjmlp »

coliveira wrote: post #125
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.

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.

SQL Server and Oracle are as actual as ever, regardless of the hate they get on FOSS circles.

Re: Postgres IDE in VS Code

#264

Post by datavirtue »

90s_dev wrote: post #126
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.

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.

And most of us are invested in MSFT, so we benefit that way as well. (I don't hold any positions)

Re: Postgres IDE in VS Code

#265

Post by deepsun »

robertlagrant wrote: post #231
deepsun wrote: post #210

Graphical schema image generation was in IntelliJ for like 15 years at least? Since the times with all the craze about UML "disrupting" software engineering.

UML was the late 90s! Rational Rose[0] was the glorious future of class design. Draw the diagram and let the juniors fill in the methods. [0] affectionately Crashional Rose

I was a junior back then, and was afraid to speak up that Rational Rose is just a waste of time. Don't you dare say that about LLMs!

Re: Postgres IDE in VS Code

#266

Post by Alupis »

ahartmetz wrote: post #149
teruakohatu wrote: post #143

Earlier quoted context omitted.

> going all in on open source over the past 10-15 years. Given that there are many Microsoft closed source extensions for VS Code, that cannot legally be used with the open source Version of VS Code, I would say they are not going all in. Knee deep maybe.

Because of the closed extensions situation, the open source part feels insincere. Sort of like a free plan up to 10 users and then pretty expensive situation. The purpose isn't the free plan, it's just an advertising measure to get people to where you really benefit eventually.

I recently called this (and other Microsoft behavior) out as being "fake" open source. The comment was highly controversial with quite a battle of up and down votes - so clearly not everyone agrees.

In my opinion, Microsoft wants the good vibes and PR that comes with open source, but they don't actually want to be open source. Its why many people still don't trust them in this arena.

Re: Postgres IDE in VS Code

#267

Post by blibble »

deepsun wrote: post #210

Graphical schema image generation was in IntelliJ for like 15 years at least? Since the times with all the craze about UML "disrupting" software engineering.

it was in Access 95 and FoxPro (and likely before that too)

slowly development tools are catching up with the 90s

Re: Postgres IDE in VS Code

#269

Post by layoric »

maxluk wrote: post #247
layoric wrote: post #244

Earlier quoted context omitted.

Out of interest.. does the resultant data get used by the LLM or just generating SQL, executing and returning separately?

PM on the project here - The results from the query are generally not used by the LLM. In agent mode though, during query planning, the agent may retrieve sample of the data to improve precision of the queries. For example, getting distinct values from dimensional table to resolve filter condition from natural language statement.

Thanks. I worry about these kind of tools connecting to production databases.. Especially considering how easy it is to switch out LLM endpoints, where that data is going, how it is retained, the context etc becomes a bit of a privacy nightmare..

Re: Postgres IDE in VS Code

#270

Post by timewizard »

maxluk wrote: post #260
timewizard wrote: post #252

Earlier quoted context omitted.

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?

The tables should be better ordered. "speakers" is obviously the primary table here and should be top left. The "session_speakers" should be between it and the table it maps "sessions." Then "reviews" and "events" on the bottom. There's an obvious "top end" and "bottom end" of this structure that this graph completely gets wrong.

You could argue that "events" are primary in which case just switch the order of that and "speakers."

I'd color the table headers differently and different from each other and have the arrows leaving that box match the color of the box it's leaving. Also drop "public:". It's expected and default so it does not need to be displayed here.

Drop the key icon and just make the key fields in bold or with a different style.

Don't make me hunt around to match information and don't be afraid to use differential styling.

Post reply on HN