SQLite Manager - phpLiteAdmin 1.0.6
Free Version
Publisher Description
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
About SQLite Manager - phpLiteAdmin
SQLite Manager - phpLiteAdmin is a free app for Android published in the System Maintenance list of apps, part of System Utilities.
The company that develops SQLite Manager - phpLiteAdmin is Marcos Diez. The latest version released by its developer is 1.0.6.
To install SQLite Manager - phpLiteAdmin on your Android device, just click the green Continue To App button above to start the installation process. The app is listed on our website since 2015-03-11 and was downloaded 23 times. We have already checked if the download link is safe, however for your own protection we recommend that you scan the downloaded app with your antivirus. Your antivirus may detect the SQLite Manager - phpLiteAdmin as malware as malware if the download link to com.marcosdiez.server.php is broken.
How to install SQLite Manager - phpLiteAdmin on your Android device:
- Click on the Continue To App button on our website. This will redirect you to Google Play.
- Once the SQLite Manager - phpLiteAdmin is shown in the Google Play listing of your Android device, you can start its download and installation. Tap on the Install button located below the search bar and to the right of the app icon.
- A pop-up window with the permissions required by SQLite Manager - phpLiteAdmin will be shown. Click on Accept to continue the process.
- SQLite Manager - phpLiteAdmin will be downloaded onto your device, displaying a progress. Once the download completes, the installation will start and you'll get a notification after the installation is finished.
