-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
124 lines (119 loc) · 4.65 KB
/
index.html
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
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/milligram/1.3.0/milligram.min.css">
<script type="application/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/marked/0.3.19/marked.min.js"></script>
<link rel="icon" href="https://wiki.postgresql.org/favicon.ico" type="image/x-icon">
<base target="_blank">
<style>
.hz {
writing-mode: tb-rl;
transform: rotate(180deg);
}
td, th {
text-align: center;
white-space: nowrap;
vertical-align: bottom;
}
</style>
</head>
<body>
<div class="container box" style="margin:5rem auto;padding:4rem">
<h1>PostgreSQL-Clients</h1>
<table>
<tr>
<th style="border-bottom: 0;" colspan="2"/>
<th colspan="5">✨ Features</th>
<th style="border-bottom: 0;" />
<th colspan="3">🛢 Supported Data Types</th>
</tr>
<tr>
<th style="text-align: left;">Client</th>
<th style="text-align: left;">UI</th>
<th><div class="hz">Queries</div></th>
<th><div class="hz">Visualize</div></th>
<th><div class="hz">Analytics</div></th>
<th><div class="hz">Navigate</div></th>
<th><div class="hz">Multi-DB</div></th>
<th/>
<th>Tables,<br>Views,<br>Schemas,<br>Indices</th>
<th><div class="hz">Constraints</div></th>
<th><div class="hz">Functions</div></th>
<th style="text-align: left;">Version</th>
</tr>
<tr>
<td style="text-align: left;"><a href="http://localhost:8000">Adminer</a> *</td>
<td style="text-align: left;">★★</td>
<!-- Queries Visualize Analyt. Navigate Multi-DB -->
<td>✔</td><td> </td><td>(✔)</td><td>✔</td><td>✔</td><td/>
<!-- Tables… Constr. Triggers -->
<td>✔</td><td>(✔)</td><td>✔</td>
<td style="text-align: left;">4.6.3</td>
</tr>
<tr>
<td style="text-align: left;"><a href="http://localhost:8001">OmniDB</a> *</td>
<td style="text-align: left;">★★</td>
<!-- Queries Visualize Analyt. Navigate Multi-DB -->
<td>✔</td><td>✔</td><td>✔</td><td> </td><td>✔</td><td/><!-- some data analytics -->
<!-- Tables… Constr. Triggers -->
<td>✔</td><td>✔</td><td>✔</td>
<td style="text-align: left;">2.11.0</td>
</tr>
<tr>
<td style="text-align: left;"><a href="http://localhost:8002">pgAdmin 4</a></td>
<td style="text-align: left;">★★</td>
<!-- Queries Visualize Analyt. Navigate Multi-DB -->
<td>✔</td><td> </td><td>✔</td><td> </td><td> </td><td/>
<!-- Tables… Constr. Triggers -->
<td>✔</td><td>✔</td><td>✔</td>
<td style="text-align: left;">3.4</td>
</tr>
<tr>
<td style="text-align: left;"><a href="http://localhost:8003">pgweb</a></td>
<td style="text-align: left;">★★★</td>
<!-- Queries Visualize Analyt. Navigate Multi-DB -->
<td>✔</td><td> </td><td> </td><td> </td><td> </td><td/>
<!-- Tables… Constr. Triggers -->
<td>✔</td><td>✔</td><td> </td>
<td style="text-align: left;">0.9.12</td>
</tr>
<tr>
<td style="text-align: left;"><a href="http://localhost:8004/teampostgresql">TeamPostgreSQL</a></td>
<td style="text-align: left;">★</td>
<!-- Queries Visualize Analyt. Navigate Multi-DB -->
<td>✔</td><td> </td><td> </td><td>✔</td><td> </td><td/>
<!-- Tables… Constr. Triggers -->
<td>✔</td><td> </td><td>✔</td>
<td style="text-align: left;">1.08</td>
</tr>
</body>
</table>
<small>
* to log into the client enter <i>user:</i><code>admin</code>, <i>password:</i><code>admin</code>
</small>
<p/>
<h2>Usage</h2>
You can connect to multiple postgres servers:
<ul>
<li><span style="display: inline-table;">
<code>postgres</code>: a dockerized postgres instance for testing,<br>
the defaults are <i>user:</i><code>postgres</code>, <i>password:</i><code>postgres</code>, <i>database:</i><code>db</code>
</span></li>
<li><span style="display: inline-table;">
<code>172.17.0.1</code>: your local postgres instance (usually localhost),<br>
only works if remote connections are allowed,<br>
or you have to add <code>network_mode: host</code> in <code>docker-compose.yaml</code>.
</span></li>
</ul>
The default postgres port is <code>5432</code>.
</div>
<script>
var html = document.body.innerHTML;
var colorized = Array.prototype.map.call(html, function(letter) {
return letter === "✔" ? letter.fontcolor("green") : letter === "★" ? letter.fontcolor("gold") : letter;
}).join('');
document.body.innerHTML = colorized;
</script>
</body>
</html>