Company
Date Published
April 17, 2024
Author
George MacKerron
Word count
1425
Language
English
Hacker News points
76

Summary

Neon's SQL Editor now supports Postgres's introspection commands such as \d and others. These commands were originally implemented in the C code for psql client but have been translated into JavaScript to enable their use within web browsers. The implementation includes reimplementing some C and Postgres functions, writing examples of all different psql introspection commands, and a test script that compares their results in psql to the results generated by the new JavaScript code. This feature allows users to list or describe things held in Postgres databases directly from their web browser's SQL Editor.