DbNinja vs phpLiteAdmin
DbNinja
dbninja.comphpLiteAdmin
phpliteadmin.orgSide by side
| Figure | DbNinja | 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 | 2 | 1 |
| Spec score · Database Administration Tools | 8.2 (#5) | 7.7 (#12) |
| Database management | It manages databases, tables, events, indexes, foreign keys, triggers, procedures, functions, views, users, and privileges. | It can create and delete databases, manage tables and columns, browse and edit records, and manage indexes and triggers. |
| Deployment | DbNinja is installed by copying its package into a directory in the user's webroot and completing setup in a browser. | The tool consists of a single PHP source file that can be placed on a server and opened in a browser without installation. |
| Purpose | DbNinja is a web based application for MySQL database administration and development, including remote access to hosted servers. | phpLiteAdmin is a web-based SQLite database administration tool written in PHP. |
| Support | The contact page lists a technical support email address at [email protected]. | 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
DbNinja
DbNinja is a web application for administering and developing MySQL databases, including databases on remote hosted servers. It can manage database objects such as tables, events, indexes, triggers, procedures, views, users, and privileges. For maintenance, it backs up and restores database structure and data, and compares or synchronizes databases between hosts. Exports are available in CSV, SQL, Excel, and JSON formats. Query tools include syntax highlighting, saved favorite queries, and limits on fetched data and query execution time. You can connect to multiple hosts at once and work in tabs.
DbNinja is self-hosted: setup involves copying its package into a directory in your webroot and completing setup in a browser. It requires a PHP-enabled web server, PHP 5.3 or higher with mysqli, MySQL 4.1 or higher, and a recent major browser with cookies enabled. The Personal use plan is free and is for user-installed use from one computer at a time. Commercial licensing is available by quote.
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.