The best Hacker News stories from All from the past day
Latest posts:
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
Flux Pinning in sample of LK-99?
Non-determinism in GPT-4 is caused by Sparse MoE
New acoustic attack steals data from keystrokes with 95% accuracy
Just normal web things
Reduction of sulfur emissions from ships may be causing rising sea temperatures
Bram Moolenaar has died
Bram Moolenaar has died
Remote work requires communicating more, but less frequently
The Coming Enshittification of Public Libraries
LK-99 is an online sensation but replication efforts fall short