A few weeks ago I decided to set up a new service on my personal website to track all the social services that I’m a part of. Basically I wanted a central place where people could go to find out what I was up to, what pictures I was posting, and where I’d been. Now, I know there are services like FriendFeed and Socialthing! that do this on a larger scale but I don’t foresee many of my family members signing up for those just to see what I’m up to.

Enter Sweetcron, a free Wordpress like PHP and MySQL content system specifically built to handle lifestreaming. I heard about Sweetcron from my buddy Ryan and decided to give it a try for my new site. To my excitement it was exactly what I was looking for. Below I’ll cover the installation, interface, and end result of my Sweetcron experience.

Installation

Sweetcron is the easiest content system I’ve set up in quite some time. You download the compressed files and upload them to your server, create a MySQL database, and edit a few lines of a configuration file with the info. Once this is done the script has a built in installer that runs to finish the installation. By the time you’ve gone through this process you’ll have a username and password through which you can login to your Sweetcron administration section.

Interface and Use

Once you’ve logged into the back-end of Sweetcron you’ll see a few pretty basic options. Write: for posting quick notes, items: a list of your imported (published or unpublished) feed items, feeds: a list of the feeds you’re importing, and options: which contains basic account settings. Setting up your feeds to be imported into your lifestream is a piece of cake. Grab RSS from your favorite social networks and add them into your feed list¹.

Adding a Feed

Feed List

Imported Items

Sweetcron will automatically format and grab the necessary items related to the feeds. From there you can select from a few different themes of how you want your information to be displayed. If you’re ambitious you can set up your own theme by using the Sweetcron documentation.

Pulling Results via Cron

As the name suggests Sweetcron is reliant on pulling information from your RSS feeds at a regular interval in order to update your database. To do this Sweetcron works in one of two ways. First, you can use a pseudo method that will have Sweetcron update itself if the last update is older than 30 minutes. This method waits for someone to hit the site and then has that visit trigger the fetch. This may work for people without cron hosting access but I found the normal cron method to work better. To set this up I logged into my hosting administration and had the following cron job run every fifteen minutes:

/usr/bin/curl -s http://your-url.com/cron/link Note that sweetcron uses curl and this program may be located at different locations on different hosting providers, for instance:

curl -s http://your-url.com/cron/link

End Result

The end is a great looking lifestream that stores all of your information into a MySQL database that you host. The benefits are awesome. First, you own look and feel of the information output. Second, you don’t have to rely on a 3rd party service. And last, the whole setup is opensource, free, and easy to set up.

1. If you have issues with a particular feed’s RSS being supported I’d suggest routing it through Feedburner first and then importing it into Sweetcron. I had to do this with Brightkite.