Table Of Contents
Latest update [menu]
-Fixed crash when creating a database
-Better %dberr messages if database creation fails
Description [menu]
The easier way to query databases with Tasker, now with the ability to create your own databases! No need to hunt for a SQLite binary that is compatible with your phone. Simply add the Tasker SQLite Plugin step to a Tasker task, input the path to the database and your sql statement, and execute.
========== Return Variables ==========
For INSERT statements with columns specified i.e. INSERT INTO tTableName(colX, colY) VALUES (valX, valY):
%dbrowid = the row id of the newly inserted row
For SELECT statments:
%dbreturn = the output of the sql statement in the same way as the sqlite binary (columns separated by pipes and rows separated by new lines) so it can be dropped in without any other changes to existing SQLite tasks.
%dbreturncount = the number of rows returned
%dbrows() = an array of rows so you don't have to split %dbreturn by the new line character
%db[column_name_lower_case]() = an array of values for each column (replace [column_name_lower_case] with the actual name of the column)
This app is currently in beta. Please report any issues via email.
Root is required to access other app's databases.
How to install Tasker SQLite Plugin APK for Android [menu]
Download Tasker SQLite Plugin APK file (com.jordanhotmann.taskersqliteplugin_8_1664371.apk) from SameAPK.com, then follow these steps:
Update Phone Settings
- Go to your phone Settings page
- Tap Security or Applications (varies with device)
- Check the Unknown Sources box
- Confirm with OK
Go to Downloads
- Open Downloads on your device by going to My Files or Files
- Tap the APK file you downloaded (com.jordanhotmann.taskersqliteplugin_8_1664371.apk)
- Tap Install when prompted, the APK file you downloaded will be installed on your device.
How to install Tasker SQLite Plugin APK on Windows 7/8/10 or MAC PC? [menu]
Download Tasker SQLite Plugin APK file(com.jordanhotmann.taskersqliteplugin_8_1664371.apk) from SameAPK.com to your PC (ex: /Users/xxx/Downloads/(com.jordanhotmann.taskersqliteplugin_8_1664371.apk)), then follow these steps:
Using Emulator:
- Download And Install one Emulator Softwares (Ex: Bluestacks, GenyMotion, NoxPlayer)
- Simple install APK on PC by drag and drop file com.jordanhotmann.taskersqliteplugin_8_1664371.apk on Emulator screen
Tasker SQLite Plugin APK Pros & Cons [menu]
Pros
- This app is safe, it's not require high risk permissions
- Compatible with 32 bit device (most Emulator using 32bit arch CPU)
- Compatible with 64-bit device (some android device and current Bluestacks)
Cons
Everything is good.
