PGlite packages a WebAssembly build of PostgreSQL into a lightweight TypeScript client that runs Postgres directly in the browser or on Node, Bun and Deno without extra dependencies. The core binary is about 3 MB gzipped and supports many Postgres extensions such as pgvector and PostGIS. It can run purely in memory or persist to IndexedDB in browsers and to the filesystem in server environments. Typical usage is to import the PGlite client, instantiate a database instance, and execute SQL queries just as with a normal Postgres session. PGlite emphasizes local-first, reactive and real-time workflows by embedding the full SQL engine inside application runtimes rather than relying on an external server.
Under the hood PGlite compiles PostgreSQL to WASM and leverages Postgres’s single-user mode because Emscripten-compiled programs cannot fork processes, so it operates as a single user/connection engine. Building requires Docker plus Node.js and pnpm; the build pipeline produces a WASM module and TypeScript packages, though prebuilt artifacts are published with CI for convenience. Contributors are asked to use the provided build and changeset workflows. The project is in alpha, dual-licensed under Apache 2.0 and the PostgreSQL license, and credits prior work by Stas Kelvich.
Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.
Physical Intelligence has launched an API beta that provides access to advanced robotic models for training and inference, simplifying deployment across various industries. The API enables easy fine-tuning and adaptation of models to specific tasks, supporting diverse applications and faster development of autonomous robots. (pi.website)
Huawei has produced over 100 million Kirin chips despite previous US sanctions that limited its access to certain technologies. The milestone highlights Huawei's resilience and progress in its chip manufacturing capabilities. (scmp.com)
Sprout Pi Mainboard is a modern replacement for the iPod 3rd, 4th generation, and iPod mini, adding Bluetooth, Wi-Fi, a hi-fi DAC, USB-C charging, and a microSD slot. It enables users to stream music from services like Spotify and Apple Music, and use wireless headphones, while preserving the original look and feel of the iPod. (crowdsupply.com)
Spotatui is a fast, standalone terminal music player written in Rust that streams Spotify natively without web API rate limits. It also supports local music, Subsonic, radio, Qobuz, and YouTube sources. (github.com)
The Steam Deck's APU, codenamed Van Gogh, features unused cores that suggest it shares design elements with the Magic Leap 2 AR glasses. The OLED version likely uses a custom chipset with removed cores for a smaller footprint and improved efficiency. (boilingsteam.com)
Intel's D270 GPU AI Accelerator features up to 480 GB of LPDDR5X memory, targeting data center AI workloads. The product line is part of Intel's Crescent Island series, with no indication of a consumer GPU release. (intel.com)
Today's best Hacker News stories, summarized and screenshotted, one email a day.