Andrea Olivato’s Blog

Create a simple and good looking API system using PHP + MySql + Apache mod_rewrite, dealing with different formats and types of request.

Learn how to make inserts or selects in your DataBase basing your queries on passed parameters and requested methods.

This is an in-development post. I will update it regularly to add new services. If you want to contribute, please jump to comments and leave your link + shortcut.

I preferred a very short keyword to maximize the usefulness of these shortcuts. You can obviously decide to use a more descriptive keyword using more letters.
How to [...]

If you own a very large Wordpress installation like the one I’m dealing with on LinuxFeed, you probably can not manually look for empty categories and remove them from the admin panel.
With 13.000+ posts and 14.000+ categories it’s quite impossible to use Wordpress GUI for management, and great plugins like WP-Optimize or Optimize DB might [...]

Just a few minutes ago I received an email from the Seesmic team sharing the beta preview of their 0.6.3 new version, featuring a full twitter lists support.
I installed the new .air package and started playing with it. Integration seems complete, and honestly I didn’t find any bug on lists actions.
As shown on the image [...]

The usage of twitter by its own web interface or via the most recent clients, accustomed users to see linked @usernames and #hashtags inside any status update they read.
When using Twitter API on your own website, service or app, you need to deal with plain text tweet, with no tags so no links. Using Regular [...]

I do Love eselect!
For those who don’t know eselect is a ‘modular administration and configuration framework’. In simpler words it is a management tool shipped with Gentoo, able to switch between packages versions and configurations files, working with symbolic links and environmental variables.
Just to better clarify eselect job, it is able to make you [...]

When trying to access the original feed of a blog (or website) which makes use of Feedburner, your crawler ( or browser or script ) usually receives a 301 header, redirecting it to the Google version of the feed. This means that if you need to access the original source ( for faster aggregation, to [...]

If you use Twitter daily (hourly maybe), you’ll probably know about #FollowFriday trend. If not, I suggest you to read this simple introduction by Mashable.
Even if some appreciated twitterers no longer make use of #FF, I believe it is still a good tool to enhance relationships and improve yours and your followers twitter experience.
Writing a [...]