Things which should exist, but don't yet:
- Transparent SQL Cache
Imagine a proxy listening on 127.0.0.1:3306, receiving SQL Queries.
Any query that was "SELECT .." could return the result from a local cache for the appropriate table. Any query of the form "UPDATE" or "INSERT" would flush all caches for the table.
Should be near-trivial: Hash the incoming query & parameters via SHA1sum to get a unique key then store/lookup results in Memcached.
Would it be useful? I think so, but of course it depends on the application and the effort involved.
- "Global status"
A single site that would rebroadcast a posted (short) status message to facebook/twitter/your chat client/etc/etc.
Hard part would be receiving comments from the sites it re-served to.
Scraping statuses from facebook is hard, not sure about twitter.
This concludes my Friday wishlist.
ObFilm: Master and Commander
