PHPackages dww510/phpliteadmin - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. dww510/phpliteadmin AbandonedArchivedLibrary[Database & ORM](/categories/database) dww510/phpliteadmin =================== phpLiteAdmin is a web-based SQLite database admin tool written in PHP 51281PHP Since Mar 12Pushed 2y ago1 watchersCompare [ Source](https://github.com/dww510/phpLiteAdmin)[ Packagist](https://packagist.org/packages/dww510/phpliteadmin)[ RSS](/packages/dww510-phpliteadmin/feed)WikiDiscussions master Synced 3w ago READMEChangelogDependenciesVersions (1)Used By (0) phpLiteAdmin ============ [](#phpliteadmin) Website: Bitbucket: What is phpLiteAdmin? --------------------- [](#what-is-phpliteadmin) phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2. Following in the spirit of the flat-file system used by SQLite, phpLiteAdmin consists of a single source file, phpliteadmin.php, that is dropped into a directory on a server and then visited in a browser. There is no installation required. The available operations, feature set, interface, and user experience is comparable to that of phpMyAdmin. News ---- [](#news) **05.07.2015: Just released phpLiteAdmin 1.9.6! [Download now](https://bitbucket.org/phpliteadmin/public/downloads/phpLiteAdmin_v1-9-6.zip)** Features -------- [](#features) - Lightweight - consists of a single 200KB source file for portability - Supports SQLite3 and SQLite2 databases - Translated and available in over 10 languages - and counting - Specify and manage an unlimited number of databases - Specify a directory and optionally its subdirectories to scan for databases - Create and delete databases - Add, delete, rename, empty, and drop tables - Browse, add, edit, and delete records - Add, delete, and edit table columns - Manage table indexes - Manage table triggers - Import and export tables, structure, indexes, and data (SQL, CSV) - View data as bar, pie, and line charts - Graphical search tool to find records based on specified field values - Create and run your own custom SQL queries in the free-form query editor/builder - Easily apply core SQLite functions to column values using the GUI - Write your own PHP functions to be available to apply to column values - Design your own theme using CSS or install a pre-made theme from the community - All presented in an intuitive, easy-to-use GUI that allows non-technical, SQL-illiterate users to fully manage databases - Allows multiple installations on the same server, each with a different password - Secure password-protected interface with login screen and cookies Demo ---- [](#demo) A live demo of phpLiteAdmin can be found here: Requirements ------------ [](#requirements) - a server with PHP >= 5.2.0 installed - at least one PHP SQLite library extension installed and enabled: PDO, SQLite3, or SQLiteDatabase PHP version 5.3.0 and greater usually comes with the SQLite3 extension installed and enabled by default so no custom action is necessary. Download -------- [](#download) The files in the source repositories are meant for development, not for use in production. You can find the latest downloads here: Installation ------------ [](#installation) See Configuration ------------- [](#configuration) **NEW** as of 1.9.4: You can now configure phpLiteAdmin in an external file. If you want to do this: - rename `phpliteadmin.config.sample.php` into `phpliteadmin.config.php` - do not change the settings in `phpliteadmin.php` but in `phpliteadmin.config.php` See for details. 1. Open `phpliteadmin.config.php` (or `phpliteadmin.php` before 1.9.4) in a text editor. 2. If you want to have a directory scanned for your databases instead of listing them manually, specify the directory as the value of the `$directory` variable and skip to step 4. 3. If you want to specify your databases manually, set the value of the `$directory` variable as false and modify the `$databases` array to hold the databases you would like to manage. ``` - The path field is the file path of the database relative to where `phpliteadmin.php` will be located on the server. For example, if `phpliteadmin.php` is located at "databases/manager/phpliteadmin.php" and you want to manage "databases/yourdatabase.sqlite", the path value would be "../yourdatabase.sqlite". - The name field is the human-friendly way of referencing the database within the application. It can be anything you want. ``` 4. Modify the `$password` variable to be the password used for gaining access to the phpLiteAdmin tool. 5. If you want to have multiple installations of phpLiteAdmin on the same server, change the `$cookie_name` variable to be unique for each installation (optional). 6. Save and upload `phpliteadmin.php` to your web server. 7. Open a web browser and navigate to the uploaded `phpliteadmin.php` file. You will be prompted to enter a password. Use the same password you set in step 4. Code Repository and pull requests --------------------------------- [](#code-repository-and-pull-requests) The code repository is available both on bitbucket and github: Github: Bitbucket: You are welcome to fork the project and send us pull requests on any of these platforms. Installing a theme ------------------ [](#installing-a-theme) 1. Download the themes package from the project Downloads page. 2. Unzip the file and choose your desired theme. 3. Upload `phpliteadmin.css` from the theme's directory alongside `phpliteadmin.php`. 4. Your theme will automatically override the default. Getting help ------------ [](#getting-help) The project's wiki provides information on how to do certain things and is located at . In addition, the project's discussion group is located at . Reporting errors and bugs ------------------------- [](#reporting-errors-and-bugs) If you find any issues while using the tool, please report them at [https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open](https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open) . ### Health Score 24 — LowBetter than 31% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity17 Limited adoption so far Community13 Small or concentrated contributor base Maturity41 Maturing project, gaining track record Bus Factor1 Top contributor holds 89.5% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Community Maintainers ![](https://www.gravatar.com/avatar/dcc560e28a68f24d83276e979755654ab67581ca483d28ec545f049014b13012?d=identicon)[dww510](/maintainers/dww510) --- Top Contributors [![crazy4chrissi](https://avatars.githubusercontent.com/u/6806325?v=4)](https://github.com/crazy4chrissi "crazy4chrissi (68 commits)")[![dww510](https://avatars.githubusercontent.com/u/1383254?v=4)](https://github.com/dww510 "dww510 (4 commits)")[![diracleo](https://avatars.githubusercontent.com/u/3370219?v=4)](https://github.com/diracleo "diracleo (2 commits)")[![dreadnaut](https://avatars.githubusercontent.com/u/584584?v=4)](https://github.com/dreadnaut "dreadnaut (1 commits)")[![Tazeg](https://avatars.githubusercontent.com/u/6105535?v=4)](https://github.com/Tazeg "Tazeg (1 commits)") ### Embed Badge ![Health badge](/badges/dww510-phpliteadmin/health.svg) ``` [![Health](https://phpackages.com/badges/dww510-phpliteadmin/health.svg)](https://phpackages.com/packages/dww510-phpliteadmin) ``` ### Alternatives [jdorn/sql-formatter a PHP SQL highlighting library 3.9k116.5M113](/packages/jdorn-sql-formatter)[propel/propel1 Propel is an open-source Object-Relational Mapping (ORM) for PHP5. 8351.6M87](/packages/propel-propel1) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)