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.
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)
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.
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.
● Dual-pane tree view
● Root, FTP, SMB, Sqlite, Picasa, Zip, Rar, 7zip explorer
● Cloud storage access: Google Drive™, Dropbox, Box.net, Mega.co.nz ***, SkyDrive, Webdav, Yandex.disk, Ubuntu One, SugarSync, Dump Truck, Copy.com
● SSH File Transfer (SFTP) and SSH Shell - http://bit.ly/xp-ssh ***
● Application manager
● WiFi file sharing *** - http://bit.ly/xp-wifi
● Manage files from a PC web browser *** - http://bit.ly/xp-web
● Favorite folders
● Built-in viewers for images, video, audio, text
● Hex viewer
● Fast Image viewer with zoom and slide to previous/next images
● Thumbnails for images and video as well as for various file types (depending on associated application)
● Multi-selection - always available, yet not disturbing
● View APK files as ZIP
● Share - send files by Bluetooth, email, or whatever the device supports, from any location
● Configurable buttons and key shortcuts
● Seamless work with Zip (as if it was normal folder)
*** marked features are paid - they require donation
X-plore allows you to see inside of your Android device. And also outside.
This is a dual-pane explorer, there are two folders shown at same time, and common operation such as copying files are done from one pane to another.
And X-plore shows folder hierarchy in a tree view for clear orientation and fast switching to other location.
You may explore internals of the device, and if you're power user and have your device rooted, you can make changes to system data - backup files, remove unwanted applications, etc.
If you're standard user, you may choose to hide internal memory from view and be sure not to mess with system.
You can comfortably see contents of mass memories on your device, or possibly attached USB memory stick.
Simple app manager allows to see, run, copy, share, uninstall and further explore installed applications.
WiFi file sharing
Access files on your Android device from other Android devices over WiFi.
Access from a PC web browser
Manage files on your Android device from your PC.
Access to FTP and FTPS (secure FTP) servers is supported.
Multiple servers may be configured.
X-plore can display shared folders on other computers in LAN (local area network).
The system allows access to shared folders on computers connected to LAN, or even remote server if it supports SMB protocol.
X-plore can access various web storage "Cloud" servers, and access their files.
You need to have account in supported web service, then you can access your files stored online through X-plore.
Supported is also SSH File Transfer (SFTP) and Terminal shell emulator.
Main operations are related to managing files and folders - viewing, copying, moving, deleting, compressing to Zip, extracting, renaming, sharing, and more.
X-plore can list images in Picasa albums, download them, create albums, upload and delete photos, edit captions.
SQLite database viewer
X-plore can show SQLite database files (those with .db extension) as expandable list of tables, each table containing list of rows and columns with database entries.
Main interaction is done by touch screen, clicking on folders or files to open files, or long-click to open context menu which contains options which can be done on particular clicked item, or multiple selected items.
Multi-selection allows to do operation on more files at once. Files can be selected by clicking check box. It is also possible to select all files in a folder, or clear selection, by clicking parent folder's check box.
Opening file may mean to use one of built-in viewer for most popular file types: images, audio, video and text.
Or you may configure X-plore to use system application for opening files, in which case system-predefined application that can open particular file is launched.
Archives (currently supported are Zip, Rar and 7zip) are displayed as other folders.
Additional interaction is possible by button bar, which is between two panes, and is fully configurable.
Requires Android 2.2 or later.
No other application needed to run.
After opening the database you can execute your sqlite commands.
As you type, you can auto complete your command with sqlite commands or with the name of the tables and columns of the selected database. And also, it's possible to have an overview of the database tables. Every executed command is stored in a historical.
Create or open sqlite database
Run sqlite commands
Some commands are stored with '!' at the beginning. This mean the command failed
To drop your database long click on the selected database at the listing
Long click to remove just one item from the history
In case of doubt, suggestions or bugs, please contact us.
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.
SQL ToolBelt will help and guide you to understand the basics of SQL and become familiar with everything related to T-SQL. The content of this aplication is divided into different sections that will help you practice, test your skills, find answers to you never ending questions and consolidate your knowledge.
SQL Practice - Practice your SQL skills:
-- SQL practice with example - you can edit or create SQL statement and directly test/see the result
-- easy to use, practical
-- very good for testing different SQL commands
-- immediate results for your SQL queries
-- simple tu use SQL editor
SQL Quiz - Test your current knowledge
-- quiz to test and improve a user's database knowledge
-- questions that covers basic to advanced sections
-- time tracking
-- immediate results on your tests
SQL Guide - Find answers to your questions
-- provides easy-to-understand T-SQL instructions
-- allows you to practice what you learn by providing sample queries that are available all the time
-- learn to build and manage SQL Server databases
-- gain the skills needed to build a solid foundation for SQL Server development
-- basic to advances
Train and test your self to gain the skills needed to unite the power of the SQL with nowadays demand.
More from developer
With the donate version of aSQLiteManager you get the aShell functionality build into aSQLiteManager.
As it allows you to edit the system databases you need to know what you do before starting editing. You might destroy data needed for your phone to work properly!
SO HANDLE WITH CARE
The root file explorer in aShell allows you to browse your device and if it is rooted you have access to any directory. The explorer allows you to sort and filter the files.
Before editing a system database a backup copy of the database is placed in /mnt/sdcard/.aSQLiteManager (named databaseName.back) here you will also find a version of the edited database.
If you like aSQLiteManager and aShell consider buying the donate version of aSQLiteManager and support the development and be among the first to get new updates with new functionality!
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 ;-)