PYpyramation·Apr 1, 2024Submission
Show HN: From Postgres Proto to TypeScript – new transpiler for tooling
2 points · Open discussionconstructive-io
pg-proto-parser
Web Development2024–2024
constructive-io / pg-proto-parser · Archived
pg-proto-parser
a TypeScript project that parses pganalyze/libpg_query PostgreSQL Protocol Buffers (protobuf) definitions and generates TypeScript interfaces, utility functions, and JSON mappings for the enums defined in the protobuf schema
2Distinct people
3Mentions
0Explicit recommenders
8GitHub stars
What to know before exploring
What it is
a TypeScript project that parses pganalyze/libpg_query PostgreSQL Protocol Buffers (protobuf) definitions and generates TypeScript interfaces, utility functions, and JSON mappings for the enums defined in the protobuf schema
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 7:56:55 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by week3 dated mentions
Observed mentions: 2024-04-01 05:50:52 UTC to 2024-09-22 19:47:23 UTC. Weeks start Monday, UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| Apr 1 | 2024-04-01 00:00:00 UTC | 2024-04-08 00:00:00 UTC | 2 | 1 | 1 |
| Apr 8 | 2024-04-08 00:00:00 UTC | 2024-04-15 00:00:00 UTC | 0 | 0 | 0 |
| Apr 15 | 2024-04-15 00:00:00 UTC | 2024-04-22 00:00:00 UTC | 0 | 0 | 0 |
| Apr 22 | 2024-04-22 00:00:00 UTC | 2024-04-29 00:00:00 UTC | 0 | 0 | 0 |
| Apr 29 | 2024-04-29 00:00:00 UTC | 2024-05-06 00:00:00 UTC | 0 | 0 | 0 |
| May 6 | 2024-05-06 00:00:00 UTC | 2024-05-13 00:00:00 UTC | 0 | 0 | 0 |
| May 13 | 2024-05-13 00:00:00 UTC | 2024-05-20 00:00:00 UTC | 0 | 0 | 0 |
| May 20 | 2024-05-20 00:00:00 UTC | 2024-05-27 00:00:00 UTC | 0 | 0 | 0 |
| May 27 | 2024-05-27 00:00:00 UTC | 2024-06-03 00:00:00 UTC | 0 | 0 | 0 |
| Jun 3 | 2024-06-03 00:00:00 UTC | 2024-06-10 00:00:00 UTC | 0 | 0 | 0 |
| Jun 10 | 2024-06-10 00:00:00 UTC | 2024-06-17 00:00:00 UTC | 0 | 0 | 0 |
| Jun 17 | 2024-06-17 00:00:00 UTC | 2024-06-24 00:00:00 UTC | 0 | 0 | 0 |
| Jun 24 | 2024-06-24 00:00:00 UTC | 2024-07-01 00:00:00 UTC | 0 | 0 | 0 |
| Jul 1 | 2024-07-01 00:00:00 UTC | 2024-07-08 00:00:00 UTC | 0 | 0 | 0 |
| Jul 8 | 2024-07-08 00:00:00 UTC | 2024-07-15 00:00:00 UTC | 0 | 0 | 0 |
| Jul 15 | 2024-07-15 00:00:00 UTC | 2024-07-22 00:00:00 UTC | 0 | 0 | 0 |
| Jul 22 | 2024-07-22 00:00:00 UTC | 2024-07-29 00:00:00 UTC | 0 | 0 | 0 |
| Jul 29 | 2024-07-29 00:00:00 UTC | 2024-08-05 00:00:00 UTC | 0 | 0 | 0 |
| Aug 5 | 2024-08-05 00:00:00 UTC | 2024-08-12 00:00:00 UTC | 0 | 0 | 0 |
| Aug 12 | 2024-08-12 00:00:00 UTC | 2024-08-19 00:00:00 UTC | 0 | 0 | 0 |
| Aug 19 | 2024-08-19 00:00:00 UTC | 2024-08-26 00:00:00 UTC | 0 | 0 | 0 |
| Aug 26 | 2024-08-26 00:00:00 UTC | 2024-09-02 00:00:00 UTC | 0 | 0 | 0 |
| Sep 2 | 2024-09-02 00:00:00 UTC | 2024-09-09 00:00:00 UTC | 0 | 0 | 0 |
| Sep 9 | 2024-09-09 00:00:00 UTC | 2024-09-16 00:00:00 UTC | 0 | 0 | 0 |
| Sep 16 | 2024-09-16 00:00:00 UTC | 2024-09-23 00:00:00 UTC | 1 | 0 | 1 |
What Hacker News says
2 sourcesMy journey to upgrade pgsql-parser to TypeScript led to an exciting discovery in the pganalyze/libpg_query repository: protobuf files defining PostgreSQL's AST. This discovery inspired me to create a proto-to-TypeScript transpiler, streamlining the process of typing the pgsql-parser and unlocking other cool new features :)
The transpiler not only allowed me to add typing for pgsql-parser but also spawned a suite of TypeScript utilities that are invaluable for PostgreSQL development.
Explore the tools:
pg-proto-parser: https://github.com/launchql/pg-proto-parser
pgsql-parser: https://github.com/launchql/pgsql-parser
Additionally, we now have new utilities generated by the proto parser, make sure to checkout the @pgsql/utils! That has some cool features in it:
@pgsql/enums: https://github.com/launchql/pgsql-parser/tree/main/packages/...
@pg
Read the rest
sql/types: https://github.com/launchql/pgsql-parser/tree/main/packages/...
@pgsql/utils: https://github.com/launchql/pgsql-parser/tree/main/packages/...
Hope you enjoy! Please let me know anything you'd like to see!