Tasker SQLite Plugin
Free App
Advertisements
About Tasker SQLite Plugin
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.
========== 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.
All Application Badges
Free
downl.
downl.
Android
4.0.3+
4.0.3+
Bug
buster
buster
Android app
App History & Updates
What's Changed
-Fixed crash when creating a database
-Better %dberr messages if database creation fails
-Fixed crash when creating a database
-Better %dberr messages if database creation fails
More downloads Tasker SQLite Plugin reached 1 000 - 5 000 downloads
What are users saying about Tasker SQLite Plugin
X
by X####:
by X####:
First project: Move my unreadable battery logs to a sql database. | Thank you kindly for the plug-in!!
I
by I####:
by I####:
For anyone having a hard time with the early syntax put your database in your root file, use /sdcard/data.db as the path line then a simple select query would be SELECT * FROM 'Table' - dont forget quote marks - you need a rooted phone for this though!
B
by B####:
by B####:
When I make a standalone app it doesn't work though I have the plug-in installed
X
by X####:
by X####:
Just one request! When %dberr is "Query did not return with any data" make the %dbreturncount = 0
X
by X####:
by X####:
Tyvm no manual nor enough downloads for support so thank you
X
by X####:
by X####:
You need root access to use it on app databases in /data/data
Z
by Z####:
by Z####:
Worked flawlessly right away, this is easily the best Tasker plugin I have ever used.
X
by X####:
by X####:
Flat files be gone. Does what it says on the tin. Couldn't ask for more.
X
by X####:
by X####:
Makes tasker sqlite integration much easier!
X
by X####:
by X####:
Good bye flat files and other cumbersome storage formats! I will not miss you! Thank you for this amazing plugin!
O
by O####:
by O####:
Fully working SQL using tasker. Each call to the plugin is limited to one SQL command as far as I can tell. This is a must install.
X
by X####:
by X####:
I was trying to go through all the trouble of installing sqlite3 binary to my phone just to use tasker's run shell command. Didn't work. But tried this and was able to pull data out of my calendar db on the first try. Thank you for this :)
Q
by Q####:
by Q####:
Works flawlessly and painless!! Switched flat file for storing my favorite Spotify artists/playlists to sqllite database. A little tweak to the task that reads from the flat file to use this plugin to query the database.
X
by X####:
by X####:
I used to use SL4A and Python scripts to manipulate SQLite databases with Tasker. This plugin makes things much simpler and easier!
X
by X####:
by X####:
Easiest and only way to add SQL database integration into Tasker, AND it doesn't require root. No more using flat text files with ridiculous splits for data. You can store/query/sort data for any Tasker project in an actual database!
H
by H####:
by H####:
Great plugin and the new ability to create your own database is ingenious for tasker organization.
X
by X####:
by X####:
Works as advertised!
X
by X####:
by X####:
Tyvm
by X####:
Automate supports trailer plugins. But for some reason this plugin keeps dieing. Android keeps saying it stopped working. Tried many combinations.