Latest SQLite binary for June 2015

tech128 · May 17, 2015

Well I got a little too busy this week to do much of anything, but I was able to get the armv6 versions compiled.

The armv7 versions work, but have pie-related issues.

Basically from now on there will be four sqlite3 versions.

1. armv6 w/ floating point support (this will be referred to as armv6)
2. armv6 w/o floating point support (this will be referred to as armv6-nofpu)
3. armv7 w/ pie support (this will be referred to as armv7-pie)
4. armv7 w/o pie support (this will be referred to as armv7)

That way it will work on all androids (with the exception of non-standard android environments)

It won't work on armv6 devices that have lollipop, but I couldn't find any of those, just kitkat.

We'll see if I can get the pie issues resolved tomorrow so I can release it, but I'm still pretty busy so who knows exactly atm.

steadfasterX · May 28, 2015

thanks very much. you saved my day! :good::good:

glumetu · Jun 2, 2015

Hi all, a small question from my side.

I am running a Tasker shell script using sqlite3 commands on my rooted Note 3 with Lollipop 5.0 and have downloaded the corresponding sqlite-armv7 from here and pasted it (with proper rights) to the /system/xbin folder.

However when I run the task in Tasker I get the following error:
SQLite header and source version mismatch (one of the dates is in 2014 and the other one is in 2012!)

Any idea how to fix this - I'd really appreciate it!

tech128 · Jun 11, 2015

@xdajog

No problem, happy to help!

@glumetu

Well I'm not 100% positive, but I think the problem is caused by sqlite-armv7.

Since I just created pie-compatible versions today, which is what lollipop and later need to work properly.

tech128 · Jun 11, 2015

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 )

Kionei · Jun 11, 2015

I just tried the sqlite3.armv7-pie.apk on my Moto X (2014), but I get a Parse error on install - There was a problem parsing the package. Any ideas?

andrew.mackew · Jun 13, 2015

I wonder, which one is the one for Note 3 (N9005) and Note 4 (N910C)? Just paste it to the correct directory and done? Do I have to run any script? What about the apk file? Should I need to install it too? Thanks

tech128 · Jun 19, 2015

@Kionei and @andrew.mackew

Yes, you just rename the binary to sqlite3 and place it into /system/xbin and change the permissions to 755 or rwxr-xr-x

It is not really an apk, I had to name it like that because the forum system doesn't let me upload programs without an extension.

I'll use the pdf extension next time like Zepplinrox does, probably should make it a little less confusing.

Kionei · Jun 19, 2015

That I understand, and it works fine. I'm not sure how I glossed over it. It's a shame you can't upload without an extension. As stupid as it sounds, I would put something like this your OP:

Download appropriate file
Rename to /system/xbin/sqlite3
Change permissions to 755

Maybe it'll save you from having to answer some foolish posts

.

edgarf28 · Jul 30, 2015

@tech128 any change that we can get an updated SQLite 3.8.11.1 binary?

tech128 · Jul 31, 2015

edgarf28 said:
@tech128 any change that we can get an updated SQLite 3.8.11.1 binary?

Sure, not a problem.

I haven't checked the sqlite homepage recently, so I didn't notice they updated it again.

I'd like to put a web page watcher on it, but all of them make you register or sign up.

For such a simple thing, I don't feel that should be necessary.

I'll see if I can find some time tomorrow to update it hopefully.

If not, then it will have to be on Sunday because I will be very busy on Saturday.

tech128 · Aug 3, 2015

Ok, the binaries are updated to the latest again.

I can't seem to edit the title like I used to be able to though.

I tried 4 different browsers, same result.

I don't know any mods, so I guess it's stuck that way for now :x

On a brighter note, I did manage to find a web page watcher that looks very nice and was exactly what I was looking for.

It's called changemon

tech128 · Aug 6, 2015

Well I just tried to compile SQLite v4, but they use a custom parser, so it doesn't work too well to try and cross-compile it atm.

Hopefully they're only doing that for dev purposes atm.

I'll keep trying every once in awhile to see if it'll compile...

Rydah · Aug 28, 2015

tech128 said:
Ok, the binaries are updated to the latest again.

I can't seem to edit the title like I used to be able to though.

I tried 4 different browsers, same result.

I don't know any mods, so I guess it's stuck that way for now :x

On a brighter note, I did manage to find a web page watcher that looks very nice and was exactly what I was looking for.

It's called changemon

Thanks, appreciate the update!

tech128 said:
Well I just tried to compile SQLite v4, but they use a custom parser, so it doesn't work too well to try and cross-compile it atm.

Hopefully they're only doing that for dev purposes atm.

I'll keep trying every once in awhile to see if it'll compile...

Looking forward to it!

---------- Post added at 10:55 AM ---------- Previous post was at 10:39 AM ----------

which would work on an arm64 v8? (LG G4)

tech128 · Aug 29, 2015

@Rydah805

I'm not really sure. I don't have any access to arm64 capable hardware, so let me know.

I would think that only the armv7-pie version would work since arm64 is pretty new-ish and everything since lollipop requires pie.

I mean there are have arm64 emulators, but I don't have the time to play with that atm...

Rydah · Aug 29, 2015

tech128 said:
@Rydah805

I'm not really sure. I don't have any access to arm64 capable hardware, so let me know.

I would think that only the armv7-pie version would work since arm64 is pretty new-ish and everything since lollipop requires pie.

I mean there are have arm64 emulators, but I don't have the time to play with that atm...

Will try. Do I remove the file extension?

Sent From My LG G4

tech128 · Aug 29, 2015

@Rydah805

Generally yes, but it's not required.

Android is not like windows where the file extension needs to be exe com scr

What matters most are the permissions. Usually I do chmod 755 file

Rydah · Aug 29, 2015

tech128 said:
@Rydah805

Generally yes, but it's not required.

Android is not like windows where the file extension needs to be exe com scr

What matters most are the permissions. Usually I do chmod 755 file

The armv7-pie worked well on my LG G4. ???

Thanks! Appreciate your work.

Sent From My LG G4

ReneLeonhardt · Oct 6, 2015

Binaries for Intel x86 and SQLCipher (encrypted databases)

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...
Are the release builds optimized for space to minimize the resulting APK size?
Would it be possible to cooperate with Zetetic.net /sqlcipher/sqlcipher-for-android/ to create encrypted databases with the latest SQLite driver?

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

Miche1asso · Oct 12, 2015

I installed the armv7-pie version in my Xperia M2 with Lollipop 5.1.1. So far it works great. It was exactly what i was looking for. thanks.

Latest SQLite binary for June 2015

Senior Member

Recognized Developer

Senior Member

Senior Member

Senior Member

New member

Senior Member

Senior Member

New member

Senior Member

Senior Member

Senior Member

Senior Member

Inactive Recognized Contributor

Senior Member

Inactive Recognized Contributor

Senior Member

Inactive Recognized Contributor

New member

Senior Member

Similar threads

Top Liked Posts