Slide 10 of 13

PostgreSQL

PostgreSQL: Query your databases directly

What it’s for: Application data including sales metrics, user counts, inventory, JSON data, and any PostgreSQL-stored data.

Also works with

TimescaleDB (time-series extension for PostgreSQL)

Trade-offs

ProsCons
Familiar SQL syntaxQuery performance varies
Advanced SQL features (CTEs, window functions)Connection management
JSON/JSONB supportNeed read access
TimescaleDB compatible

Best for

  • Application dashboards
  • Data already in PostgreSQL
  • Semi-structured data (JSON)
  • Time-series data with TimescaleDB
  • Combining technical and application metrics

Documentation

View the full documentation. Learning path coming soon!

PostgreSQL data source

Script

PostgreSQL is the power user’s choice among relational databases, and the data source gives you access to all its advanced features. CTEs (Common Table Expressions) let you write complex analytical queries that would be painful in plain SQL. Window functions enable running totals, rankings, and moving averages. Native JSON support means you can query JSONB columns directly, which is huge if you’re storing semi-structured data.

And if you’re using TimescaleDB, the time-series extension for PostgreSQL, the data source works seamlessly with it. Like with MySQL, connect to read replicas for dashboard queries to protect your production database.

PostgreSQL’s capabilities make it excellent for sophisticated application dashboards.

/
Previous Next