82 lines
2.4 KiB
Markdown
82 lines
2.4 KiB
Markdown
|
# DBeaver — Database Connecties voor Homelab
|
||
|
|
|
||
|
|
## PostgreSQL (homelab op Synology NAS)
|
||
|
|
|
||
|
|
**Connection type:** PostgreSQL
|
||
|
|
|
||
|
|
| Instelling | Waarde |
|
||
|
|
|----------------------|---------------------------------|
|
||
|
|
| Host | 192.168.1.211 |
|
||
|
|
| Port | 5433 |
|
||
|
|
| Database | homelab |
|
||
|
|
| Username | mo |
|
||
|
|
| Password | (zie .env bestand) |
|
||
|
|
| SSL | disable (lokaal netwerk) |
|
||
|
|
|
||
|
|
**Schemas om te bekijken:**
|
||
|
|
- `dashboard` — favorites, passwords, calendar_events, settings, file_index, photos, widgets
|
||
|
|
|
||
|
|
**DBeaver stappen:**
|
||
|
|
1. New Database Connection → PostgreSQL
|
||
|
|
2. Vul bovenstaande gegevens in
|
||
|
|
3. Test Connection → Finish
|
||
|
|
4. In Database Navigator: rechtermuis op Tables → Refresh
|
||
|
|
|
||
|
|
|
||
|
|
## Neo4j (netwerk graph op Synology NAS)
|
||
|
|
|
||
|
|
**Connection type:** Neo4j (via Bolt)
|
||
|
|
|
||
|
|
| Instelling | Waarde |
|
||
|
|
|----------------------|---------------------------------|
|
||
|
|
| URI | neo4j://192.168.1.211:49153 |
|
||
|
|
| Browser UI | http://192.168.1.211:49154 |
|
||
|
|
| Username | neo4j |
|
||
|
|
| Password | (zie .env bestand) |
|
||
|
|
|
||
|
|
**DBeaver stappen (vereist Neo4j JDBC driver):**
|
||
|
|
1. New Database Connection → Neo4j
|
||
|
|
2. Vul URI, username, password in
|
||
|
|
3. Test Connection → Finish
|
||
|
|
4. Run queries zoals:
|
||
|
|
```cypher
|
||
|
|
MATCH (d:Device) RETURN d.ip, d.hostname, d.os_guess
|
||
|
|
MATCH (d:Device)-[:HAS_PORT]->(p:Port) RETURN d.ip, p.number, p.service
|
||
|
|
```
|
||
|
|
|
||
|
|
|
||
|
|
## Snelle setup via DBeaver CLI / Import
|
||
|
|
|
||
|
|
Je kunt ook deze `.dbeaver-data-sources.json` importeren:
|
||
|
|
|
||
|
|
```json
|
||
|
|
{
|
||
|
|
"folders": {},
|
||
|
|
"connections": {
|
||
|
|
"postgresql-homelab": {
|
||
|
|
"provider": "postgresql",
|
||
|
|
"driver": "postgresql-jdbc",
|
||
|
|
"name": "Homelab PostgreSQL",
|
||
|
|
"host": "192.168.1.211",
|
||
|
|
"port": "5433",
|
||
|
|
"database": "homelab",
|
||
|
|
"user": "mo",
|
||
|
|
"savePassword": true,
|
||
|
|
"configurationType": "MANUAL",
|
||
|
|
"properties": {
|
||
|
|
"connectTimeout": "20"
|
||
|
|
}
|
||
|
|
},
|
||
|
|
"neo4j-homelab": {
|
||
|
|
"provider": "neo4j",
|
||
|
|
"driver": "neo4j-jdbc",
|
||
|
|
"name": "Homelab Neo4j",
|
||
|
|
"url": "neo4j://192.168.1.211:49153",
|
||
|
|
"user": "neo4j",
|
||
|
|
"savePassword": true,
|
||
|
|
"configurationType": "MANUAL"
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
```
|