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

241–250 of 433 posts

Re: Postgres IDE in VS Code

#241

Post by tempaccount420 »

BoorishBears wrote: post #162
jsmith99 wrote: post #112

Earlier quoted context omitted.

I just use a MCP server (with copilot or cline) that has a read only login to my database.

Which is strictly worse than just giving the LLM access to the source of truth for the database. You're adding a round trip to the database and the LLM and inserting a tool call in the conversation before it even starts generating any code. And the reference Postgres MCP implementation doesn't include Postgres types or materialized views, and is one of the most widely used packages: Zed.dev's MCP server for example,…

I don't see how a round trip of If designed well - by suspending generation in memory and inserting a , without restarting generation and fetching cache from disk - the round trip/tool call is better (costs the equivalent of 50 tokens for waiting + function_result tokens).

Re: Postgres IDE in VS Code

#242

Post by zeppelin101 »

polishdude20 wrote: post #225
FeloniousHam wrote: post #148

Earlier quoted context omitted.

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?

With Datagrip, you get all the niceties of a JetBrains IDE: massive customization, numerous plugins (e.g. IdeaVim, GitHub Copilot), lots of documentation. But you also get support for countless Db engines - I haven't seen anything yet which wasn't supported. The only one that was half-baked was Redis support, but it's not exactly a Db, either. Most importantly, it's that the UI doesn't feel clunky, unlike with PgAdmin. Everything feels streamlined and 1 or 2 clicks away, at most.

Re: Postgres IDE in VS Code

#243

Post by krferriter »

dragonwriter wrote: post #81
krferriter wrote: post #33

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?

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

This doesn't make sense to me. They could just say the software is provided as-is and Microsoft holds no liability. Which they do say elsewhere. This license goes much farther to say Microsoft can sue you if you use it.

Re: Postgres IDE in VS Code

#244

Post by layoric »

jsmith99 wrote: post #112
seveibar wrote: post #77

This solves a major problem that I built an npm package called "pgstrap"[1] for. It generates a "database structure" directory so that my database schema is available to LLMs (it also makes code review easier because you can see the changes to various tables). So I have a SQL file for each table in my database, neatly organized into directories for each schema. Rails has a similar idea with schema.rb I'm not sure whe…

I just use a MCP server (with copilot or cline) that has a read only login to my database.

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

Re: Postgres IDE in VS Code

#245

Post by deepsun »

meta_ai_x wrote: post #234
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.

Automatic Schema Visualization always miss the biggest point. When you generate visualization, you should only show key table and key fields within the table and hide all the helper, secondary fields and tables. In an LLM world this should be easy for LLMs to pick out key tables and fields and only display those

Some fields are important for HR, others for Security, others for BI. Gotta have different visualizations for everyone.

LLM here would be like another person or another team, that decides what's important for me, what I should see and what I should not. Might work, but I'd rather see the full picture and decide myself.

Re: Postgres IDE in VS Code

#246

Post by GordonS »

zeppelin101 wrote: post #242
polishdude20 wrote: post #225

Earlier quoted context omitted.

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

With Datagrip, you get all the niceties of a JetBrains IDE: massive customization, numerous plugins (e.g. IdeaVim, GitHub Copilot), lots of documentation. But you also get support for countless Db engines - I haven't seen anything yet which wasn't supported. The only one that was half-baked was Redis support, but it's not exactly a Db, either. Most importantly, it's that the UI doesn't feel clunky, unlike with PgAdmi…

I doubt any new hotness could tear me away from Datagrip. I've used loads of database admin UIs over the years, and Datagrip is by far the most impressive.

Re: Postgres IDE in VS Code

#247

Post by maxluk »

layoric wrote: post #244
jsmith99 wrote: post #112

Earlier quoted context omitted.

I just use a MCP server (with copilot or cline) that has a read only login to my database.

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.

Re: Postgres IDE in VS Code

#248

Post by dragonwriter »

krferriter wrote: post #243
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.

This doesn't make sense to me. They could just say the software is provided as-is and Microsoft holds no liability. Which they do say elsewhere. This license goes much farther to say Microsoft can sue you if you use it.

> This doesn't make sense to me. They could just say the software is provided as-is and Microsoft holds no liability.

You cannot effectively disclaim certain liability for uses of a product you supply, even with an as-is presentation (exactly what liability depends on jurisdiction and often other context). Merely claiming to have no liability does not make it so (what it will usually do is disclaim all yhe liability you can disclaim, except for particular liabilities that may require separate explicit specific waivers to be effective.)

OTOH, if the product you provide is a software license that doesn't cover specific uses, using the software for the excluded uses may not be seen as a use of the product provided at all, and may not trigger the non-disclaimable liabilities, and even it doesn't avoid those liabilities, in the event someone sues over them, it also enabled the product supplier to countersue for infringement damages and mitigate the liabilities.

Re: Postgres IDE in VS Code

#249

Post by timewizard »

meta_ai_x wrote: post #234
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.

Automatic Schema Visualization always miss the biggest point. When you generate visualization, you should only show key table and key fields within the table and hide all the helper, secondary fields and tables. In an LLM world this should be easy for LLMs to pick out key tables and fields and only display those

Why would you need an LLM to do this? The whole point is that SQL describes it's own relationships. You literally have everything you need out of the box.

Re: Postgres IDE in VS Code

#250

Post by rafaelmn »

jjeaff wrote: post #69
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...).

it has to be VS Code by a long shot. They don't charge for it, but it serves as an enormous draw to keep people in the MS ecosphere and keeps MS in the developer game.

That's ironic since I develop most of my Microsoft related tech with JetBrains products and only use vs code for frontend/node - non Microsoft stuff.
Post reply on HN