Fully integrated with Root Explorer. When browsing files in Root Explorer, selecting a database file automatically launches this app instead of the database viewer that is built into Root Explorer.
Non-root users can browse and edit databases on the SD card.
Data is displayed in a smooth scrollable grid and records can be filtered on any field value.
To quickly get to regularly accessed databases you can either add them to the bookmarks list or look on the recently accessed tab.
*Open databases from internal storage.
Open databases from external storage.
Simple Query Editor.
*Lists of all databases for all installed applications.
*Root access required.
I am not responsible for any damages, data loses. Use it carefully.
And of cource, enjoy.
You can choose from the following three ways to open the database.
1. Open the database file directly.
To use this function, you must have a FileManager.
I did an operation check for the following apps.
・ES File Explorer
・OI File Manager
・Astro File Manager
2. Send an intent with Content Provider uri.
3. Send an intent with database file's full path.
Please see below for more details.
If you purchase the PRO version, you will also be able to use the following functions:
・Query assist button (for search)
・The number of recently viewed database can be changed.
・The number of query histories (for search) can be changed.
・Save the column width
・Display null and blob
Please help by leaving a comment, especially when your rating for this app is low.
Better yet, I would greatly appreciate it if you could send me an email stating the reason for your low rating beforehand so I can try and fix the problem.
Support development by buying the donate version (and be the first to get the new features).
You can edit all databases on rooted phones.
Open databases from within aSQLiteManager and from a number of file managers.
List tables, views and indexes.
Display data, structure and definitions SQL for tables and views.
Execute any SQL including 'Drop' / 'Create' statements (simple SQL builder included).
Add and edit records from data browser (Add button at title / Edit button at each row).
Copy the content of any cell to the clip board by clicking at it
Store all executed statements in the opened database (in a table called aSQLiteManager).
Select SQL history from query form.
Begin transaction, Commit and Rollback.
Export database to SQL script and restore databases from script.
Import and export of CSV files
Execute SQL scripts, full script or single lines.
SQLite does not validate data types during data entry but aSQLiteManager set the Android input mode reflecting the field types.
Create database wizard.
Configurable font size in data lists.
Easy editing of databases located in a "Dropbox" folder
Now translated to:
German - thanks to Denis Dogan
French – thanks to Jean-Luc Rostini + Nicolas Gourdon
Italian – thanks to Giuseppe Tumino https://play.google.com/store/apps/developer?id=Giuseppe+Tumino
Catalan – thanks to Paco Rivière
Brazilian – thanks to Leandro Lopes
Spanish – thanks to Gonzalo Rodriguez
Russian - thanks to Denis Bondarenko
I made this app for myself to help me debugging my own apps. If you have any troubles, mail me.
I have tested this only on a droid bionic. If you have problems, please send me a email with your phone type so I can try to support it.
I WILL NOT HELP YOU ROOT YOUR PHONE. IF YOU EMAIL ME ABOUT HOW TO ROOT, I WILL DELETE IT.
This application contains advertisements. It contains these as I host the binaries on the domain that I pay for. If I find that many are using anti ad tools, I will block service for those phones. If data is a problem for you, use Wi-Fi. It does not generate a lot of profit, but you get a service from me that is free.
If you find a problem with the application, please email me. I am willing to help you in anyway I can. I take suggestions as well. If I refuse to help, which I wont, then go ahead and give me a nasty comment here.
I appreciate all of the good comments.
inside of their phone/tablet without having to copy the DB to their computer
(and later needing to copy them back to their phone).
It installs on your phone a Web Based SQLite Admin tool in which you can open from your computer.
If you just want to see if this software works, download it, install on your phone,
open it, start the server and go to "http://ip_address_of_your_phone:8080/" from your computer.
If you have no internet, connect your phone with the USB cable and type "adb forward tcp:8080 tcp:8080".
Afterwards, open http://localhost:8080/ from your computer.
Now just create a database or play around with an existing one.
To view/edit a database from an existing/your app:
It is possible for you to view/edit a DB from an existing app, but you will need permissions for that.
If you are rooted, just type:
adb shell su -c chmod 777 /data/data/com.apkcreator.apkname/databases/ /data/data/com.apkcreator.apkname/databases/*
hint: some apps make the DB not readable publicly every time they open, so be ready to type the command above many times.
If you can't root, use your own app to make this folders and files public writtable.
You may want to do this only on the debug version of your app.
Afterwards, open SQLite Admin for Android, open the sqliteDatabases.sqlite3 database and
add either the absolute folder path or absolute database path in the databases database.
If you wrote the path correctly AND there are permissions, the DB will automatically appear.
Warning: errors will only be shown if you close SQLite Admin for Android and open it again.
An alternative to this software would be com.peculiarcat.sqlbride, which takes a different approach.
Just like everything else, this software could not be done without the help of many:
Android Server for PHP (com.esminis.server.php) https://play.google.com/store/apps/details?id=com.esminis.server.php
phpLite Admin (original source code + some monkeypatch of mine) ( http://code.google.com/p/phpliteadmin/ )
This software was written on a plane :)
This is actually a full blown single user PHP server on your phone. You can do whatever you want with it. Just check the www folder on your sdcard.
This software is open source and it's code is available on GitHub: https://github.com/marcosdiez/sqliteadminandroid/
Marcos Diez ( marcos AT unitron DOT com DOT br)
Features : [ easy to build the Query ], [ treeView display of the SD Card ], [ export to Excel ] :
(1)-easy query editor that implements ('NoTypeJustSwipe') : select the command and just drag the table name on edit zone
(2)-TreeView display of the SD Card: thus you can easily choose the database to query from the SD Card
(3)-export to Excel the query result
(4)-save and reuse facility for SQLite statements
The following SQLite database operations are allowed through this app:
SQLite QUERY is the best editor that has ('NoType-JustSwipe') : to query the database you need no type (the command and the table/columns names), chose the command to execute and just swipe the name of the tables/columns onto specific position on the editor.'NoType-JustSwipe' editor is thus adapted to phones and tablets with no physical keyboard, and gives you the freedom to query the database wherever you are: in the bus, in the train, on the office, in the plane, in line for football tickets...etc...
With SQLite QUERY You can visualize and EXPORT to EXCEL the result of your queries, on the SD CARD, thus, later on, you take, move, that Excel file from the SD CARD into your computer for further processing or to import it somewhere else (MS Access, MS SQL Server, Oracle...etc).
SQLite QUERY gives you a TreeView display of the SD CARD, thus making simple for you to chose what database to query from the SD CARD or the folder where you want to export your query result into EXCEL file.
You can save and reuse SQLite code for use in the future.
Insert, Edit, Delete, Update rows in the Databases, check what are they using, you can obtain information during the develop of your own app,
Execute a sql query or see all data in a table with one touch, view the SQLite Data Base structure (views, indexes, tables and triggers),
The devices with root user can access to all the Databases, without root is posible to modify Data Bases inside the SD Card
edit your .db and .sqlite files .You can create your own Sqlite database and
create Table, insert values into tables, create view and drop view, select
data from the tables and see all the data in the tables in a user
It helps to manage your android phone and sdcard. You can Copy, Paste,
Cut, Zip/Unzip, Search, Bookmark your files and folders. You can add folders
and send your file via Blue tooth and Email. This application also installs
the .apk files in your android mobile. You can also open text, image, audio
,video, html, xml, .zip, .db and .sqlite files through Sqlite File Explorer.
The following features are available in addition to the Free version functions.
・Query assist button (for search)
・Remember 10 previous queries (for search)
・Save the column width
this function is linked to the full path of the database file.
If you move/rename the file, column width will be reset.
・Display null and blob
In the Free version, null and blob cells are blank.
In this version, you will be able to see "null" or "blob".
・Choose value area's height
Due to permission conditions, file size, etc., this application may not work with some databases.
Make sure to test it out with the Free version first .
SQLite Viewer Free
It is highly customizable, users are able to choose how many INSERT , UPDATE , SELECT , DELETE statments to execute for their benchmark ,although defaults are highly recommended.
They are rich graphs and charts that show data of the benchmark results which is great to see how fast your phone can run queries.
Note: The speed of executing queries doesn't equal the processing speed of the phone. It is related to processing speed and reading/writing to the memory.
It can be free to create input fields, memo input. Fuel consumption management of the car. Weight management. You can create your favorite database, etc..
1. Database can be created kinds.
2. Table can create unlimited.
3. The item can be created of 20 for each table.
4. Sortable of data in any items.
5. Between items calculation can be set of selection criteria for the data.
6. Select Input.
Item name you can set the Japanese the "item name" in addition to the name to be used in SQLite, says it is easy to understand when you enter.
After you have the registration of the table name and database name, and then the set [integer, text], such as the name and type of item to be input.
If the settings once, you can focus on the input of the data after.
Data ciphering logic uses AES, the Advanced Encryption Standard, which is a 128-bit symmetric-key text encryption specification that was approved by the U.S. National Institute of Standards and Technology in 2002, and is used by the U.S. government and other institutions worldwide.
* 128-bit AES encryption using:
- SecureRandom() with 'SHA1PRNG' salt
- SecretKeyFactory() with 'PBEWithSHAAnd128BitAES-CBC-BC'
- Cipher() with 'AES/CBC/PKCS7Padding'
* User-supplied cipher key(s) up to 12 characters long
* No-limit recursive encryption
* Any character set (language) can be encrypted*
* No app restrictions to data manipulation size
* SQLite database for archiving (with search and sort)
* 'Share' and Clipboard-paste for forwarding
* Scrollable real-time 'on screen' Event Log
* Built-in Help file
* Note: This free version permits only 5 'folders' in the database
By using other Android apps, your encrypted data can be posted on the Web or transmitted to other Android devices around the globe. The destination receivers would use their own Crypt2phile app (see note below) and your previously-disclosed encryption key(s) to decipher the forwarded message.
If you don't distribute your cipher texts, then you can save them in a SQLite database on your own Android smartphone. The information is stored in 'folders' where it can later be individually retrieved and decrypted to reveal your old confidential notes. (A maximum of 5 'folders' are permitted with this free app.)
NOTES: If you discover you need more than 5 'folders', download the app: Cryptxphile. The tablet-targeted CryptxHD and CryptxHDx apps, and the smartphone-targeted Cryptxphile and Crypt2phile apps may all be used to decrypt any AES+ data file. Be aware that Triple-DES strings can not be decrypted by the AES algorithm, and vice versa.
Caveat: Mix together enough mathematicians, cryptographers, CPU's, and research time in a computer lab and you'll discover any encrypted text on planet Earth can be deciphered. Therefore, don't expect to find an "uncrackability" guarantee with this app! But by combining an off-the-shelf encryption algorithm with multiple private keys and unlimited recursion, hackers will be repulsed from even attempting to brute-force-attack your ciphered texts.
* Note: the Unicode characters x2500-x256C are reserved for data encoding!