Latest SQLite binary for June 2015

tech128 · Apr 25, 2014

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

soreaga · Apr 26, 2014

is this will work on other device ?

my device is sony xperia C JB 4.2.2

juejiang · May 3, 2014

usefult app

usefult app,Thanks for sharing

tech128 · May 3, 2014

soreaga said:
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

E:V:A · May 27, 2014

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...

joluke · May 27, 2014

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

E:V:A · May 31, 2014

@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.)

tech128 · Jun 1, 2014

E:V:A said:
@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.

kien_vip · Aug 14, 2014

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

tech128 · Aug 31, 2014

kien_vip said:
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.

phangs23 · Sep 29, 2014

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.

fr3quency · Oct 11, 2014

Armv6 flags? So it's useless on Nexus 4/5 etc with armv7 CPUs? Can we find one which is optimised for high end devices?

tech128 · Nov 11, 2014

fr3quency said:
Armv6 flags? So it's useless on Nexus 4/5 etc with armv7 CPUs? Can we find one which is optimised for high end devices?

No not useless, just less than optimal. Not really sure of the speedup, since I don't do benchmarks. I try to optimize it as much as possible without breaking it x_X

I was initially planning to put out both armv6 and armv7 ports at the same time, but then I realized most android utilities aren't compiled with proper 64bit file support.

So I've been trying to figure that out first. And also, most people don't use sqlite for anything earth-shattering anyway, mostly vacuum, reindex, create database from sql statements, etc.

Oooooo just saw this while searching for sqlite performance enhancements. https://sqlite.org/src4/doc/trunk/www/design.wiki

Very nice.

I'd also like to try to switch to musl as the standard library since alireza7991 has said it makes things smaller and faster. Not sure how feasible that will end up for me though...

It doesn't look like sqlite can parallelized at all though. See here: http://blogs.perl.org/users/timm_murray/2013/02/sqlite-and-writes.html

There is a fork/variant of sqlite called paralite that uses threading, but I don't think it retains the same file format compatibility and it looks like it introduces some bugs.

Unfortunately real life stuff takes precedence so things will progress slower than I would like. But at least I know there's lots to look forward to even just for sqlite lol.

nanobrain · Nov 20, 2014

Will it work on L?

My current sqlite3 binary won't work on Lollipop because it needs to be a PIE (position independent executable) and so far I haven't been able to find one compiled that way. Is yours?

Thanks

maττ · Nov 30, 2014

nanobrain said:
My current sqlite3 binary won't work on Lollipop because it needs to be a PIE (position independent executable) and so far I haven't been able to find one compiled that way. Is yours?

Thanks

I'll attach one that I have working for me. You'll need to extract the zip and then place sqlite3 in /system/xbin and then you should be able to call your sqlite3 similar (if not the same) as you did before.

nanobrain · Nov 30, 2014

maττ said:
I'll attach one that I have working for me. You'll need to extract the zip and then place sqlite3 in /system/xbin and then you should be able to call your sqlite3 similar (if not the same) as you did before.

Mahalo

tdunham · Dec 11, 2014

maττ said:
I'll attach one that I have working for me. You'll need to extract the zip and then place sqlite3 in /system/xbin and then you should be able to call your sqlite3 similar (if not the same) as you did before.

This SQLite seems to be Android L (5.0) compatible on the Galaxy S5.
I appreciate the upload as well. I was getting the PIE errors too when trying to verify sql scripts were running.

maττ · Dec 11, 2014

nanobrain said:
Mahalo

tdunham said:
This SQLite seems to be Android L (5.0) compatible on the Galaxy S5.
I appreciate the upload as well. I was getting the PIE errors too when trying to verify sql scripts were running.

Awesome! Glad to hear this helped you out. I was in a pickle with that one when it first came out as well because a lot of my Tasker stuff depends on sqlite.

eyesfortech · Dec 12, 2014

Thanks for this, I am one of those enthusiasts who focuses on tweaking my phone and I am currently testing your version of sqlite3 on my MT6582 devices.

On my script, your version of sqlite3 is working like a charm... I will still observe.

Here's a snippet of my defrag script.

Database /data/data/com.android.dialer/databases/dialer.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.android.providers.downloads/databases/downloads.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/upload_queue.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/google_analytics.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/plus.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/node.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/gcore_ulr_UlrLocation.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/gcore_ulr_ActivityDetection.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/gcore_ulr_ApiMetadata.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/keys.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/ns.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/rmq.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/playlog.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/gcm_registrar.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/peoplelog.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/pluscontacts.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/connectionconfig.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/google_account_history.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/data/com.google.android.gms/databases/dg.db: VACUUM=SUCCESS REINDEX=SUCCESS

eng.ahmed.android · Dec 12, 2014

What is sqlite binary?

I am an android developer and using sqlite database but i didn't hear before about sqlite binary!
Could you please explain me what is this ?

Thanks in advance

Latest SQLite binary for June 2015

Senior Member

Attachments

New member

Member

Senior Member

Inactive Recognized Developer

Senior Member

Inactive Recognized Developer

Senior Member

Senior Member

Senior Member

Member

Senior Member

Senior Member

Member

Member

Attachments

Member

Inactive Recognized Contributor

Member

Senior Member

Senior Member

Similar threads

Top Liked Posts