A leaderboard with a scheduled reset
Rank from a summary table rather than the raw ledger, snapshot the winners before you clear, and pay from the snapshot.
Tagged “mysql”
8 entries
Count unique visitors without a cookie
A daily rotating hash and a unique index. Honest numbers, nothing personal stored, and no consent banner needed for it.
A surf engine that cycles a visitor through sites
Server-held session state, one destination at a time, dwell enforced on the server. The core of a traffic exchange in one table and two functions.
An admin view that shows you who is farming you
Four queries — earnings concentration, shared visitor keys, signup velocity, payout-to-activity ratio — that surface abuse without a fraud engine.
A migration runner that is safe to run twice
Numbered SQL files, a table of what has run, and a splitter that does not break on semicolons inside strings.
Serve a banner with a rotation and a house fallback
Pick a creative that matches the slot size, prefer one the visitor has not already been paid for today, and never leave the slot empty.
A zero-filled daily series for charts
GROUP BY date skips days with no rows, which makes every chart lie. This fills the gaps before the data reaches the chart.
A sliding-window rate limiter in MySQL
No Redis, no extension, no cron. One table and one function that caps any action per key within any window, and fails open so an outage never locks the site.