Browsing All Posts published on »August, 2011«

Tea Dragons Posters

August 19, 2011

0

Here’s a couple of posters I made for Hannah’s Tea Dragons tea stall at the Big Chill festival. One of them – Elixir of Desire – introduces a new (a vintage french nude) lady into the Tea Dragons tribe. These colours aren’t quite correct as they were produced for print in CMYK but I still think […]

Eclipse – Could not find App.apk!

August 19, 2011

1

I started running into trouble with Eclipse this morning when I was trying to build and install an app onto my phone. The project seemed to build Ok and I got no obvious errors in the console during packing  but when  ADB tried to push the .apk to the phone I kept getting this error […]

Android SQLite Tip 2 – Use compiled SQL statements

August 16, 2011

4

In my last article  I talked about SQL Lite inserts on Android being optimised using a transaction. Another method I’ve found that speeds things up dramatically is to use compiled SQL statements with the SQLiteStatement class. I can’t believe I hadn’t used these before, I actually think working with a compiled statement is much nicer than working with the  standard SQL […]

Android SQLite tip 1 – Wrap batches of writes in a transaction

August 16, 2011

4

I’ve been working on the Shhmooze Android app. When the app is first run there are quite large amounts of data that need to be downloaded and persisted to an Android SQLLite db on the device(around 200o records). I was running into an issue where these writes to the db were taking a very long […]