So here’s a little library/class that I wrote to make caching a little easier from project to project. WordPress requires a plugin like W3 Total Cache to be in place for “persistent” caching to be available … that is, caches of data that survive longer than the current page view. But sometimes when you’re building a complex custom project there are some queries you know could be safely cached regardless of the global caching setup. With this class you can build it right into your theme or plugin.
So I’ve been experimenting with this powerful web product called Caspio. It allows a novice user to create interactive databases without any programming knowledge. Some database familiarity is still required, but over all, this product tremendously simplifies the process of putting data online. I haven’t found their pricing info yet. Let’s hope it isn’t too expensive.
To show just what is possible, I created a database of 2007 Illinois School Spending Data. The data itself comes from iLearn and it took me just over 2 hours to set up my online database. Next time, it shouldn’t take nearly so long!