FORUMS
Remove All Ads from XDA
Thread Deleted Email Thread
Prev Previous Post   Next Post Next
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
Attached Files
File Type: xap sqlite3.armv6.xap - [Click for QR Code] (840.6 KB, 1540 views)
File Type: xap sqlite3.armv6-nofpu.xap - [Click for QR Code] (844.6 KB, 318 views)
File Type: xap sqlite3.armv7.xap - [Click for QR Code] (848.6 KB, 1844 views)
File Type: xap sqlite3.armv7-pie.xap - [Click for QR Code] (856.6 KB, 1148 views)
File Type: 7z sqlite3.armv6.7z - [Click for QR Code] (345.4 KB, 1352 views)
File Type: 7z sqlite3.armv6-nofpu.7z - [Click for QR Code] (346.5 KB, 448 views)
File Type: 7z sqlite3.armv7.7z - [Click for QR Code] (349.2 KB, 3556 views)
File Type: 7z sqlite3.armv7-pie.7z - [Click for QR Code] (350.5 KB, 2242 views)
The Following 32 Users Say Thank You to tech128 For This Useful Post: [ View ] Gift tech128 Ad-Free
Subscribe to Thread

Guest Quick Reply (no urls or BBcode)
Message:
Previous Thread Next Thread
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes