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.
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.
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
* Microsoft Access 2000
* Microsoft Access 2002
* Microsoft Access 2003
* Microsoft Access 2007
* Microsoft Access 2010
* Microsoft Access 2013 (still doing quality assurance testing)
Panacea Database can handle the ACCDB or MDB (Jet) format.
The Panacea Database application workflow:
First, you can either scan your SD card for all ACCDB and MDB files, or browse your SD card for those files. Then you select the database you want to use.
The application then lists that database's tables. You then select the table of interest.
You can then iterate back and forth through the rows of that table.
The application also allows you to search for rows with a particular value in a particular column. The program will then display the rows which have that value for that column. The application allows for partial and case-insensitive text searches.
Panacea Database is completely free. We have an ad banner on top of pages.
App functionality is limited. Unfortunately, we can not conceive of a financially viable method where we would regularly add new features to the app. We figure honesty is the best policy. We have no plans to put in forms and the like in the foreseeable future. Even things like table sorting probably will not get done in 2014. We do some maintenance though - KitKat broke a lot of things so we fixed that up. New features are probably not on the horizon for 2014 though.
Panacea Database makes use of the LGPL license Jackcess library which is under the Lesser Gnu Public License. It also makes use of the Apache commons-land, commons-logging and log4j libraries, which are under the Apache 2.0 license.
* Now we support view and edit ROOT mode database via In-app purchase
(New in-app 'Edit Root Mode Database' HALF PRICE FOR A LIMITED TIME)
* Build-in File Manager to find SQLite database
* View database tables with paging results (change page size in menu)
* Edit SQL with shortcut buttons and Run SQL
* All SQL support (CRUD)
* SQL will automatically save to history
* Share SQL and Result CSV with others
* Easily Delete Row , Update Row, Update FIeld, Copy/Clone Row Data,
* Check Database Info, size ,version , encoding...
Want even more professional features? You can find my super power full "Sqlite Manager Pro" edition here:
(Feedback and questions welcome send me email, you can find 'Email Developer' link on this page.)
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)
IF YOU NEED HELP SETTING UP THE APPLICATION, EMAIL ME
Database Tool allows users to easily view and query database tables. Use of this app requires the upload of a web services written in PHP to your server. This gives an extra layer of security since you will not be forced to allow remote connections to your database, like the other apps on the Android Market require.
This application does not directly allow you to query. Instead, it assembles queries based on your preferences. It allows you to sort and search columns. View the screenshots for more examples.
Based on the popularity of this app, I may come out with a professional version that allows for custom queries, which would be very useful when you need to join tables.
As of now, the Tool is only compatible with MySQL databases. There are plans for MSSQL compatibility in the future as well.
You can download the PHP code at : https://sites.google.com/site/jstn455/databaseviewer
Directions for getting the application to work are as follows:
Step 1: Download .zip or .tgz file from https://sites.google.com/site/jstn455/databaseviewer
Step 2: Extract the folder (unzip or tar -zxvf "filename.tgz")
Step 3: Transfer the directory via FTP client into your public html folder
Step 4: Confirm the web address through your browser. There should be a confirmation message.If you transferred the directory to the root public html file, it should be http://yoursite.com/mysql-tool
Step 5: Go into the settings.php file in a text editor and fill out lines 14-18
For $password, you could use any password you want. It does not have to be your database password, and as a precaution it should not be your database password.
Step 6: Download the Android application
Step 7: Add the database to your application. Match the password from your settings.php file to the password field in the application
If you prefer extra security, you can use also set up an htaccess authentication for the directory. The app will prompt you for your username and password.
Single Table viewing
Multiple column searching
Paginated Data view
Export to CSV
MySQL Database Viewing
With this app you will quickly get an overview over all your collections (e.g. your CD collection, your DVD & Blu-ray collection, your collection of books or video games, your wine cellar). Keep track of your purchases, manage inventory or task lists. The possibilities are endless.
Create as many databases as you like.
Several types of data fields available to store your information: single-line and multi-line text, autocomplete text, email, hyperlink, phone number, single- and multi-select text, various number formats, date, time (time-of-day or duration), checkbox value, alphanumeric value, rating.
Create a new database and populate it with data from a CSV file in one easy, automated step.
You can add an arbitrary number of images to every record.
Take photos with your built-in camera and add them to a record.
Sort a database by a up to three fields.
Powerful search with wildcard characters and text highlighting.
Create and save filters with as many conditions as you need.
Easily export and import data to and from CSV files (text files).
The freely configurable list view mode lets you display your data in tabular form just like on your PC.
Make your purchase history to shopping, make a list of your favorite collections, make a record of the trip, its value is up to your idea of infinity.
In business, can make a list of customers, can also record sales.
Also, this application is also very useful for lazy people. You will be able to download and use the database created by people around the world. Please find the database of your favorites. Of course, you can be exposed your wonderful database to people all over the world. Your database would certainly be useful for someone.
You never need to know database as SQL statement.
While using the database, you can add or delete items.
This application can handle the data in the following data formats.
* Integer number
* Real number
* Character string
You can also enter a long text string across multiple lines.
Photos will be converted to a reasonable size.
You can display data one by one, or by scrolling. You can sort data by any item. You can also jump to the desired data by using the search function.
The search for a value of the item you want using the magnifying glass icon. In case of the number is the minimum and maximum values can be specified.In case of a string is searched for data that contains the specified string.
Of course, since the database is stored in the terminal, do not worry about privacy, you can use even if network is disconnected.
If privacy is important, you can set a password for each database.
The database is not only used alone, but also import and export is supported. You can aggregate data exported from the database by PC, and you can use data created on the PC.
Of course, you can also exchange data with friends that use the same application.
Please enjoy your own fully database.