Tasker SQLite Plugin
========== 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.
Category : Tools
Reviews (25)
i cant do select with a where clause, it did not work, also how do i insert a text tyoe without ending up with "" around it Might be abounded , dev email is not working
Deprecated. Tasker has a built in SQL Query action.
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 :)
Works but needed a few work arounds. I would give this 4 stars, but the developer says it's Beta and to email problems, but I have not had any replies to my emails.
NOTE: Stopped working on my newer phone (Android 11). I had to grant "Storage" permission to get it working again! Reviewers denigrating this App do a disservice to users who want to easily do basic work with SQLite. Give it a try. It has reasonable help built into the plugin!
Automate supports trailer plugins. But for some reason this plugin keeps dieing. Android keeps saying it stopped working. Tried many combinations.
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.
I used to use SL4A and Python scripts to manipulate SQLite databases with Tasker. This plugin makes things much simpler and easier!
When I make a standalone app it doesn't work though I have the plug-in installed
Awesome! Took trial and error to work out how to create tables etc. No root needed. A shame it doesn't support BEGIN TRANSACTION and COMMIT for doing multiple inserts in one file write.
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!
Good bye flat files and other cumbersome storage formats! I will not miss you! Thank you for this amazing plugin!
First project: Move my unreadable battery logs to a sql database. | Thank you kindly for the plug-in!!
Worked flawlessly right away, this is easily the best Tasker plugin I have ever used.
Just one request! When %dberr is "Query did not return with any data" make the %dbreturncount = 0
Brilliant, first few days and have 3 databases setup. Convenience, speed and functionality is amazing
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.
Flat files be gone. Does what it says on the tin. Couldn't ask for more.
Makes tasker sqlite integration much easier!
Thanks for the plug in, Dev!
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!
Great plugin and the new ability to create your own database is ingenious for tasker organization.
Works as advertised!
Great app! But why can't I access /data/user_de/0/com.android.providers.telephony/databases/mmssms.db? Tasker and root explorer can both read the file and write it, but this plugin can't. Can you help me plz?
Extrememly buggy. Only basics work. The app has been in beta for several years now. I can only assume that it is no longer being developed. Too bad as it looks promissing.