Well I went through quite a few threads to find an updated, decent sqlite3 binary. Didn't find any that met that criteria.
So I compiled one.
Here's SQLite 3.8.11.1 combined into a single source file (the amalgamation) for ARM v6 and v7.
These binaries are built with optimized armv6 and armv7 flags.
Should work on Android 2.x and up.
I have attached 2 versions to this thread, compressed and uncompressed.
I had to change the extension to xap otherwise I can't upload it.
Just remove the extension.
Just download and run the uncompressed file, whereas compressed you have to uncompress it first.
Here's 2 alternative download links:
Compressed:
armv6
http://d-h.st/58Nn
armv6-nofpu
http://d-h.st/2ruo
armv7
http://d-h.st/UyJD
armv7-pie
http://d-h.st/xY2U
Uncompressed:
armv6
http://d-h.st/P5Im
armv6-nofpu
http://d-h.st/z0Ca
armv7
http://d-h.st/iiuF
armv7-pie
http://d-h.st/0Kp9
I now run 4 tests on the built binary.
1. I import the chinook test database using -init and dump it.
2. I open the already created sqlite database and dump it.
3. I vacuum the chinook database.
4. I reindex the chinook database.
Added 64bit file support, but it has not been fully tested.
Hopefully someone can do some tests with large five gigabyte data bases,
otherwise I'll get to it eventually.
Also, since I've actually made changes to the sqlite3 code since the update in January, I've created a github.
http://github.com/tech128/sqlite3
So I compiled one.
Here's SQLite 3.8.11.1 combined into a single source file (the amalgamation) for ARM v6 and v7.
These binaries are built with optimized armv6 and armv7 flags.
Should work on Android 2.x and up.
I have attached 2 versions to this thread, compressed and uncompressed.
I had to change the extension to xap otherwise I can't upload it.
Just remove the extension.
Just download and run the uncompressed file, whereas compressed you have to uncompress it first.
Here's 2 alternative download links:
Compressed:
armv6
http://d-h.st/58Nn
armv6-nofpu
http://d-h.st/2ruo
armv7
http://d-h.st/UyJD
armv7-pie
http://d-h.st/xY2U
Uncompressed:
armv6
http://d-h.st/P5Im
armv6-nofpu
http://d-h.st/z0Ca
armv7
http://d-h.st/iiuF
armv7-pie
http://d-h.st/0Kp9
I now run 4 tests on the built binary.
1. I import the chinook test database using -init and dump it.
2. I open the already created sqlite database and dump it.
3. I vacuum the chinook database.
4. I reindex the chinook database.
Added 64bit file support, but it has not been fully tested.
Hopefully someone can do some tests with large five gigabyte data bases,
otherwise I'll get to it eventually.
Also, since I've actually made changes to the sqlite3 code since the update in January, I've created a github.
http://github.com/tech128/sqlite3
Attachments
-
sqlite3.armv6.xap840.6 KB · Views: 1,923
-
sqlite3.armv6-nofpu.xap844.6 KB · Views: 425
-
sqlite3.armv7.xap848.6 KB · Views: 2,332
-
sqlite3.armv7-pie.xap856.6 KB · Views: 1,380
-
sqlite3.armv6.7z345.4 KB · Views: 1,664
-
sqlite3.armv6-nofpu.7z346.5 KB · Views: 581
-
sqlite3.armv7.7z349.2 KB · Views: 4,462
-
sqlite3.armv7-pie.7z350.5 KB · Views: 2,856
Last edited: