Avoiding Data Corruption in SQLite 3.5.9 on Android 2.1

Quickly share your Android Code Snippets here...

Avoiding Data Corruption in SQLite 3.5.9 on Android 2.1

Postby I-Bickerstaff » Wed Apr 17, 2013 1:28 pm

Hi!

I'm working for a company that specializes in custom software development. Challenges are part of my daily routine and once I thought I want to share what my team has learned so far. You can find my thoughts here: http://cases.azoft.com/avoiding-data-corruption-in-sqlite/

In a nutshell:
When it comes to Android application development, it’s often desirable to ensure the app is compatible with older versions of the Android OS. A customer has recently asked us to make an application while keeping backward compatibility down to SDK version 2.1 (API level 7). While working on that project, we encountered a problem: the built-in SQLite version 3.5.9 had a known bug that appeared under certain conditions. Incidentally, SQLite caused the application to crash due to a "database disk image is malformed" error and the entire database was rendered unusable. We didn't find a solution for this problem on the web, so we created the following workaround after some experimenting.

Hope it's useful. Feel free to ask, suggest, and comment here or on the article page.
I-Bickerstaff
Freshman
Freshman
 
Posts: 3
Joined: Wed Apr 17, 2013 10:57 am

Top

Re: Avoiding Data Corruption in SQLite 3.5.9 on Android 2.1

Postby wakawaka » Wed May 15, 2013 7:16 am

Nice post.

I invite you to post similar articles on www.gssdaily.com

Worlds largest mobile app developer community.
Android Development Tutorials and Code Snippets: http://forum.gssdaily.com/
wakawaka
Experienced Developer
Experienced Developer
 
Posts: 79
Joined: Tue Jan 11, 2011 1:51 pm

Re: Avoiding Data Corruption in SQLite 3.5.9 on Android 2.1

Postby amixx » Tue May 21, 2013 5:09 pm

This is one of the challenge when it comes to Android development and it's very common.
amixx
Once Poster
Once Poster
 
Posts: 1
Joined: Tue May 21, 2013 4:22 pm

Top

Return to Code Snippets for Android

Who is online

Users browsing this forum: No registered users and 4 guests