DbNinja vs pgAdmin
DbNinja
dbninja.com
pgAdmin
pgadmin.orgSide by side
| Figure | DbNinja | pgAdmin |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 2 | 1 |
| Spec score · Database Administration Tools | 8.2 (#5) | 7.8 (#11) |
| Deployment | DbNinja is installed by copying its package into a directory in the user's webroot and completing setup in a browser. | It can run in desktop mode or in server mode for multiple users over the web. |
| Purpose | DbNinja is a web based application for MySQL database administration and development, including remote access to hosted servers. | pgAdmin is a graphical management tool for PostgreSQL administration, development, and monitoring. |
| Query tools | It offers syntax highlighting, saved favorite queries, and limits for fetched data and query execution time. | Its tools include a syntax highlighting query tool, data grid, graphical query plan display, schema diff, ERD tool, and procedural language debugger. |
| Support | The contact page lists a technical support email address at [email protected]. | There is no paid support; users can seek help through the support mailing list and public issue tracker. |
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.
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.