Community Picks·2yPGlite - run Postgres everywhere
PGlite is a WASM-based Postgres database that works in various JavaScript runtimes, including NodeJS, BUN, Deno, and browsers. It's lightweight, supports popular Postgres extensions, and is ideal for local-first applications, prototypes, local caches, and CI pipelines. The database can be easily installed via npm and used with regular SQL queries.
Community Picks·2yHow Notion uses SQLite for Caching
Notion uses SQLite for client-side caching to enhance performance in its apps across various platforms. Initially implemented in 2021, this approach significantly speeds up initial page loads and navigation. Notion employs WebAssembly to use SQLite in browsers and addresses challenges like database corruption, slow disk reads, and asynchronous loading to optimize the user experience.
Golang Weekly·2yGolang Weekly Issue 523: September 17, 2024
Explore different methods for creating Retrieval-Augmented Generation (RAG) servers in Go, ranging from Gemini + Weaviate to LangChain and Genkit. Learn about WorkOS, a B2B SaaS identity platform that simplifies the integration of SSO and RBAC. Understand how to run Go in the browser using WebAssembly, including reducing WASM binary size with TinyGo. Discover the benefits of using Go instead of Bash for scripting across platforms. Delve into AES encryption in Go with practical examples and explanations. Also, check out the latest GoLand IDE features and the enhanced TinyGo Playground for simulating hardware and measuring power consumption.
MotherDuck·2y5 Hidden gems in DuckDB 1.1
DuckDB 1.1 introduces several new features including custom HTTP headers for API calls, the VARINT data type for optimized memory usage, Pyodide support for running DuckDB in the browser, improvements in query execution speed with ORDER BY and LIMIT clauses, and enhanced debugging capabilities through an HTML EXPLAIN output.
Lobsters·2yTime as a Grid
The post explores Devine's unique grid clock that uses the Arvelie date and Neralie time formats. Inspired by this, the author creates a version using the Gregorian Calendar and 24h-time, detailing the partitioning of hours, minutes, and seconds. Future improvements and feature additions are discussed, with the code available on Sourcehut.