ase

The Scripting Layer for Android (SL4A) and the new SL4A Tablet Remix have a lot of powerful features and interestingly can be used to consume data from a variety of sources both online and offline. The ability to work with some data sources, such as simple relational databases is built in, but thanks to the ability to add additional code libraries to this environment we also get the opportunity to work with non-relational databases and even Linked Data. In this article I will quickly show you how to work with three different types of data source using Python in SL4A: a relational database in the form of a SQLite file, a non-relational database in the form of CouchDB and Linked Data generated from Wikipedia which we will interrogate using the SPARQL language.

*** UPDATE: The second version of this app has now been released. This page has been updated with the new version. *** A couple of days ago on the android-scripting Google group I was very pleased to announce the first release of the Scripting Layer for Android Tablet Remix also known as SL4A Tablet Remix. As the name implies this is a version of the Scripting Layer for Android that has been adapted for Android Honeycomb tablets, especially the Asus EEE Pad Transformer. There is still a lot of work to do on this app and a lot of improvements that can be made, but at last in is in a usable state and if you enjoy programming or want to learn about it this could be for you. The app builds on the fantastic work done by the contributors to the original SL4A project and extends functionality to being the Honeycomb look and feel to the app as well as extending the programming environment provided by SL4A to take advantage of some of the great features of the latest Android tablets.

Recently my evenings seem to have been disappearing in the blink of an eye. It is funny that when you get really into a bit of computer programming time can seem to disappear quite quickly. It can be quite a fun and mentally challenging way to spend time, not to mention absorbing. So I am hoping the project I am working on will enable more people to join that fun by writing small programs on their tablets. I am working on a version of the Scripting Layer for Android ("SL4A" – which used to be known as the Android Scripting Environment) and adapting it for tablets, especially the EEE Pad Transformer. The aim is to make the package work well on tablets and to adjust the user interface to make the most of the screen and new features such as the Action Bar.

Being a developer type I couldn't wait to start experimenting with coding on my new HTC Desire. Being Android powered it is very friendly and coding mainly takes place in Java, which I'm familiar with. This class of mobile device is incredibly powerful of course, armed not just with portability and web access but also decent processing power and a variety of sensors. We're still learning about what exactly this means and what opportunities it can bring and so it is very important to be able to experiment, try out ideas and build rough prototypes. This is where the Android Scripting Environment (ASE) comes in, and I used it to build a prototype application to scan a barcode on a book and use that code to see if it is in a library. Handy when deciding whether to buy a book!