lobste.rs is now running on SQLite

kept by eddie jul 20

Lobsters successfully moved from MariaDB to SQLite, cutting CPU and memory use, halving VPS costs, and keeping the site responsive after migration.

Visualize MySQL query execution plans as interactive FlameGraphs
Myflames converts MySQL EXPLAIN ANALYZE JSON into interactive flamegraph SVGs and a compact text digest that reduces LLM input tokens by 75% for query diagnosis.
also on MariaDB, #open-source, #developer-tools
What are your programming "hunches" you haven't yet investigated?
Lobsters commenters share uninvestigated programming hunches, including accessibility-first GUI toolkits, 32-bit pointers on 64-bit systems, property-based infrastructure, MUD-style chat, and user-controlled theming.
also on Lobsters, #developer-tools
One Week of Building and Reviewing Code With LLM Agents
Logging a week of agent‑driven backend work, the engineer shows LLMs generated most code, isolated agents found real bugs, while multi‑tool agreement often missed defects.
also on Rails, #developer-tools
Activepad - Rails scratchpad for macOS
Activepad is a native macOS scratchpad that lets Rails developers run Ruby code against real app models and database with autocomplete and remote SSH support.
also on Rails, #developer-tools
SQLite for Everything
SQLite can replace many specialized systems—search, document store, queue, cache, vector DB, etc.—by serving as a single-file, zero‑maintenance database for applications.
also on SQLite, #performance, #open-source, #developer-tools