Posts Tagged ‘iphone’

Create an iPhone version of your RSS feed easy

Here’s a sweet utility site, Intersquash.com. It’s a super fast way to create an iPhone friendly view of your RSS feed.

Here’s the iPhone version of ericfickes.com on Intersquash.

Pretty sweet service.

Cell Phone Reunion

I want to thank College Humor for making the most hilariously accurate iPhone video ever. I can’t stop watching this, it’s just too funny.  Here’s the original link in case there’s any embed issues – http://www.collegehumor.com/video:1899978

Two Animoto slideshows

Testing the embed feature of Animoto.  These two shows where made on my iPhone.  If you’re unfamiliar with Animoto I scribbled a quick review over at my iPhone blog.  If you have an iPhone and take lots of pictures, I suggest getting Animoto from the app store.

Denver Zoo blurry xmas lights

Wiretree December 2008

The phones have SQL, so does AIR

It’s pretty damn cool that the smartphones of today can run SQL databases.

Google’s Android has SQLite, which you can read about here.

Apple’s iPhone also has SQLite.

The SQLite library lets you embed a lightweight SQL database into your application without running a separate remote database server process. From your application, you can create local database files and manage the tables and records in those files. The library is designed for general purpose use but is still optimized to provide fast access to database records.  The header file for accessing the SQLite library is located in <iPhoneSDK>/usr/include/sqlite3.h, where <iPhoneSDK> is the path to the target SDK in your Xcode installation directory. For more information about using SQLite, go to http://www.sqlite.org.

Microsoft even has a mobile version of their SQL Server.  Of course they can’t seem to stick with a name for it.  SQL Server Mobile, SQL Everywhere, SQL Server Compact Edition, and currently SQL Server Compact 3.5

I’m just getting over the excitement about Adobe’s AIR having SQLite, and now my phone can run it too.  This makes for some interesting development choices.  In my opinion, being able to have a database on your device is one of the final steps of making a device a true platform.  Now it’s time to get dirty with some Sqlite coding.

By the way, I’d put this on my list of reasons why you should learn SQL.