[PATCH] Port of SQLJet to Android

[GoogleCodeExporter]

Hello all,

I am Nicolas Raoul, working on the open source project "AnkiDroid", an Android 
flashcards application.

We use Android's native SQLite library, but some devices come with a buggy one, 
so in those cases we would like to switch to a pure-Java SQLite library like 
SQLJet.

After trying a bit, it seems to work well! Unfortunately, Android does not have 
java.lang.management.ManagementFactory so I had to modify SqlJetFile.java a bit.

Do you want SQLJet to be Android-compatible?
I think it would be cool :-)
If yes, you might want to create a Android-targeted JAR, or even remove the PID 
logging if it is not absolutely necessary, or find a trick to do it only on 
platforms where ManagementFactory is available.

By the way, thanks a lot for this great project!

https://github.com/nicolas-raoul/Anki-Android/commits/sqljet

Original issue reported on code.google.com by nicolas.raoul@gmail.com on 1 Aug 2011 at 6:52

Attachments:

• sqljet-android.patch

[GoogleCodeExporter]

Thanks!

Original comment by sergey.s...@gmail.com on 1 Aug 2011 at 7:56

[GoogleCodeExporter]

Hi Nicolas!

I committed your patch into SqlJet's 'trunk'. Could now you test on Android the 
SqlJet built from 'trunk' ?

Thanks in advance.

Original comment by sergey.s...@gmail.com on 2 Aug 2011 at 2:35

[GoogleCodeExporter]

Thanks a lot for the very fast integration!
I will try.

Original comment by nicolas.raoul@gmail.com on 2 Aug 2011 at 2:37

[GoogleCodeExporter]

You may get JAR at 
http://teamcity.tmatesoft.com/repository/download/bt12/1280:id/Binaries+and+Sour
ces/sqljet-1.1.0-SNAPSHOT_r1153_v20110801_2257-all.zip

When it ask you about login and password just click 'Login as guest'

Original comment by sergey.s...@gmail.com on 2 Aug 2011 at 2:44

[GoogleCodeExporter]

This issue is now fixed in 1.0.x branch of SqlJet and will be included into 
v1.0.8

Original comment by kit...@gmail.com on 15 Aug 2011 at 5:41

• Changed state: Fixed

[GoogleCodeExporter]

Hi! Just to let you know that this Android application uses SQLJet :-)
http://ankidroid.googlecode.com/files/AnkiDroid-1.0beta12sqljet.apk

We actually use SQLJet in parallel with Android's standard SQLite library, in 
order to circumvent this issue:
http://stackoverflow.com/questions/7764943/android-deletes-corrupt-sqlite-files-
automatically

Cheers!
Nicolas

Original comment by nicolas.raoul@gmail.com on 17 Oct 2011 at 3:11

[GoogleCodeExporter]

That's great! :)

Original comment by sergey.s...@gmail.com on 17 Oct 2011 at 8:47