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.
Did you ever want to..
.. get pass an Android lockscreen within seconds?
.. download photos, videos and files?
.. edit files and apps from phone-to-phone?
.. access saved WiFi Networks, Access Point Data and Google Token?
Craze is a mobile application based on the Android Debugging Bridge (ADB) to maintain, recover and play around with other android devices.
If you are tired of typing tons of ADB commands into a shell or you are just not familiar with ADB commands - check it out!
It will save you lots of time and pain - trust me.
- SU binary installed
- Busybox installed
- ADB binary installed
- !!! Root access !!!
- USB: USB Host Mode / OTG Support (supported by android version 3.1 - 4.x)
- WiFi: Requires a "WiFi ADB" app on the target device (available for android versions 2.3.3 - 4.x)
[ ✔ ] Handle multiple devices at the same time
[ ✔ ] Built-In Remote File Browser
[ – ] Image Preview
[ – ] Multi - Upload
[ – ] Multi - Download
[ – ] Multi - Copy
[ – ] Multi - Cut/Move
[ – ] Multi - Delete
[ – ] Select All
[ – ] Unselect All
[ ✔ ] Built-In File Chooser
[ – ] Image Preview
[ – ] Choose files/folder to upload
[ – ] Choose APKs to install
[ ✔ ] Built-In Remote Package Browser
[ – ] 3rd party packages
[ – ] System packages
[ – ] Multi - Install
[ – ] Multi - Uninstall
[ – ] Multi - Backup
[ ✔ ] Recover Data [..:: Target needs root access ::..]
[ – ] WiFi Networks
[ – ] WiFi Access Point
[ – ] Google Token
[ ✔ ] Lockscreen
[ – ] Bypass
[ – ] Remove [..:: Target needs root access ::..]
[ ✔ ] Power Options
[ – ] Reboot
[ – ] Recovery
[ – ] Bootloader
[ ✔ ] Contact
[ – ] Email
[ – ] XDA Developers
[ ✔ ] About
[ – ] About Craze
[ ✔ ] More features will come soon
Check out the instruction section in my XDA-Developers thread:
[ ✘ ] First
[ – ] This app REQUIRES root access on YOUR phone!
[ – ] If you don't have it - go and get it or Craze will immediately close itself.
[ ✘ ] Second
[ – ] Disable the SU notifications for Craze if you don't want to get spammed.
[ ✘ ] Third
[ – ] It's completely up to you what you are using this app for.
[ – ] I am not responsible for any damage, lost data or unauthorized and illegal use of Craze!
If you detect any bugs or you have any ideas please feel free to contact me via mail or on XDA-Developers.
craze, adb, toolkit, tool, android, debug, debugging, bridge, file, browser, image, preview, multi, upload, download, load, chooser, choose, copy, cut, delete, move, apk, apks, install, uninstall, built, built-in, package, remote, usb, wifi, 3rd, third, party, system, recover, backup, data, root, access, target, victim, network, networks, point, google, token, lock, screen, lockscreen, bypass, power, options, reboot, recovery, whitelist, boot, loader, bootloader, xda, dev, devs, developer, developers, xda-dev, xda-developers
*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.
I made this app for myself to help me debugging my own apps. If you have any troubles, mail me.
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.
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)
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 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.
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
More from developer
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
The calculator differs from the HP41CV in the following ways:
No definition of number of register
Programmes cannot be assigned to keys (working on that)
Not all special flags implemented
Number of programme lines only limited by phone memory
Only a simple programme editor (by now) but full import / export of programmes on cvs format
Still trying to make a41CV fit better on the now more than 1782 different devices it works on according to Google Market
As I can't expect users to be developers I needed an easy method for users to grab the log and hopefully only the interesting part of the log. Using aLogViewer allows you to add two filter to the log. One where you specify a tag to filter for and the level of messages to let through and a level of which other messages are let through.
If you buy this version you will:
1) Support the development of aSQLiteManger
2) Get more frequent updates
3) Be among the first to get the new features implemented in aSQLiteManager
This is the first version of aSQLiteManager where new functionality is first included in the donate version.
The donate version support editing of system databases on rooted phones without aShell.
If peoples find this useful I might expand the functionality.
If you don't need spatial functionality use aSQLiteManager!
This version FC if you try to open the idx_TableName_Geometry as this is done using the standard sqlite version that cant handle btree's. This will not be part of aSQLiteManager as the SpatiaLite libraries make the app 10 to 20 times larger.
You can match a GREP expression against a string or replace all parts of a string that matches a GREP expression with a string.
You can do search and replace in files and save up to 10 GREP expressions for later use.
GREP On The Run support the Java GREP flavour and let you develop and experiment with GREP expressions on your phone or tablet whenever and wherever you want.
To help the novices in GREP – like my selves – GREP On The Run includes a small help / list of operators ;-)