The best Hacker News stories from All from the past day
Latest posts:
Some tactics for writing in public
Some tactics for writing in public
Car Bloat: “Huge Cars Are Terrible for Society”
PSA: Intel Graphics Drivers Now Collect Telemetry by Default
Google Maps has become an eyesore
‘Baldur’s Gate 3’ Prepared for 100k Concurrent Players, They’ve Gotten 700K
We are all animals at night
We are all animals at night
Meta blocking news links in Canada
Meta blocking news links in Canada
Replace peer review with “peer replication” (2021)
Replace peer review with “peer replication” (2021)
Postgres Language Server
hey HN. this is a Language Server[0] designed specifically for Postgres. A language server adds features to IDEs (VSCode, NeoVim, etc) - features like auto-complete, go-to-definition, or documentation on hover, etc.<p>there have been previous attempts at adding Postgres support to code editors. usually these attempts implement a generic SQL parser and then offer various "flavours" of SQL.<p>This attempt is different because it uses the actual Postgres parser to do the heavy-lifting. This is done via libg_query, an excellent C library for accessing the PostgreSQL parser outside of the server. We feel this is a better approach because it gives developers 100% confidence in the parser, and it allows us to keep up with the rapid development of Postgres.<p>this is still in early development, and mostly useful for testers/collaborators. the majority of work is still ahead, but we've verified that the approach works. we're making it public now so that we can develop it in the open with input from the community.<p>a lot of the credit belongs to pganalyze[1] for their work on libpg_query, and to psteinroe (<a href="https://github.com/psteinroe">https://github.com/psteinroe</a>) who the creator and maintainer.<p>[0] LSP: <a href="https://microsoft.github.io/language-server-protocol/" rel="nofollow noreferrer">https://microsoft.github.io/language-server-protocol/</a><p>[1] pganalyze: <a href="https://pganalyze.com/" rel="nofollow noreferrer">https://pganalyze.com/</a>
Postgres Language Server
hey HN. this is a Language Server[0] designed specifically for Postgres. A language server adds features to IDEs (VSCode, NeoVim, etc) - features like auto-complete, go-to-definition, or documentation on hover, etc.<p>there have been previous attempts at adding Postgres support to code editors. usually these attempts implement a generic SQL parser and then offer various "flavours" of SQL.<p>This attempt is different because it uses the actual Postgres parser to do the heavy-lifting. This is done via libg_query, an excellent C library for accessing the PostgreSQL parser outside of the server. We feel this is a better approach because it gives developers 100% confidence in the parser, and it allows us to keep up with the rapid development of Postgres.<p>this is still in early development, and mostly useful for testers/collaborators. the majority of work is still ahead, but we've verified that the approach works. we're making it public now so that we can develop it in the open with input from the community.<p>a lot of the credit belongs to pganalyze[1] for their work on libpg_query, and to psteinroe (<a href="https://github.com/psteinroe">https://github.com/psteinroe</a>) who the creator and maintainer.<p>[0] LSP: <a href="https://microsoft.github.io/language-server-protocol/" rel="nofollow noreferrer">https://microsoft.github.io/language-server-protocol/</a><p>[1] pganalyze: <a href="https://pganalyze.com/" rel="nofollow noreferrer">https://pganalyze.com/</a>
The Sad Bastard Cookbook
Water
Water
I went to 50 different dentists: almost all gave a different diagnosis (2022)
Zoom terms now allow training AI on user content with no opt out
nic.funet.fi: Serving freely distributable files with FTP since 1990