phpPgAdmin
An editor has nominated this article for deletion. You are welcome to participate in the deletion discussion, which will decide whether or not to retain it. |
 |
 | |
| Developer(s) | phpPgAdmin-Community |
|---|---|
| Stable release | 5.1
/ April 14, 2013[1] |
| Repository | |
| Written in | PHP |
| Operating system | Cross-platform |
| Available in | Multilingual (27) |
| Type | Web database management |
| License | GNU General Public License 2 or later[2] |
| Website | http://phppgadmin.sourceforge.net/doku.php?id=start |
phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server,[3] licensed under a free and open source license. Similar to phpMyAdmin, of which phpPgAdmin is also based on,[4] it is written in PHP and can be accessed with a web browser. PhpPgAdmin requires a web server with PHP[5], such as Apache or Nginx, and is therefore cross-platform[6].
History
The history of phpPgAdmin can be found on their about page:[4]
In late 2002. Christopher Kings-Lynne led the phpPgAdmin project in creating version three of phpPgAdmin. This version was a complete rewrite necessary to support some of the more advanced features of PostgreSQL 7.3, namely schemas. In rewriting the application, the team used many of the ideas it had learned working on the first generation of phpPgAdmin.
That work was based on Tobias Ratschiller's phpMyAdmin for MySQL. Major portions had been ported to work with PostgreSQL and with that came much new code, however the concepts and ideas all (except User Administration and PostgreSQL specific functionality) came from phpMyAdmin.
Dan Wilson used phpMyAdmin for several months at one of his previous employers. After leaving the company, he began to use PostgreSQL instead of MySQL and completely missed the amazing features and funcitonality available in phpMyAdmin. So what better to do than port it.
phpMyAdmin in turn was based on Peter Kuppelwieser's MySQL-Webadmin. It was his idea to create a web-based interface to MySQL using PHP3. Although Tobias did not use any of his source-code, there were some concepts borrowed from him. phpMyAdmin was created because Peter told Tobias he wasn't going to further develop his (great) tool.
Features
PhpPgAdmin has, among others, the following features:
- Administer multiple servers
- Support for PostgreSQL 9.0.x, 9.1.x, 9.2.x
- Manage all aspects of:
- Users & groups
- Databases
- Schemas
- Tables, indexes, constraints, triggers, rules & privileges
- Views, sequences & functions
- Advanced objects
- Reports
- Easy data manipulation:
- Browse tables, views & reports
- Execute arbitrary SQL
- Select, insert, update and delete
- Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump
- Import SQL scripts, COPY data, XML, CSV and Tabbed
- Supports the Slony master-slave replication engine
- Language support:
- Available in 27 languages
- No encoding conflicts. Edit Russian data using a Japanese interface
- Easy to install and configure
Current status
The software, which is currently - in version 5.1 - available in 27 languages,[1] is maintained by The phpPgAdmin Project.
References
- ^ a b "phpPgAdmin - start". phpPgAdmin. phpPgAdmin-Community. 2013-04-15. Retrieved 2017-01-02.
- ^ "phpPgAdmin License". Github. phpPgAdmin-Community. 2017-01-02. Retrieved 2017-01-02.
- ^ "phpPgAdmin download - SourceForge.net". SourceForge. phpPgAdmin-Community. 2013-06-11. Retrieved 2017-01-02.
- ^ a b "phpPgAdmin - about". phpPgAdmin. phpPgAdmin-Community. 2011-02-28. Retrieved 2017-01-02.
- ^ "phpPgAdmin - ArchWiki". wiki.archlinux.org. Arch community. 2015-12-28. Retrieved 2017-01-24.
- ^ Robert Treat (2006-04-01). "Running PostgreSQL in a cross-platform environment". TechTarget. Retrieved 2017-01-24.