pgAdmin vs phpLiteAdmin
pgAdmin
pgadmin.orgphpLiteAdmin
phpliteadmin.orgSide by side
| Figure | pgAdmin | phpLiteAdmin |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | — |
| iOS | — | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Database Administration Tools | 7.8 (#11) | 7.7 (#12) |
| Database support | It supports PostgreSQL and EDB Postgres Advanced Server versions that are supported when each pgAdmin version is released. | It supports SQLite 3 and SQLite 2 databases. |
| Deployment | It can run in desktop mode or in server mode for multiple users over the web. | The tool consists of a single PHP source file that can be placed on a server and opened in a browser without installation. |
| License | The PostgreSQL Licence permits use, copying, modification, and distribution without a fee, subject to its stated conditions. | The project README identifies the license as GNU GPL version 3 or, at the user's option, any later version, and provides the software without warranty. |
| Purpose | pgAdmin is a graphical management tool for PostgreSQL administration, development, and monitoring. | phpLiteAdmin is a web-based SQLite database administration tool written in PHP. |
| Support | There is no paid support; users can seek help through the support mailing list and public issue tracker. | The project README directs users to its wiki and discussion group for help and to its issue tracker to report bugs. |
Plans
In their own words
pgAdmin
pgAdmin is a graphical tool for administering, developing with, and monitoring PostgreSQL databases. It runs as desktop software or in server mode, where multiple users can access it over the web. It supports PostgreSQL and EDB Postgres Advanced Server versions supported at the time each pgAdmin release is issued. Query tools include syntax highlighting, a data grid, graphical query plans, schema diff, an ERD tool, and a procedural language debugger. Users can manage common database objects and inspect their SQL definitions, properties, dependencies, and available statistics. Maintenance features include a monitoring dashboard, auto-vacuum management, and on-demand backup, restore, vacuum, and analyze operations. It also supports SSH tunneling, data editing, query history, and binary, CSV, or text result exports. The free plan costs nothing under the PostgreSQL Licence. Downloads include Windows and macOS installers, Linux packages, Docker, a Python wheel, and source code. Only the latest release is supported; there are no long-term stable versions.
phpLiteAdmin
phpLiteAdmin is a free, web-based SQLite administration tool written in PHP. Its single PHP source file can be placed on a server and opened in a browser without installation, supporting SQLite 2 and SQLite 3 databases. It can create and delete databases, manage tables and columns, browse and edit records, and manage indexes and triggers. Import and export cover tables, structure, indexes, and data in SQL and CSV formats. Other tools include graphical record search, a free-form SQL query editor, and bar, pie, and line charts. The project describes a password-protected interface with login cookies and separate passwords for different installations. It says the interface is available in 15 languages and supports custom and community CSS themes. Hosting requires PHP 5.2.4 or later and an enabled PDO, SQLite3, or SQLiteDatabase extension. PDO and SQLite3 handle SQLite 3, while SQLiteDatabase handles SQLite 2. The stable download is version 1.9.8.2; development builds are updated automatically and tested less thoroughly. The project offers the software under GNU GPL version 3 or any later version, without warranty.