huasofoundries/phppgadmin6
Like phpmyadmin but for postgres
Installs: 210
Dependents: 0
Suggesters: 0
Stars: 35
Watchers: 15
Forks: 13
Open Issues: 14
Type:project
Requires
- php: >=5.6.0
- ext-pgsql: *
- slim/slim: ^3.6
- slim/twig-view: ~2.1.1
- php-console/php-console: ~3.1
- twig/twig: ~1.28
- kint-php/kint: ^2.1
- adodb/adodb-php: ^5.20
- slim/flash: ^0.4.0
Requires (Dev)
- friendsofphp/php-cs-fixer: ^2.4
- codeception/codeception: *
- simpletest/simpletest: ^1.1
- phpmd/phpmd: ^2.6
- dev-master
- 6.0.0-beta.50
- 6.0.0-beta.49
- 6.0.0-beta.48
- 6.0.0-beta.47
- 6.0.0-beta.46
- 6.0.0-beta.45
- 6.0.0-beta.44
- 6.0.0-beta.43
- 6.0.0-beta.42
- 6.0.0-beta.41
- 6.0.0-beta.40
- 6.0.0-beta.39
- 6.0.0-beta.38
- 6.0.0-beta.37
- 6.0.0-beta.36
- 6.0.0-beta.35
- 6.0.0-beta.34
- 6.0.0-beta.33
- 6.0.0-beta.32
- 6.0.0-beta.31
- 6.0.0-beta.30
- 6.0.0-beta.29
- 6.0.0-beta.28
- 6.0.0-beta.27
- 6.0.0-beta.26
- 6.0.0-beta.25
- 6.0.0-beta.24
- 6.0.0-beta.23
- 6.0.0-beta.22
- 6.0.0-beta.21
- 6.0.0-beta.20
- 6.0.0-beta.19
- 6.0.0-beta.18
- 6.0.0-beta.17
- 6.0.0-beta.16
- 6.0.0-beta.15
- 6.0.0-beta.14
- 6.0.0-beta.13
- 6.0.0-beta.12
- 6.0.0-beta.11
- 6.0.0-beta.10
- 6.0.0-beta.9
- 6.0.0-beta.8
- 6.0.0-beta.7
- 6.0.0-beta.6
- 6.0.0-beta.5
- 6.0.0-beta4
- 6.0.0-beta3
- 6.0.0-beta2
- 6.0.0-beta1
- 6.0.0-alpha3
- dev-develop
- dev-simpler_loops
- dev-analysis-8K9PBD
- dev-legacy
README
PHP Based administration tool for PostgreSQL.
This is a hard fork of phppgadmin which adds the following enhancements:
- Composer Installation and dependency management
- Autoloading (thanks to the above)
- Namespaced classes
- Removal of global variables
- Full PHP 7+ support
- Support for PG 9.3+ features (Materialized Views, BRIN Indexes, etc)
Other enhancements are in progress and would be a nice to have:
- Nice urls
- Replace usage of superglobals with PSR-7 Message interfaces to carry information around.
- Usage of Dependency Injection compliant with PSR-11 Container interface
This project is made on top of Slim Framework 3, although a big part of the code doesn't use its full features yet.
Credits & FAQ
We're preserving due credits to all people that contributed in the past, as well as other release notes contained in the old version of phppgadmin
- Bugs
- Changelog (outdated)
- Credits
- Developers
- FAQ (outdated)
- History (outdated)
- Translators
Kudos to all people that helped build the original project, upon which this one was built.
Installation
Using Composer (recommended)
Install Composer in your machine.
Install with composer running the following command in your shell (replacing whith your desired folder name)
composer create-project huasofoundries/phppgadmin6 <FOLDER> *@beta
Alternatively, clone this repo and run (inside then folder where the project was cloned)
composer install --no-dev
Rewrite Rules
As this project is built over Slim Framework 3, you'll need some rewrite rules for this software to work.
Apache
Make sure you have the RewriteEngine module active in your Apache installation.
Place an .htaccess
file on your project root with the following contents
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^ index.php [QSA,L]
Nginx
Add the following vhost to your sites-enabled
folder
server {
listen 80;
# or whatever port you want
server_name yourservername.com;
root /path/to/project;
index index.php;
# Use this block if you're running in your domain or subdomain root
location / {
try_files $uri $uri/ /index.php$is_args$args;
}
# If running inside a subfolder use instead
#location /subfolder/ {
# try_files $uri $uri/ /subfolder/index.php$is_args$args;
#}
# pass the PHP scripts to FastCGI server listening on IP:PORT or socket
location ~ \.php$ {
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_split_path_info ^(.+\.php)(/.+)$;
# Check that the PHP script exists before passing it
try_files $fastcgi_script_name =404;
# Bypass the fact that try_files resets $fastcgi_path_info
# see: http://trac.nginx.org/nginx/ticket/321
set $path_info $fastcgi_path_info;
fastcgi_param PATH_INFO $path_info;
fastcgi_index index.php;
include /etc/nginx/fastcgi_params;
fastcgi_pass unix:/run/php/php7.0-fpm.sock;
# or fastcgi_pass 127.0.0.1:9000; depending on your PHP-FPM pool
}
}
Please note that you have to customize your server name, php upstream (sock or IP) and optinally the subfolder you want phpPgAdmin6 to run on.
License
This work is licensed under MIT or GPL 2.0 (or any later version) or BSD-3-Clause You can choose between one of them if you use this work.
SPDX-License-Identifier: MIT OR GPL-2.0-or-later OR BSD-3-Clause