PipelineDB Documentation

Welcome to PipelineDB’s documentation! Here you’ll find (hopefully) everything you need to know about how to use PipelineDB and how it works. If there’s something you think is missing, confusing, or you find a bug or typo, or you think we’ve said something dumb, please don’t hesitate to reach out to us at docs@pipelinedb.com.

• Introduction
  • Overview
  • What PipelineDB is
  • What PipelineDB is not
• Quickstart
  • Wikipedia Traffic
• PipelineDB Installation
  • Install PostgreSQL
  • apt
  • yum
  • RPM Packages
  • Debian Packages
  • Creating the PipelineDB Extension
  • Running PostgreSQL
  • Configuration
  • Docker
  • macOS/OSX
• Continuous Views
  • Creating Continuous Views
  • Dropping Continuous Views
  • Truncating Continuous Views
  • Viewing Continuous Views
  • Data Retrieval
  • Time-to-Live (TTL) Expiration
  • Modifying TTLs
  • Activation and Deactivation
  • Examples
• Continuous Transforms
  • Creating Continuous Transforms
  • Dropping Continuous Transforms
  • Viewing Continuous Transforms
  • Continuous Transform Output Streams
  • Built-in Transform Output Functions
  • Creating Your Own Output Function
• Streams
  • Writing To Streams
  • Output Streams
  • Delta Streams
  • pipelinedb.stream_targets
  • Arrival Ordering
  • Event Expiration
• Built-in Functionality
  • General
  • Aggregates
  • PipelineDB-specific Types
  • PipelineDB-specific Functions
  • Bloom Filter Functions
  • Top-K Functions
  • Frequency Functions
  • HyperLogLog Functions
  • Distribution Functions
  • Miscellaneous Functions
  • Operational Functions
  • System Views
• Continuous Aggregates
  • Bloom Filter Aggregates
  • Frequency Tracking Aggregates
  • Top-K Aggregates
  • HyperLogLog Aggregates
  • Distribution Aggregates
  • Miscellaneous Aggregates
  • Combine
  • General Aggregates
  • Statistical Aggregates
  • Ordered-set Aggregates
  • Hypothetical-set Aggregates
  • Unsupported Aggregates
• Clients
  • Python
  • Ruby
  • Java
• Probabilistic Data Structures & Algorithms
  • Bloom Filter
  • Count-Min Sketch
  • Top-K
  • HyperLogLog
  • T-Digest
• Sliding Windows
  • Examples
  • Sliding Aggregates
  • Temporal Invalidation
  • step_factor
• Continuous JOINs
  • Stream-table JOINs
  • Supported Join Types
  • Examples
  • Stream-stream JOINs
• Backups
  • Exporting Specific Continuous Views
  • Restoring Continuous Views
• Replication
  • Streaming Replication
  • High Availability
• Integrations
  • Apache Kafka
  • Amazon Kinesis
• Statistics
  • pipelinedb.proc_stats
  • pipelinedb.query_stats
  • pipelinedb.stream_stats
  • pipelinedb.db_stats
• Configuration