Table Of Contents
Latest update [menu]
It now works on Lollipop
Description [menu]
This software allows developers to view/edit their SQLite databases
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.
Instructions
=========
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.
Bibliography
============
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:
PHP
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/ )
Trivia
======
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.
About
=====
http://market.android.com/search?q=pname:com.marcosdiez.server.php
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)
2013-10-13
How to install SQLite Manager - phpLiteAdmin APK for Android [menu]
Download SQLite Manager - phpLiteAdmin APK file (com.marcosdiez.server.php_7_28217391.apk) from SameAPK.com, then follow these steps:
Update Phone Settings
- Go to your phone Settings page
- Tap Security or Applications (varies with device)
- Check the Unknown Sources box
- Confirm with OK
Go to Downloads
- Open Downloads on your device by going to My Files or Files
- Tap the APK file you downloaded (com.marcosdiez.server.php_7_28217391.apk)
- Tap Install when prompted, the APK file you downloaded will be installed on your device.
How to install SQLite Manager - phpLiteAdmin APK on Windows 7/8/10 or MAC PC? [menu]
Download SQLite Manager - phpLiteAdmin APK file(com.marcosdiez.server.php_7_28217391.apk) from SameAPK.com to your PC (ex: /Users/xxx/Downloads/(com.marcosdiez.server.php_7_28217391.apk)), then follow these steps:
Using Emulator:
- Download And Install one Emulator Softwares (Ex: Bluestacks, GenyMotion, NoxPlayer)
- Simple install APK on PC by drag and drop file com.marcosdiez.server.php_7_28217391.apk on Emulator screen
SQLite Manager - phpLiteAdmin APK Pros & Cons [menu]
Pros
- This app is safe, it's not require high risk permissions
- Compatible with 32 bit device (most Emulator using 32bit arch CPU)
- Compatible with 64-bit device (some android device and current Bluestacks)
Cons
Everything is good.