DataboxDatabox Databox
Connect to your PostgreSQL Data with Databox

PostgreSQL
Dashboard and Reporting Software

Connect now

PostgreSQL is a powerful, open-source, object-relational database management system. It offers advanced features, scalability, and stability, making it widely used for handling large amounts of structured and unstructured data efficiently.

Visualize important business data from your company’s databases

Use PostgreSQL queries to pull data from your proprietary database and showcase it alongside data from popular services like Mixpanel, Google Analytics and Salesforce.

With Databox, your most important KPIs will be transformed into meaningful insights and delivered to your mobile, Apple Watch, TV display or Slack channels. One of the key benefits of Databox is the ability to combine multiple data sources in one place.

Learn more about the integrations

  • Technical Details
  • Behavior & Usage
  • Help Articles
Category
Sort by

General

  • Description
    PostgreSQL is a powerful, open-source, object-relational database management system. It offers advanced features, scalability, and stability, making it widely used for handling large amounts of structured and unstructured data efficiently.
  • Categories
    Databases
  • Status
    stable

Specification

  • Authentication Method
    other
  • Time Zone
    User- or source-specific
  • Media Creatives Available
    No
  • Metric Builder Available
    Yes

Metric Builder

  • Run Query
    - The metrics are categorized under the "general" type.
    - Granularities available are hourly, daily, weekly, monthly, quarterly, yearly and all-time.
    - Custom relative periods are available.
  • Missing data on Databoard with the SQL query pushing several values to the same day (1 value)

    Databox recommends to group data by day in the SQL query in Metric Builder. If you have several entries for the same date, you need to configure your SQL query to group all values for the given day. You can use Aggregation Functions such as SUM, MIN, MAX, AVG, Count in the SQL query and GROUP BY date DESC to take all values for a day into consideration and compute them based on used Aggregated Function to display all data from your SQL database.
    You can learn more about Data Types in Databox here.

Track all of your key business metrics from one screen

GET STARTED
Databox app preview