Ahsan Hadi: PostgreSQL 19 Is Here: Worth the Wait
PostgreSQL 19 is available through the pgEdge repository, with installation instructions for apt and dnf systems. Release notes and a blog series explain the project’s changes. (pgedge.com)
gopgext is an experimental toolkit for building PostgreSQL extensions in ordinary Go, compiled with TinyGo. Developers annotate Go functions with directives, and the tool generates the C glue, extension control file, and SQL installation script needed to load them into PostgreSQL. Its example defines SQL-callable greeting and shouting functions, including a PostgreSQL error with a specific SQLSTATE when the input is empty. The documentation describes mappings between Go and SQL types - including arrays, NULLs, rows, timestamps, UUIDs, and JSON - and support for custom and composite types. Go code can also run SQL through PostgreSQL’s SPI, inspect settings, log messages, and respond to query cancellation.
The toolkit aims well beyond simple functions: it supports triggers, aggregates, index operator classes and access methods, foreign data wrappers, and query hooks. Ports of PostgreSQL contrib modules such as pgcrypto, hstore, pg_stat_statements, and cube reportedly pass their upstream regression tests. Its runtime and generated glue are designed to let multiple Go extensions coexist in one backend, prevent PostgreSQL errors from unwinding through Go frames, and copy results into PostgreSQL-managed memory. The project uses a custom TinyGo target and runtime layer, with PostgreSQL’s PGXS build system compiling the C runtime. It is explicitly not production-ready: generated-code or runtime bugs could crash the server or corrupt data, and both its API and generated SQL may change without notice.
Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.
PostgreSQL 19 is available through the pgEdge repository, with installation instructions for apt and dnf systems. Release notes and a blog series explain the project’s changes. (pgedge.com)
Graham Dumpleton, creator of mod_wsgi, is building Muru, an AI-assisted Rust server for running Python’s WSGI and ASGI apps in development and production. Its features include HTTPS, Kubernetes support, scaling, and tracing, with Dumpleton using his two decades of experience to guide and refine the project. (simonwillison.net)
Fast-Anything helps optimize Python, Node, and Ruby apps by profiling them and rewriting only their slowest functions in Rust. It uses coding agents to make the changes and checks that the rewritten functions behave the same. (github.com)
Leonida is a community project that aims to recompile the Xbox version of Grand Theft Auto 6 for native PC execution. Its public GitHub repository is GPL-3.0 licensed and has attracted thousands of stars and hundreds of forks. (github.com)
Rust GUI development is gaining momentum as AI makes Rust easier to use and teams seek safer, faster alternatives to bloated cross-platform apps. New toolkit projects should focus on clear use cases and practical trade-offs instead of chasing a universal definition of “native.” (linebender.org)
Big data is not the main obstacle to useful insights: hardware has kept pace with data growth, while teams still struggle to make sense of their information. The author argues that organizations should focus on making data easier to understand and use, rather than buying tools built for ever-larger datasets. (motherduck.com)
Today's best Hacker News stories, summarized and screenshotted, one email a day.