PostgreSQL
PostgreSQL is the open-source, enterprise-grade relational database connection supported in Pirivision's Port module.
Ideal for direct SQL access to factory databases, SCADA historians, MES systems, and quality records.
Strengths
| Feature |
Description |
| Open Source & Free |
Enterprise-scale use without licensing cost |
| ANSI SQL Compliance |
Standard SQL queries; full support for JOIN, CTE, window functions |
| Schema Support |
Tables can be logically grouped by schema (public, production, reporting) |
| JSON / JSONB |
Keep semi-structured and relational data in the same table |
| TimescaleDB Compatible |
Use the TimescaleDB extension for high-performance time-series queries |
| Large Data Scale |
Efficient querying of millions of rows with indexes |
| Reliability |
ACID-compliant; data integrity and transaction guarantees |
What You Can Do in Pirivision
| Action |
Description |
| SQL Query |
Retrieve data with SELECT, JOIN, WHERE, GROUP BY in Compass |
| Time Series |
Trend and range queries via a timestamp column |
| Cross-Table |
Combine multiple tables with JOIN |
| Filtered KPI |
Filter by plant, product, or shift using WHERE |
| Aggregation |
Produce summary metrics with AVG, SUM, COUNT, MIN, MAX |
| Live Refresh |
Periodic query refresh in Cartography widgets |
When Is It Used?
- SCADA / Historian: PostgreSQL-based historian systems for production line sensor data
- MES Integration: Access to production orders, shift records, and OEE data
- Quality Database: Querying SPC, measurement, and test results
- Energy Monitoring: Timestamped recording and analysis of meter readings
- TimescaleDB: Time-series queries optimized for high-frequency sensor data
Connection Requirements
| Information |
Required |
Default |
| Host |
Yes |
— |
| Port |
Yes |
5432 |
| Database Name |
Yes |
— |
| Schema |
No |
public |
| Username |
Yes |
— |
| Password |
Yes |
— |
Guides
Next Step
After adding a PostgreSQL data source, create a SQL query in the Compass module.
→ Add PostgreSQL Data Source