Latest SQLite binary for June 2015

tech128 · Oct 14, 2015

@ReneLeonhardt

Thank you so much for providing the binaries to include the latest and much faster SQLite into Android apps!

Would it be possible to add binaries for the Intel platform to your build process in order to allow testing apps in the accelerated "Intel x86 Atom System Image"? Since Android 5 there also are Atom_64 images...
Sure I can compile x86 and x86-64 binaries if you want...
Are the release builds optimized for space to minimize the resulting APK size?
No they are optimized for speed, that's mostly a personal preference. I want everything blazing fast.
I think if I optimized for space, it wouldn't be too much smaller anyway. I can do a test run if you want to know...
Would it be possible to cooperate with Zetetic.net /sqlcipher/sqlcipher-for-android/ to create encrypted databases with the latest SQLite driver?
Well I checked into that, and it looks like quite a lot of work. I don't feel that having encryption built into sqlite is really that important.
If you need it, you can just run a kernel module or fuse mount to encrypted container / filesystem.
Or you can use openssl or similar to encrypt / decrypt the sql file.

Thank you and keep up the good work, greetings from Germany!

ReneLeonhardt · Oct 14, 2015

SQLite 3.9.0 released with JSON and FTS5 awesomeness!

tech128 said:
Sure I can compile x86 and x86-64 binaries if you want...

No they are optimized for speed, that's mostly a personal preference. I want everything blazing fast.
I think if I optimized for space, it wouldn't be too much smaller anyway. I can do a test run if you want to know...

Well I checked into that, and it looks like quite a lot of work. I don't feel that having encryption built into sqlite is really that important.
If you need it, you can just run a kernel module or fuse mount to encrypted container / filesystem.
Or you can use openssl or similar to encrypt / decrypt the sql file.

Thank you, x86 and x86-64 binaries would be very helpful for debugging apps in the emulator!
If you could make a quick space check for ARM would be nice to know, to keep the APK download size as small as possible.
But you are right, in the end it will be not much smaller anyway, and the resulting APK is ZIP compressed...
I can understand you, the performance optimizations are huge, twice as fast as SQLite 3.8.0, that's good!
Thanks for checking it out! But how could an Android app load a kernel module or mount an encrypted container?
(En- and) Decrypting would be another use case, not connecting/reading/writing many times inside a started/paused/resumed app...

Today 3.9.0 has been released with even more goodies, JSON functions, the awesome new FTS5 (still experimental), indexes on expressions, ...!
sqlite.org /releaselog/3_9_0.html
Maybe you can check if you can compile in the Encryption Extension, then at least paying developers could transparently en-/decrypt their files:
sqlite.org /see/doc/trunk/www/readme.wiki

MichaelEdevag · Oct 14, 2015

need to get 10 posts for developer forum

hansmoon · Oct 17, 2015

deleted

gopi.g · Oct 21, 2015

How can binary file supported to htc pico

Rydah · Oct 21, 2015

hansmoon said:
http://www.mediafire.com/download/hfqw8v3snz0hgbn/sqlite3

i compiled sqlite3 arm 3.9.0 with FTS5.
not x86.
Try it...

Sent from my SHV-E210S using XDA Free mobile app

armv8-pie support would be nice.

hansmoon · Oct 22, 2015

deleted

Rydah · Oct 22, 2015

hansmoon said:
https://github.com/stockrt/sqlite3-android

You Can Compile SQLITE3 Excutable Binary... Also...

What's the process? I didn't understand it. LOL

hansmoon · Oct 23, 2015

deleted

vrgolin · Oct 25, 2015

gys , where can i find SQLite mods?

osygen · Oct 27, 2015

Just confused, how do I know which one works with galaxy s4.

frwerewolf · Oct 29, 2015

I have a galaxy s6 edge plus on lollipop 5.11 rooted and exposed. I wanted to install whatsappX module but sqlite installer is requested. The apk ones i found on the web don't work. So i read your posts but didnt understand everything. Could someone tell me which one to install and get it from where ? Thanks a lot.

amplatfus · Nov 6, 2015

sqlite3 64bits

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.

Thank you so much.
Please where from you have it? Because I will be looking for the 64bits version.

BR,
amplatfus

tech128 · Dec 12, 2015

@hansmoon

Not nice, you should ask for permission before posting your binaries in other people's threads..

@gopi.g

Well the htc pico is armv7, so I would go with either armv7 or armv7-pie
@ReneLeonhardt

I tried to compile an x86 and x86_64 version for you, but there was an issue.

I re-worked the compile.sh and got it to compile x86 and x86_64 code, but there are several functions needed that aren't present in the ndk.

I was able to find them for arm, but I'd have to go looking for x86 and x86_64 versions.

Also, this last weekend, my server decided to fall on its face.

Which of course has all of my dev stuff.

Luckily I was able to convince the hard drive to spin back up once more and back everything up.

But I've since spent the entire week rebuilding it from scratch (I kind of wanted to do that anyway..)

I'll try to include the encryption extension when I can get back to dev stuff.
@Rydah

I'll look into armv8-pie when I can get everything back to normal (or close to it)

Still got a lot do before that can happen.
@vrgolin

Not sure what mods you are referring to?
@osygen

I would use the armv7-pie one. That would work the best for the S4.

@frwerewolf

Yeah I should probably make a flashable zip or something along those lines.

I'll check into that too when I can get back to work on sqlite3.

All you need to do to install it currently is use es file explorer.

Swipe from the left and go down to root explorer.

Turn it on, then click on root explorer itself.

Click on mount rw, then click rw on /system.

Click ok.

Now go to where you downloaded and extracted sqlite3 to.

Long press on it and click the rename button at the top.

Rename it to sqlite3 and click ok.

Long press on it and click the copy icon at the top.

Navigate to /system/xbin

Paste the file into the directory.

Long press on the sqlite3 file you just pasted.

Click the 3 dots at the top right.

Go down to properties.

Go to where it says permissions and click change.

Change it to: owner - read, write, execute / group - read, execute / other - read, execute

Then click ok.

You have installed sqlite3 into your phone.

@amplatfus

No 64bit version atm, will be considering that when I can get back to work on sqlite3.

For now, use the armv7 or armv7-pie version.

They are still very fast even though they're not totally optimized for your cpu.

hansmoon · Dec 13, 2015

@tech128

Sorry, My mistake ...

Sent from my SHV-E210S using XDA Free mobile app

ReneLeonhardt · Dec 14, 2015

@tech128
Thank you very much for the infos and your hard work, I hope x86 will not be a too big pain in the ass, but maybe it's a good thing if the NDK becomes more useful in the end...
Good luck with your new dev server!
I'm looking forward to your new releases, maybe you can release arm first, that's the most important platform, if it's not too much extra work to split the release.

Mlessir · Dec 30, 2015

Hi again tech128.

I can see you have new downloads and i want to know to be secure which version i must install. So if i understand right armv-7 its for android versions older than 5.0 or lollipop, and armv-7 pie for 5.0 lollipop or above, isnt it?

Thanks in advanced and happy new year.

bendiss · Dec 30, 2015

tech128 said:
@toby12188

I decided not to include fts3 support since I didn't think it was anything important to include.

The SMS databases really need it? Last time I tried (awhile ago) it didn't need fts3 to dump the SMS databases.

I could look into putting it in there, but it might take a little while since it wasn't super easy to include it.

Any update on that? also can't delet rows in the sms table because of missing FTS3 module.

yingjai · Jan 6, 2016

I have the Nexus 6P with an ARM64 processor. I tried using armv-7-pie in /system/bin, but it returns an error when run:

CANNOT LINK EXECUTABLE: "/system/lib64/libc.so" is 64-bit instead of 32-bit
page record for 0xf6fad03c was not found (block_size=16)

I would try to pull it off an emulator myself, but for some reason it no longer runs on my PC.

Edit: got the emulator to run. Pulled sqlite3 from Android 6.0 armv7, but same error.

bdanders · Jan 20, 2016

yingjai said:
I have the Nexus 6P with an ARM64 processor. I tried using armv-7-pie in /system/bin, but it returns an error when run:

CANNOT LINK EXECUTABLE: "/system/lib64/libc.so" is 64-bit instead of 32-bit
page record for 0xf6fad03c was not found (block_size=16)

I would try to pull it off an emulator myself, but for some reason it no longer runs on my PC.

Edit: got the emulator to run. Pulled sqlite3 from Android 6.0 armv7, but same error.

I'm having the same problem on my Moto X Pure running 6.0. If you've been able to find a working binary, I'd love to know where.

Latest SQLite binary for June 2015

Senior Member

New member

New member

Senior Member

New member

Inactive Recognized Contributor

Senior Member

Inactive Recognized Contributor

Senior Member

Senior Member

Member

Senior Member

Senior Member

Senior Member

Senior Member

New member

Member

New member

Senior Member

Member

Similar threads

Top Liked Posts