TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

A Language Server for Postgres

99 点作者 tbatchelli3 个月前

6 条评论

ayhanfuat3 个月前
Previously: Postgres Language Server (963 points, 121 comments, 2023) (<a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=37020610">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=37020610</a>)
tmountain3 个月前
As someone who’s written a ton of PL&#x2F;pgSQL code recently, I have been saving all my functions and their subsequent revisions in database migration files (Supabase). This feels like such a huge step backwards compared to browsing a well structured codebase with namespaces and modules. I know that Postgres provides schemas, and I am using them to a limited extent, but I am really speaking towards just having a tree oriented set of files on disk like I would with TypeScript, Golang, etc… and a way to refresh this tree against what’s currently active in my database. Had anyone else had a similar issue or better still, resolved it?
评论 #43108508 未加载
评论 #43110206 未加载
评论 #43108637 未加载
评论 #43109579 未加载
rjbwork3 个月前
My pipe dream is a terraform-like, delcarative, cross-dialect way to manage database schemas&#x2F;code.<p>Sql Server kind of gets there with the .sqlproj and DACPAC stuff but it is quite fiddlesome to setup. I&#x27;ve only seen liquibase as a semi-close alternative in the FOSS space and it really just works with explicitly defined migration chains AFAICT rather than semantic diff and change generation.<p>I think if anyone is going to bring something like that to market, even for just postgres, it will be SupaBase.
评论 #43108165 未加载
评论 #43108026 未加载
benatkin3 个月前
It&#x27;s past time to move beyond LSP. However I&#x27;m glad to see more <i>language servers</i> because that means there will be more who will want to improve the situation.<p>Edit: they&#x27;re right with me on this. From the README: &quot;It is built on a Server-Client architecture with a transport-agnostic design.&quot; Way to go!
cellis3 个月前
Can we get an (easy to use) vscode debugger for plpgsql next?
netcraft3 个月前
Would love to get this plugged into intellij&#x2F;datagrip
评论 #43108958 未加载
评论 #43108277 未加载