Latest SQLite binary for June 2015

Search This thread

mctiew

Senior Member
Feb 20, 2014
174
27
Tried running it in terminal emulator and adb, works.

Tried running it in TWRP terminal, says not found.

Is there any version I should be using ?

Tested based on the static version with arm64-v8a and armeabi-v7a.

I wanted to use it in TWRP to edit something when the system isn't working.
 
Last edited:

ultrasound1991

Senior Member
Jan 11, 2014
264
44
Lecce
Hi, i am able to get notifications count from facebook app with this statement:

sqlite 3 /data/data/com.facebook.katana/databases/notifications_db "SELECT COUNT(seen_state) FROM gql_notifications WHERE seen_state = 'UNSEEN_AND_UNREAD';"

Do someone know how to get friend request number?
 

TripCode

Senior Member
Mar 13, 2014
171
162
Thank you so much, you've been kind to post it also here. Can you point me to instructions on how to build the SQLite for Android exclusively?

You're welcome.

See: https://github.com/stockrt/sqlite3-android

1.) Edit Makefile
Code:
# http://www.sqlite.org/download.html
SQLITE_VERSION  ?= 3150000
SQLITE_BASENAME := sqlite-amalgamation-$(SQLITE_VERSION)
SQLITE_URL      := http://www.sqlite.org/2016/$(SQLITE_BASENAME).zip

2.) Install Android NDK: https://developer.android.com/ndk/downloads/index.html (if not already installed and set the paths)

3.) Run make

Simple. :)

If you want Android specific mods you can find the sources here: https://android.googlesource.com/platform/external/sqlite/
 

khyr

Senior Member
Aug 14, 2015
82
10
How to install?
Sorry about my noobie question ?
In system/xbin
The 3 or in system/lib
Giving it 755 permission
I dont know
How can I check if is working
Thanks in advance
 

Hoothoot

Member
Nov 26, 2014
21
2
Are those compatible with ARMv8-A 64-bit devices? Really need help here^^

edit: nevermind used tasker plugin instead
 
Last edited:

idcrisis

Senior Member
Aug 30, 2010
1,428
5,742
32-bit armv5 binaries run on everything 32-bit.

It is difficult to fathom why on earth for some induced obsolescence people actually use those extra instructions after thumb.

Breaks all sorts of backward portability. Almost assuredly at any optimisation level, the v7 instructions can offer zero speedup.

Instead they should use CLANG so the binary doesn't change even if the CPU is changed to open source.

And hand optimise the underlying C virtual machine if at all. Or machine optimise that keeping the API intact.

And the 64-bit ecosystem is 100 times more expensive because scale has been achieved with the 5 dollar Allwinner board. For again zero speedups.

And the heap size of 256 mb is just wrong when 64mb has proven quick startup and run and cohabitation. Thus halving the effective cost of RAM.

Therefore proving once and for all, that there is an intentional induced obsolescence in all of these devices.

What can developers do, discard 64-bit, reduce heap to 64-bit, and hone in on the perfect set of compiler flags for eg Entware ( their v5 binaries as base not even their v7) to run on all Android. And ART.

Even the JVM flags standardised across all Android. Possibly investigate if the java native compiler can or is in ART so that the JVM is not used at all.

That's a start.
 
Last edited:
  • Like
Reactions: alecxs

d_borghi

Senior Member
Mar 3, 2012
163
3
Hi all,
Anyone know why i can't install sql3 and relative binaries in my xiaomi redmi 3, miui?
 

myionzolo

New member
Aug 21, 2015
2
0
Ftse support

Please add FTSE support for arm8 ?

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.
 

ravilov

Senior Member
Jan 26, 2010
2,217
1,346
localhost
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
 

Attachments

  • sqlite3-3.21.0-armv7.zip
    752 KB · Views: 254

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 )