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.
User can browser, open and edit SQLite files.
User can read the data of all tables.
Recently opened database feature for convenience.
Also, you can create a new database.
WE HAVE FIXED ADS ISSUE IN THE LATEST RELEASE.
Why do you to want use SQLite Master
[✔] Fastest and optimized, support large SQLite databases
[✔] Easy and simple user interface
[✔] Very small footprint (installer size is 470 KB, it takes few seconds to install)
[✔] Have almost everything that android users need
The major functionality includes
[✔] (Pro version only) Hot System Apps - Rooted System Fix Wi-Fi tethering, Phone settings, contacts, system settings, configure app databases etc. It requires busybox installed on your android device.
[✔] (Pro version only) Rooted System browse system files in rooted system and configure. It requires busybox installed on your android device.
[✔] Create/drop Sqlite databases
[✔] Create/drop/modify Sqlite tables
[✔] View table data
[✔] Sort table data by simply tapping on the column headers (first tap - ascending, second tap - descending)
[✔] Export table data to CSV
[✔] Import highly configurable CSV data into Table
[✔] Add, delete, update table row
[✔] Copy table row to clipboard by double tapping on a row
[✔] Query Maker to build custom queries and save queries, easy to use interface
[✔] Pre-generated SQL Select Queries for existing tables.
[✔] Save SQL queries which can be used later.
[✔] Delete saved queries which are not needed.
[✔] Import existing queries.
[✔] View/Copy table definition, triggers, views in the database.
[✔] Close table data, clone table schema etc
[✔] In table list page, long press has many options such as clone schema, clone data, drop/rename table etc.
[✔] History of recently opened SQLite databases.
* Lot of testing was done on three different sizes android screens
* Full cycle test was done for four major Sqlite data types (INTEGER, TEXT, REAL and NULL)
* Full test was done using famous Chinook Sqlite database using 15000 rows and 11 tables
This applications allows you view/modify data and structure of SQLite Database on Android. Create and modify structure of tables, views, indexes, triggers, table’s constraints and foreign keys in SQLite database, edit and delete records in SQLite database. This application does not support root access.
In more detail using this application user can:
-create, modify, delete, rename, dump tables,
-display tables’ s and views’s data in scrollable grid,
-create, modify, delete, export records,
-support multiselect on records,
-sort and filter records on any field value,
-export filtered data to CSV files (included custom separators),
-create, modify, delete columns in table (including columns’s constraints and foreign keys),
-create, modify, delete table’s constraints (including foreign keys),
-create, modify, delete table’s indexes,
-create, modify, delete table’s triggers,
-create, modify, delete views,
-execute SQL scripts,
-export database to SQL script,
-restore database from SQL script,
-store executed statements to history,
-browse and edit databases on SD card,
-scan SD card for existing databases,
-configurable application’s size,
-remember recently opened databases.
-Added possibility to change datagrid's page size
-Added possibility to load/save datagrid's filters
-Fixed SQLRun scroller for software keyboard
-Fixed a bug where application could crash if an old version, or no version of Google Play Services is installed on the device
-Fixed table parser and added types : LONG(int) and STRING(text)
-Fixed 'Scan for DB'
-Added possibility to import from CSV
-Updated Adobe AIR SDK to 126.96.36.199
-Fixed fonts in Start view
-Updated 'Application size' range from 50% to 150%
-Updated dump table, dump database, export CSV and import CSV. Shows dialog 'Working' now
-Small design improvements
-Fixed minor bugs
-Upgrade Adobe AIR SDK to 188.8.131.52
-Optimalized history of sql commands in 'SQL Run'
-Added button 'Delete All' to 'SQL Logs'
-Updated AIR SDK to 14.0.0
-Removed permission : READ_PHONE_STATE
-Fixed datatime type, now is possible to set NULL value
-Fixed hardware button Back in 'Scan for DB'
-Fixed 'Dump database' and 'Dump table'. Remember settings after come back from 'Directory browser' now
-Fixed Load file in 'SQL Run'
-Fixed 'Scan for DB' lags
-Small design improvements
-Improved data grid, add horizontal slider to change scale of data grid
-Add possibility to show basic types on new/edit column dialog
-Small design improvements
-Improved dialog for creating backup file
-Add button : Inform Author in case of parser failed : send sql to author by email
-Improved 'Scan for DB'
-Fixed new/edit 'Foreign Key' dialog
-Fixed 'Select column' dialog
-Fixed new/edit record dialog
-Fixed index parser
-Fixed parsers for column type : LONGVARCHAR
-Improved modal dialogs
-Improved Settings : Add possibility to switch on/off question of creating backup
-Optimalized Data Export : Change extension to CSV
-Improved SQL Logs : Add COPY to Clipboard
-Improved SQL Browser : Add PASTE from Clipboard, add possibility to create CSV, add history, add sql extensions
-Optimalized search of file
-Optimalized application size
-Resolved an issue where some ads may not be able to display on some android devices
-add possibility to create/restore backup of database
-updates internal android sdk to GooglePlay 4.4
-remove dependency on external adobe air download
I made this app for myself to help me debugging my own apps. If you have any troubles, mail me.
Requires Android 2.2 or later.
No other application needed to run.
* ROOT required *
* busybox required *
Debug your SQLite Databases.
Debug your Shared Preferences.
Try to hack your own app via changing settings.
Browse all your installed apps, see every setting-file, the app uses.
Browse, inspect and debug SQLite databases and shared preferences files.
Kill the app, quick uninstall the app, or even quick clear the files.
Start viewing the content of the file / database simply by clicking the button with the given filename.
Easily change the values of the shared prefs.
NOTE: all values are typesafe!
Delete a preference entry, simply by using the "swipe to dismiss" pattern.
Or delete the whole shared prefs file.
Raw query the SQLite databases (eg SQL statement over several tables)
Long click the table / index / trigger / view to see the create statement
Edit / Delete / Copy a row simply by selecting the desired row and use the actionbar options (menu options)
- supports multiple delete rows (by long click)
Add a new row from scratch.
NOTE: all values are typesafe!
Select columns you want to see.
Create a custom order.
check license via Google Licensing:
Differences Pro - Lite:
- Kill app
- Clear data
- Quick uninstall
- Delete shared preferences file
- Save changes to shared preferences
- Delete SQLite database file
- Raw query databases
- Show SQL create statement of the table / index / trigger / view
- Edit / add / copy / delete a table row
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
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)
Various device information like Android Platform, Battery, Build, Build.VERSION, Environment Variables, Screen, Settings.Global, Settings.Secure, Settings.System, SQLite, System Features, System Properties, System Shared Libraries, and Telephony Manager.
List of various settings shortcuts. Click on shortcut to open the particular settings screen.
List of installed packages. Click on package to open package detail screen where you can clear Cache, Data and Defaults of the selected application. On package detail screen, you can also Force Stop and Uninstall the application. The application also provides facility to filter out the System Packages.
a. Pixel DIP Converter - convert pixels to dip and vice versa
a. Pixel SP Converter - convert pixels to sp and vice versa
5. Google Play
a. Current Device Distribution - device distribution of the current month
b. Device Distribution - historical device distribution. From Jan 2012 to December 2014
c. Aggregate Device Distribution
d. Device Distribution Charts by Android Version, Codename and API Level
e. Aggregate Device Distribution Chart by API Level
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.
Now you can run a DyDNS, FTP, FTPS, SFTP, SSH, PHP, MySQL and/or Remote Control server on your Android phone/tablet! The perfect suite for web developers or for turning your Android into a serious server! It even includes a remote control option to start/stop/add servers remotely and you can use the MySQL monitor to manager the MySQL server. This app allows for a trial period of 6 days.
Keep your web projects in your pocket and always available on the road with this complete web server!
★★Most complete app!★★
The app has even more functionality compared to other PHP and MySQL Server apps like KSWEB, PAW Server, Bit Web Server and AndroPHP!
★★No root required!★★
- PHP Server (includes PHPMyAdmin, PHPSysInfo and PHPFileManager)
- Lighttpd Server
- MySQL database server
- FTP Server
- SFTP Server
- FTPS Server
- SSH Server (with SCP support)
- Remote Control Server
- Dynamic DNS Updater: DNSdynamic, DNSexit, DNSMadeEasy, DNSPark, DtDNS, DynDNS, easyDNS, eNom, HE.net, Joker, Namecheap, No-IP, DNS-O-Matic, ZoneEdit, ChangeIP
- MySQL Monitor
- Optional password login for the app
- Add a Dynamic DNS Updater using the local or public IP
- Use the WIFI / SMS / call / power or cronjob triggers to start / stop servers!
- Use notification rules to receive an SMS, email, etc on start, stop, etc.
- You can set a custom name, port, network interface to listen on, backlog, logging, logging to file, start on boot per server. And if rooted you can set a port below the 1024 ports range.
- Widget support!
- Now you can remote control the app!
- General information about your device.
- Extensive logging (with support logging to files).
Visit us on: http://www.icecoldapps.com/
Follow us on Twitter: https://twitter.com/IceColdApps
Like us on Facebook: http://www.facebook.com/IceColdApps
1) Support Oracle and Postgresql SQL dialects
2) Include demo scheme with prefilled tables (similar scott/tiger scheme in oracle)
3) Support export/import SQL queries in/from external storage file
4) Tables and views browser
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
This updates SpatiaLite to version 4.2 Please note that SpatiaLite databases in this version are NOT compatible with the SpatiLite version (3.0.1) used in the old verion version.
I am working on a major update / rewrite of this app and looking for β users. If you want to participate please drop me a mail!
This an experimental build of aSQLiteManager 3.5 with some SpatiaLite support. From the Query Viewer you can do spatial queries. If peoples find this useful I might expand the functionality. This version FC if you try to open the idx_TableName_Geometry as this is done using the standard sqlite version that cannot handle btree's.
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.
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.
From version 1.2 and on you can run several GREP replace expression on the same file.
To help the novices in GREP – like my selves – GREP On The Run includes a small help / list of operators ;-)
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.