FORUMS
Remove All Ads from XDA

Latest SQLite binary for June 2015

162 posts
Thanks Meter: 112
 
By tech128, Senior Member on 25th April 2014, 04:34 AM
Post Reply Email Thread
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, 1514 views)
File Type: xap sqlite3.armv6-nofpu.xap - [Click for QR Code] (844.6 KB, 316 views)
File Type: xap sqlite3.armv7.xap - [Click for QR Code] (848.6 KB, 1824 views)
File Type: xap sqlite3.armv7-pie.xap - [Click for QR Code] (856.6 KB, 1144 views)
File Type: 7z sqlite3.armv6.7z - [Click for QR Code] (345.4 KB, 1330 views)
File Type: 7z sqlite3.armv6-nofpu.7z - [Click for QR Code] (346.5 KB, 446 views)
File Type: 7z sqlite3.armv7.7z - [Click for QR Code] (349.2 KB, 3478 views)
File Type: 7z sqlite3.armv7-pie.7z - [Click for QR Code] (350.5 KB, 2184 views)
The Following 31 Users Say Thank You to tech128 For This Useful Post: [ View ] Gift tech128 Ad-Free
 
 
26th April 2014, 05:49 PM |#2  
Junior Member
Thanks Meter: 0
 
More
is this will work on other device ?

my device is sony xperia C JB 4.2.2
3rd May 2014, 02:11 PM |#3  
Junior Member
Thanks Meter: 2
 
More
usefult app
usefult app,Thanks for sharing
3rd May 2014, 04:45 PM |#4  
tech128's Avatar
OP Senior Member
Thanks Meter: 112
 
More
Quote:
Originally Posted by soreaga

is this will work on other device ?

my device is sony xperia C JB 4.2.2

Yes this will work on any android device that has android 2.0 or higher.

So it will work fine on your sony xperia C JB 4.2.2
The Following 2 Users Say Thank You to tech128 For This Useful Post: [ View ] Gift tech128 Ad-Free
27th May 2014, 10:34 PM |#5  
E:V:A's Avatar
Recognized Developer
Flag -∇ϕ
Thanks Meter: 2,168
 
More
Did someone test this on a Samsung? I'm asking because this binary is dynamically linked and thus dependent on libraries not being non-standard...
27th May 2014, 10:45 PM |#6  
Senior Member
Thanks Meter: 415
 
More
Does this app:

[Play Google] SQLite Installer for Root

Do the same? But this one is dated from 1 of March of 2014... don't know if it does include the up to date binary

Edit: Only includes the following versions:
3.7.16
3.7.15.1
3.7.15
3.7.14
3.7.11

So yours is up to date
31st May 2014, 10:40 PM |#7  
E:V:A's Avatar
Recognized Developer
Flag -∇ϕ
Thanks Meter: 2,168
 
More
@tech128 If you want your sqlite3 to be device independent you have to make it statically linked. You current version does not work on my 4.2.2.
(It runs, but crashes as soon as you specify a db file, because of unmatched .so files.)
1st June 2014, 01:55 AM |#8  
tech128's Avatar
OP Senior Member
Thanks Meter: 112
 
More
Quote:
Originally Posted by E:V:A

@tech128 If you want your sqlite3 to be device independent you have to make it statically linked. You current version does not work on my 4.2.2.
(It runs, but crashes as soon as you specify a db file, because of unmatched .so files.)

@E:V:A

It is a honor to have you post in my thread. Thank you for letting me know it does not work on your system.

I have read many of your threads, extremely informative. One day I hope to memorize all of what you have written.

I compiled sqlite3 dynamically because it is a little easier on the memory subsystem and has a smaller output filesize.

I tested it on several android 2.3 / 4.3 / 4.4 systems and they all seemed to work fine so I thought it would be ok.

Especially since all that is dynamically referenced is libc and libdl.

I have just compiled a static version but I need to test it before posting it.

I will update the op soon.
14th August 2014, 08:07 AM |#9  
Senior Member
Flag Gốc Chuối
Thanks Meter: 253
 
More
your sqlite3 can reindex, but it can not vaccum. u can re-check it
31st August 2014, 07:56 PM |#10  
tech128's Avatar
OP Senior Member
Thanks Meter: 112
 
More
Quote:
Originally Posted by kien_vip

your sqlite3 can reindex, but it can not vaccum. u can re-check it

@kien_vip

Thank you for letting me know about this issue.

I test sqlite before I release it, but there are no test suites for it, barring one which requires tcl, which I have no desire to compile since there's no other use for it.

The current sqlite can probably only reliably work with databases up to 2 or 4 GB

Which usually isn't a problem since most sqlite databases are well under that amount.

I've been trying to compile an updated sqlite with proper 64 bit file support.

Since 64 bit file support is a bit wonky on android, this has been a bit tough.

Also, I've been rather busy since I last released the binary, so I haven't had much time to think about compiling in general.

I'll do my best to get a new binary out soon-ish.
29th September 2014, 01:03 PM |#11  
phangs23's Avatar
Member
Thanks Meter: 6
 
More
How do I use this? please help, I'm doing a research on how to speed up an application that uses sqlite database. Right now, this is one option.
Post Reply 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