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.
Tasker SQLite Plugin is an Android Tools app developed by Hotman[n] and published on the Google play store. It has gained around 5000 installs so far, with an average rating of 4.0 out of 5 in the play store.
Tasker SQLite Plugin requires Android with an OS version of 4.0.3 and up. In addition, the app has a content rating of Everyone, from which you can decide if it is suitable to install for family, kids, or adult users. Tasker SQLite Plugin is an Android app and cannot be installed on Windows PC or MAC directly.
Android Emulator is a software application that enables you to run Android apps and games on a PC by emulating Android OS. There are many free Android emulators available on the internet. However, emulators consume many system resources to emulate an OS and run apps on it. So it is advised that you check the minimum and required system requirements of an Android emulator before you download and install it on your PC.
Below you will find how to install and run Tasker SQLite Plugin on PC:
If you follow the above steps correctly, you should have the Tasker SQLite Plugin ready to run on your Windows PC or MAC. In addition, you can check the minimum system requirements of the emulator on the official website before installing it. This way, you can avoid any system-related technical issues.
Tasker SQLite Plugin APK 1.3.3 | 1.59 MB | 1.3.3 |