Home / Tools Apps / SQLite Manager - phpLiteAdmin on Windows Pc

SQLite Manager - phpLiteAdmin on Windows Pc

Developed By: Marcos Diez

License: Free

Rating: 4,1/5 - 29 votes

Last Updated: December 24, 2023

Compatible with Windows 10/11 PC & Laptop

App Details

Version	1.0.6
Size	26.9 MB
Release Date	March 12, 15
Category	Tools Apps
App Permissions: Allows applications to open network sockets. [see more (4)]
What's New: It now works on Lollipop [see more]
Description from Developer: 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 bac... [read more]

App preview ([see all 3 screenshots])

About this app

On this page you can download SQLite Manager - phpLiteAdmin and install on Windows PC. SQLite Manager - phpLiteAdmin is free Tools app, developed by Marcos Diez. Latest version of SQLite Manager - phpLiteAdmin is 1.0.6, was released on 2015-03-12 (updated on 2023-12-24). Estimated number of the downloads is more than 5,000. Overall rating of SQLite Manager - phpLiteAdmin is 4,1. Generally most of the top apps on Android Store have rating of 4+. This app had been rated by 29 users, 17 users had rated it 5*, 3 users had rated it 1*.

How to install SQLite Manager - phpLiteAdmin on Windows?

Instruction on how to install SQLite Manager - phpLiteAdmin on Windows 10 Windows 11 PC & Laptop

In this post, I am going to show you how to install SQLite Manager - phpLiteAdmin on Windows PC by using Android App Player such as BlueStacks, LDPlayer, Nox, KOPlayer, ...

Before you start, you will need to download the APK/XAPK installer file, you can find download button on top of this page. Save it to easy-to-find location.

[Note] You can also download older versions of this app on bottom of this page.

Below you will find a detailed step-by-step guide, but I want to give you a fast overview of how it works. All you need is an emulator that will emulate an Android device on your Windows PC and then you can install applications and use it - you see you're playing it on Android, but this runs not on a smartphone or tablet, it runs on a PC.

If this doesn't work on your PC, or you cannot install, comment here and we will help you!

Install using BlueStacks
Install using NoxPlayer

Step By Step Guide To Install SQLite Manager - phpLiteAdmin using BlueStacks

Download and Install BlueStacks at: https://www.bluestacks.com. The installation procedure is quite simple. After successful installation, open the Bluestacks emulator. It may take some time to load the Bluestacks app initially. Once it is opened, you should be able to see the Home screen of Bluestacks.
Open the APK/XAPK file: Double-click the APK/XAPK file to launch BlueStacks and install the application. If your APK/XAPK file doesn't automatically open BlueStacks, right-click on it and select Open with... Browse to the BlueStacks. You can also drag-and-drop the APK/XAPK file onto the BlueStacks home screen
Once installed, click "SQLite Manager - phpLiteAdmin" icon on the home screen to start using, it'll work like a charm :D

[Note 1] For better performance and compatibility, choose BlueStacks 5 Nougat 64-bit read more

[Note 2] about Bluetooth: At the moment, support for Bluetooth is not available on BlueStacks. Hence, apps that require control of Bluetooth may not work on BlueStacks.

How to install SQLite Manager - phpLiteAdmin on Windows PC using NoxPlayer

Download & Install NoxPlayer at: https://www.bignox.com. The installation is easy to carry out.
Drag the APK/XAPK file to the NoxPlayer interface and drop it to install
The installation process will take place quickly. After successful installation, you can find "SQLite Manager - phpLiteAdmin" on the home screen of NoxPlayer, just click to open it.

Discussion

(*) is required

Download older versions

Other versions available: 1.0.6.

Download SQLite Manager - phpLiteAdmin 1.0.6 on Windows PC – 26.9 MB

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

It now works on Lollipop

Allows applications to open network sockets.
Allows an application to write to external storage.
Allows an application to read from external storage.
Allows an application to receive the ACTION_BOOT_COMPLETED that is broadcast after the system finishes booting.