Your X Pure is ARM64 like the Nexus 6P. The sqlite3 binaries I've found are all for 32 bit processors. None of them worked.
Latest SQLite binary for June 2015
- Thread starter tech128
- Start date
Your X Pure is ARM64 like the Nexus 6P. The sqlite3 binaries I've found are all for 32 bit processors. None of them worked.
That's what I figured. Keep me in mind if you find something that works. I guess I'll keep searching.
Hi, how to do a statement in WAL mode?
I get often error: database is locked.
I need that select statement work always while delete or insert statement is in progress.
I get often error: database is locked.
I need that select statement work always while delete or insert statement is in progress.
I got this on the Nexus 6P after placing in /system/bin:
CANNOT LINK EXECUTABLE: "/system/lib64/libstdc++.so" is 64-bit instead of 32-bit
page record for 0xf757103c was not found (block_size=16)
At least the executable that's causing an error is different than before...?
Last edited:
Maybe a solution:
h**ps://play.google.com/store/apps/details?id=com.jordanhotmann.taskersqliteplugin
It doesn't work for me yet but it's a beginning.
Edit:
Finally working with 64 bit exec from here and normal Tasker shell action. Just enter this before (return after and then normal sqlite3 command): su -cn u:r:system_app:s0
h**ps://groups.google.com/forum/?fromgroups#!topic/tasker/CQ1zoxisluo
h**ps://groups.google.com/forum/?fromgroups=#!topic/tasker/_XBxvx5nww8
h**ps://play.google.com/store/apps/details?id=com.jordanhotmann.taskersqliteplugin
It doesn't work for me yet but it's a beginning.
Edit:
Finally working with 64 bit exec from here and normal Tasker shell action. Just enter this before (return after and then normal sqlite3 command): su -cn u:r:system_app:s0
h**ps://groups.google.com/forum/?fromgroups#!topic/tasker/CQ1zoxisluo
h**ps://groups.google.com/forum/?fromgroups=#!topic/tasker/_XBxvx5nww8
Last edited:
SQLite 3.13.0 has been released yesterday, can anyone compile it for Android with PIE support? Thanks
http://www.sqlite.org/releaselog/3_13_0.html
Inviato dal mio Nexus 4 con Tapatalk 2
http://www.sqlite.org/releaselog/3_13_0.html
Inviato dal mio Nexus 4 con Tapatalk 2
sqlite3 xiaomi mi4 marshamallow working
http stackoverflow com/questions/3645319/why-do-i-get-a-sqlite3-not-found-error-on-a-rooted-nexus-one-when-i-try-to-op and PIE armv7 version of sqlite3 worked for me. Thanks.
Came in here to automate 3G to 2G switching
http stackoverflow com/questions/3645319/why-do-i-get-a-sqlite3-not-found-error-on-a-rooted-nexus-one-when-i-try-to-op and PIE armv7 version of sqlite3 worked for me. Thanks.
Came in here to automate 3G to 2G switching
Hi all, here is the archive of compiled binaries of the latest snapshot 201606031859 of SQLite for the next architectures:
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.
- armeabi
- armeabi-v7a
- arm64-v8a
- mips
- mips64
- x86
- x86_64
- sqlite3-static
- sqlite3-dynamic
- libsqlite3.so
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.
I understand that it may be a stupid question. I'm using CM 13. I would like to know which file I should put at what location
Thanks a lot!
Similar threads
Top Liked Posts
-
There are no posts matching your filters.
-
33Well 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/sqlite39
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.8Hi all, here is the archive of compiled binaries of the latest snapshot 201606031859 of SQLite for the next architectures:
- armeabi
- armeabi-v7a
- arm64-v8a
- mips
- mips64
- x86
- x86_64
- sqlite3-static
- sqlite3-dynamic
- libsqlite3.so
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.6New 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
