• Introducing XDA Computing: Discussion zones for Hardware, Software, and more!    Check it out!

Latest SQLite binary for June 2015

Search This thread

Top Liked Posts

  • There are no posts matching your filters.
  • 33
    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
    9
    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.
    8
    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.
    6
    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):
    Code:
    arm-linux-gnueabihf-gcc-6 -march=armv7 -pipe -pie -I. -DSQLITE_THREADSAFE=0 -DSQLITE_ENABLE_EXPLAIN_COMMENTS=1 -DYYSTACKDEPTH=0 -DHAVE_READLINE=1 $( ncursesw5-config --cflags ) -fno-strict-aliasing -O3 -L. -Wl,--no-as-needed -Wl,--no-dynamic-linker *.c -static -ldl -lreadline -lhistory $( ncursesw5-config --cflags ) -s -o sqlite3-3.21.0-armv7
    6
    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 )