Archive for category SQLite

Android Database Application

Posted by Simon Judge, Freelance Mobile Developer in Android, Android Market, Database, Getting Started, My Commercial Apps, SQLite, phones on March 18th, 2010

iconI have just completed and published a database application for Android. It allows databases to be created on the phone or PC (using free 3rd party SQLite tools) and viewed in a list or card format. More information can be found at AndroidDatabase.info.

Developing the application was a lot more difficult than I initially thought because if you use the default framework and database mechanisms provided by the SDK then you run into performance problems with medium size databases.

Failure 21 (out of memory) on 0×0 when preparing

Posted by Simon Judge, Freelance Mobile Developer in Android, Coding, SQLite on March 18th, 2010

Woking with SQLite databases, I came across another misleading error yesterday. If you are getting the following error…

Failure 21 (out of memory) on 0x0 when preparing

…while going something in SQLite then this message probably doesn’t mean what it says. I spent a while trying to reduce memory usage until I realised my SQL had invalid syntax.

So if you get this error, first look to see if your SQL is correct!