1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
# phpPgAdmin6
PHP Based administration tool for PostgreSQL. Blazing fast routing with [Slim Framework 3](https://www.slimframework.com/) and solid abstraction layer in its core with [AdoDB](https://adodb.org/).
[](https://packagist.org/packages/huasofoundries/phppgadmin6)
[](https://www.codacy.com/app/amenadiel/phpPgAdmin6?utm_source=github.com&utm_medium=referral&utm_content=HuasoFoundries/phpPgAdmin6&utm_campaign=Badge_Grade)
[](https://scrutinizer-ci.com/g/HuasoFoundries/phpPgAdmin6/?branch=develop)
[](https://scrutinizer-ci.com/g/HuasoFoundries/phpPgAdmin6/build-status/develop)
[](LICENSE.md)
[](https://app.fossa.io/projects/git%2Bgithub.com%2FHuasoFoundries%2FphpPgAdmin6?ref=badge_shield)
____________
This project is inspired in [phppgadmin](https://github.com/phppgadmin/phppgadmin). Said project stalled a few years ago so we took it, refactored almost entirely and added:
- Composer Installation and dependency management
- [PSR-2 Coding Standard](https://www.php-fig.org/psr/psr-2) (Will evolve to PSR-12 soon)
- [PSR-4 Autoloading](https://www.php-fig.org/psr/psr-4)
- Removal of global variables (WIP)
- Removal of superglobals in favour of [PSR-7 Message interfaces](http://www.php-fig.org/psr/psr-7/) (WIP)
- Full PHP 7+ support
- Usage of Dependency Injection compliant with [PSR-11 Container interface](http://www.php-fig.org/psr/psr-11/)
- Support for PG 9.3+ features (Materialized Views, BRIN Indexes, etc)
- Nice urls
## Requirements
- PHP 7.1+
- PostgreSQL v9+
- ext-psql
- [Composer](https://getcomposer.org/download/)
(If you're using PostgreSQL 7.4 or 8.x, or PHP 5.6+, you can still try versions RC2 and below, but you should really, realy upgrade).
---
## Installation
### Using Composer (recommended)
[Install Composer in your machine](https://getcomposer.org/download/).
Install with composer running the following command in your shell (replacing <FOLDER> whith your desired folder name)
```sh
composer create-project huasofoundries/phppgadmin6 <FOLDER> v6.0.* --no-dev --prefer-dist
```
Alternatively, clone this repo and run (inside then folder where the project was cloned)
```sh
composer install --no-dev
```
## Configuration
You can set the config options either in a `config.inc.php` (refer to [config.inc.example.php](config.inc.example.php) for an example)
AND/OR a [config.yml](config.yml). The use of the latter is complely optional. Keep in mind the config entries are merged giving
precedence to the ones in the YAML file.
### Server Blocks
Configuration has a `servers` entry whose details are in their on Wiki section: "[Config: Servers](https://github.com/HuasoFoundries/phpPgAdmin6/wiki/Config:-servers)"
---
## Rewrite Rules
As this project is built over [Slim Framework 3](https://www.slimframework.com/), **you'll need some rewrite rules for nice-urls to work**.
Please refer to Slim Framework 3 instructions on rewrite rules config for:
- [Nginx](http://www.slimframework.com/docs/v3/start/web-servers.html#nginx-configuration)
- [Apache](http://www.slimframework.com/docs/v3/start/web-servers.html#apache-configuration)
- [Lighttpd](http://www.slimframework.com/docs/v3/start/web-servers.html#lighttpd)
- [IIS](http://www.slimframework.com/docs/v3/start/web-servers.html#iis)
- [HHVM](http://www.slimframework.com/docs/v3/start/web-servers.html#hiphop-virtual-machine)
- [PHP Built-in dev server](http://www.slimframework.com/docs/v3/start/web-servers.html#php-built-in-server)
## Running inside a subfolder
If you're planning to run phpPgAdmin6 under a subfolder, make sure you set it **explicitly** in the config file(s). I gave up trying to
figure out the subfolder automatically and it's outside of this project's scope.
To set it in `config.inc.php`
```
$conf = [
'subfolder' => '/phppga_subfolder',
'other config...' => 'sure'
];
```
To set it in `config.yml`
```yaml
default_lang: auto
subfolder: '/phppha_subfolder'
```
Remember that values set on the `yml` config take precedence.
Besides, remember to modify your webserver configuration accordingly
```
location /subfolder/ {
try_files $uri $uri/ /subfolder/index.php$is_args$args;
}
```
Instead of
```
location / {
try_files $uri $uri/ /index.php$is_args$args;
}
```
(Implementation details for your specific setup fall **outside of this package's scope**)
#### Installing dev branch
If there's something broken and I cannot risk breaking the rest to fix your issue, I might push a fix or feature to [develop branch](https://github.com/HuasoFoundries/phpPgAdmin6/tree/develop). Said branch can be installed as
```sh
composer create-project huasofoundries/phppgadmin6 <FOLDER> v6.*.*@beta --no-dev --prefer-dist
```
(or, you know, clone the repo and make sure you're in develop branch)
## 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`
## 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](https://github.com/phppgadmin/phppgadmin)
- [Bugs](docs/BUGS.md)
- [Changelog](docs/CHANGELOG.md) (_outdated_)
- [Credits](docs/CREDITS.md)
- [Developers](docs/DEVELOPERS.md)
- [FAQ](docs/FAQ.md) (_outdated_)
- [History](docs/HISTORY.md) (_outdated_)
- [Translators](docs/TRANSLATORS.md)
Kudos to all people that helped build the original project, upon which this one was built.
|
