sqlite3 not (yet) working on Lollipop

[nanobrain]

If you are itching to jump on the Lollipop train AND are depending on sqlite3 in your tasks, please be aware that the current bunch of sqlite3 binaries available wont work because they now the need to be PIE (position independent executables). I've been looking for the last couple of days and so far I have not been able to locate one that was compiled that way. This will change once Lollipop gets a wider user base, but be forewarned in the meantime.

[Adam Lopresto]

I created an emulator in Android Studio (emulating a Nexus 5 running Lollipop), and it came with a version of sqlite that worked when i copied it to a real Nexus 5. 

[nanobrain]

Care to share?

[glimm]

I have another workaround, if you have Titanium Backup installed on your device. It has its own sqlite3 binary, which you can use with root.

Set the variable %SQLITE3 to "/data/data/com.keramidas.TitaniumBackup/files/sqlite3".

[nanobrain]

Excellent, thanks a bunch

[Rory Harnisch]

Has anyone else tested this?

[nanobrain]

I actually copied the titanium backup sqlite3 binary to system/xbin and it has been working for me since.

On Tuesday, November 25, 2014 11:49:42 AM UTC-5, Rory Harnisch wrote:

Has anyone else tested this?

[Rory Harnisch]

Awesome, thanks nanobrain! That worked perfectly. Has this been shared across the G+ communities yet?

--
You received this message because you are subscribed to a topic in the Google Groups "Tasker" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/tasker/raFenn0NJTM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to tasker+un...@googlegroups.com.
Visit this group at http://groups.google.com/group/tasker.
For more options, visit https://groups.google.com/d/optout.

[nanobrain]

Not from me. Credit goes to glimm

[glimm]

A symlink is an alternative solution, if you want the binary in your PATH (/system/xbin) and your system-rom is nearly full. For example there is only 200KB free space left in the /system of my Nexus 7 after installing Lollipop + SuperSu + Busybox.

su
mount -o remount,rw /system
ln -s /data/data/com.keramidas.TitaniumBackup/files/sqlite3 /system/xbin/sqlite3
mount -o remount,ro /system

Symlink has only 53 B and the binary has 300 KB.

[Paul [sabret00the]]

I've just run into this. Anyone know a workaround for people that haven't got/installed Titanium Backup?

[nanobrain]

http://forum.xda-developers.com/showpost.php?p=57143465&postcount=15

[Paul [sabret00the]]

Thanks.

--

[gary scarborough]

I just tried this and man did it relieve stress from some of my profiles not working thanks nanobrain and Glimm

[Timtim1980]

Ok I am trying to do something simple, even set the variable as suggested here

sqlLiteDemoCreate (5)

A1: Variable Set [ Name:%SQLITE3 To:"/data/data/com.keramidas.TitaniumBackup/files/sqlite3" Do Maths:Off Append:Off ] 

A2: Variable Set [ Name:%Weight To:10 Do Maths:Off Append:Off ] 

A3: Test File [ Type:Size Data:/storage/sdcard0/weighttracker.db Store Result In:%filesize Use Root:Off Continue Task After Error:On ] 

A4: Run Shell [ Command:Command = sqlite3 /storage/sdcard0/weighttracker.db "CREATE TABLE weight (date TEXT, weight REAL);" Timeout (Seconds):0 Use Root:On Store Output In: Store Errors In: Store Result In: Continue Task After Error:On ] If [ %filesize eq 0 ]

A5: Run Shell [ Command:Command = sqlite3 /storage/sdcard0/weighttracker.db "INSERT INTO weight (date, weight) VALUES ('%DATE', %Weight);" Timeout (Seconds):0 Use Root:On Store Output In: Store Errors In: Store Result In: Continue Task After Error:On ] 

 but I get this error:-

[nanobrain]

I can't see the error message, but in A4 and A5 you probably need to replace sqlite3 by %SQLITE3 in the shell commands. Also, since then there is now a SQLite plugin for Tasker: https://play.google.com/store/apps/details?id=com.jordanhotmann.taskersqliteplugin&hl=en_US . No need to have a full blown Titanium Backup install just for the sqlite binary (though obviously still useful for the main purpose of the app)