Latest SQLite binary for June 2015

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

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

Click to expand...

Click to collapse

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.

Hi all, here is the archive of compiled binaries of the latest snapshot 201606031859 of SQLite for the next architectures:

1. armeabi
2. armeabi-v7a
3. arm64-v8a
4. mips
5. mips64
6. x86
7. x86_64

All binaries was compiled with PIE support. Archive includes:

• sqlite3-static
• sqlite3-dynamic
• libsqlite3.so

for each architecture.

You can download it here - sqlite-snapshot-201606031859-binaries-all-abi.7z. Also i was write a small guide how to compile SQLite using Windows PC and Android NDK, it's here. Initially it's in russian, but you can use Google Translate to read it.

New binary!

UPDATE: Just compiled this using latest stable source (3.21.0). Compiled static, includes readline support.

Command line used, if anyone's interested (on a Debian 9 box):

So I finally managed to update Sqlite after 5 months.

I am the busiest person I know, always trying to do a million things.

I rarely will drop a project, and when I do, I always leave some kind of explanation ( Just in case people wonder if the project is dead, etc )