PostgreSQL Query Rewriting Techniques The previous articles in this series covered performance problems you fix by adding indexes, restructuring joins, or tuning memory. This one is about the queries where the plan is "fine" — every node is doing something reasonable — but the query itself is asking the wrong question, producing unnecessarily large intermediate results or forcing the planner dow
Show HN: Let – Offline-first life events tracker (React Native, SQLite)
OpenWeatherMap API for Browser Extensions: A Practical Guide If you're building a browser extension that shows weather data, OpenWeatherMap is the go-to choice. Their free tier is genuinely useful, the API is well-documented, and it works well for extensions that call the API on-demand (rather than from a server). Here's what I learned building Weather & Clock Dashboard for Firefox. The OpenWeat
r/startpages Is the Most Underrated Firefox Community You're Not Using If you care about browser customization, there's a subreddit you probably haven't found yet: r/startpages. With 35,000+ members, it's a community of people who genuinely care about what appears when they open a new browser tab. They share custom HTML/CSS homepages, new tab extensions, and browser startpage setups. The r/start
The New Tab Page Is Prime Real Estate. Are You Wasting It? You open a new browser tab dozens of times a day. Most people see either a blank white page, or a corporate-designed "inspiration" page they never asked for. That's a waste. Let's be conservative: 20 new tabs per day × 300 working days per year = 6,000 glimpses at your new tab page per year. Each glimpse lasts maybe 2-3 seconds before yo
Why Your Browser Extension Doesn't Need an Account (And Why That Matters) When I built Weather & Clock Dashboard for Firefox, I made a deliberate choice early on: no user accounts, ever. This might seem like a limitation. In practice, it turned out to be the extension's best feature. Look at most popular new tab extensions and you'll find the same pattern: Install the extension Create an account
5 Lessons I Learned Building a Firefox New Tab Extension from Scratch I spent the better part of a month building Weather & Clock Dashboard — a Firefox new tab extension that shows live weather, world clocks, and a search bar. No frameworks, no bundlers, just pure HTML/CSS/JS. Here's what I wish someone had told me before I started. manifest_version: 3 Transition Is Mostly Smooth, But Watch for
SQL is widely known for data querying and manipulation but systems do grow; data becomes larger; processes become repetitive and operations become sensitive. SQL has some features which enables it to be considered a fully fledged programming language. Some of the features which I discuss in this article are procedures, functions and transactions. Each of these concepts serve distinct purposes. Sto