Outpost Supply · Orders

A dashboard for a made-up outdoor-gear shop. The ui container is public. It queries Postgres by hostname over the environment's private network, and the database has no public address.

ui → db
–
Database sees this ui as
–
Postgres
–
Round trip to db
–
Revenue, last 30 days
–
Orders, last 30 days
–
Average order value
–
Customers
–

Daily revenue

Last 30 days, UTC, excluding refunds

Top products

By revenue, last 30 days

    Recent orders

    Newest 10, straight from the orders table
    OrderCustomerPlacedItemsTotalStatus