apsw: Another Python SQLite Wrapper
APSW is a Python wrapper for SQLite that provides additional features beyond the standard library. It is open source, with over 850 stars on GitHub, and actively maintained by the community. (github.com)
A comprehensive, framework-agnostic authentication library for Go that implements a full suite of auth features with zero external dependencies. It provides email-and-password sign-in (scrypt hashing compatible with better-auth), OAuth2/OIDC social sign-on with PKCE for many providers, sessions with sliding expiration and signed cookies, account linking, email verification, password reset, two-factor options (TOTP, email OTP, backup codes), WebAuthn passkeys (CBOR/COSE parsing included), magic links, organizations/SSO, admin tooling, API keys, EdDSA-signed JWTs with a JWKS endpoint, and bearer header auth. The handler is a plain http.Handler so it mounts on any Go web framework; storage adapters include in-memory and database/sql-backed Postgres/MySQL/SQLite (with schema/migration generation). The repo ships examples, plugins that mirror better-auth, CI with fuzzing and race detection, and production usage while still pre-1.0.
Operational and security specifics are enforced up front: New validates BaseURL, a 32+-char Secret, cookie/security settings, and refuses to start on unsafe proxy settings. Accurate client IPs (for rate limiting and session recording) require explicit TrustProxyHeaders plus TrustedProxies or configured provider-specific IP headers; otherwise limits either collapse to a single proxy bucket or become spoofable. Built-in cleanup for expired tokens, CORS helper, request/database hooks, and storage conformance tests against real databases round out a secure, auditable foundation intended to reach v1.0 after additional examples, MySQL verification, and a third-party security review.
Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.
APSW is a Python wrapper for SQLite that provides additional features beyond the standard library. It is open source, with over 850 stars on GitHub, and actively maintained by the community. (github.com)
A minimal Rust terminal user interface (TUI) helps manage GitHub repositories and branches efficiently. The project is hosted on GitHub with limited activity and no detailed description available. (github.com)
ManimGX is an animation engine that combines Manim's Python API with a Rust/wgpu GPU core to create 3D videos and animations. It offers fast math computations and rendering for agents and visualizations in Python. (github.com)
Sergey Davidoff discusses advancements in Rust's SIMD abstractions, making them safer and easier to use without unsafe blocks. Rust 1.87 now allows writing SIMD functions with proper CPU feature tracking, reducing errors and simplifying code. (shnatsel.github.io)
FlowCE is a free, open-source calculus app for the TI-84 Plus CE and TI-83 that allows users to type math in textbook notation and get answers in familiar forms. It supports derivatives, integrals, series, limits, graphs, and more, enhancing classroom and exam calculations. (tommyb3ll.github.io)
Helium Terminal is a lightweight macOS terminal designed for coding agents, built on libghostty. It features a sidebar with tabs, labels, folders, and integrates with AI sessions like Claude Code and Codex. (helium-terminal.bensarmiento.com)
Today's best Hacker News stories, summarized and screenshotted, one email a day.