The smallest automation in the smart home is also one of the most useful: a Wake-on-LAN packet that spins a sleeping server back to life. A sysadmin read on WoL use cases, Home Assistant automations, coexisting with Zigbee smart plugs, waking on demand, and how to shut down gracefully without cutting power under load.
Your smart bulb does not need access to the network your laptop sits on, but walling it off the wrong way breaks discovery, onboarding, and voice control. Smart home VLAN segmentation from a sysadmin perspective: mDNS, firewall zones per layer, hub placement, and device classes that should never be walled off entirely.
Most smart homes stop the moment the internet drops, because the command path leaves the house. A sysadmin guide to local-first control: Zigbee, Z-Wave, Matter and Thread devices paired to an on-premises hub, remote access added back with a tunnel or VPN, and the WAN-pull drill that proves it still works.
SQLite is likely the most used database engine on the planet, yet most developers still treat it as a toy. A sysadmin read on what it can actually do: built-in JSON and JSONB, full-text search, window functions, STRICT tables, WAL mode, a genuinely good CLI, backups without a server, and the honest limits that tell you when to reach for PostgreSQL.
WhatsApp, Telegram, Signal and SimpleX compared in plain language for beginners: what each encrypts, what metadata leaks, the pros and cons of each, and which messenger to pick for everyday chats versus the conversations that matter.
Cloudflare wrapped its beta-era data platform into one GA product line renamed Basin: Pipelines, Catalog, and SQL bring serverless Apache Iceberg ingestion, table maintenance, and distributed querying to R2 with usage-based pricing and free egress. A sysadmin read on what changed, how the pieces fit, CLI commands, limits to watch, and what is still on the roadmap.
OpenAI launched dots at DevDay 2026: always-on agents powered by GPT-6 Astra that run on their own cloud computers and keep working between conversations. A quick look at what changed, the governance model, and the new opportunities for builders and operators, with tables.