peepshow/ sinks/ sql

Category ◆ 10 sinks ◆

peepshow sink category

SQL & document

Persist every run into a queryable store — SQLite, Postgres, MongoDB.

Local SQL archive

SQLite

A local video archive that sqlite3 can query.

  • archive
  • compliance
Team SQL archive

Postgres

Full-blown SQL archive with auto-schema creation.

  • archive
  • search
  • compliance
Document store

MongoDB

Runs and frames written into MongoDB collections.

  • archive
  • search
OLAP archive

ClickHouse

Columnar OLAP archive — one row per run, JSONEachRow over HTTP.

  • archive
  • search
  • compliance
Embedded analytics

DuckDB

Embedded analytics — local .duckdb file you can query with SQL.

  • archive
  • search
Cloud data warehouse

Snowflake

Insert each run into a Snowflake table via the SQL API — enterprise data warehouse.

  • archive
  • search
  • analytics
Cloud data warehouse

BigQuery

Stream each run into a BigQuery table via the insertAll API — Google's data warehouse.

  • archive
  • search
  • analytics
Hosted search

Algolia

Index every run into an Algolia index for instant typo-tolerant search.

  • archive
  • search
Lakehouse warehouse

Databricks

Insert each run into a Databricks Delta table via the Statement Execution API.

  • archive
  • search
  • analytics
Wide-column store

Cassandra / Astra

Insert each run into a Cassandra or DataStax Astra table via the Stargate REST API.

  • archive
  • search

← All peepshow sinks

In SQL & document

Other categories