Back to plugin list
homebrew
Official
Premium

Homebrew

The Homebrew Source plugin for CloudQuery extracts configuration from the Homebrew Analytics API and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v4.1.1

Type

Source

Platforms
Date Published

Feb 20, 2024

Price per 1M rows

$100

free quota

1M rows

Set up process


brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync homebrew.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview

The Homebrew Source plugin for CloudQuery extracts configuration from the Homebrew Analytics API and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more).
The Homebrew Analytics API exposes data for the top 10,000 Homebrew formula installs, aggregated over 30-day, 90-day, and 365-day periods. The plugin can fetch data for any of these periods. When synced on a regular basis, the plugin can be used to track the popularity of Homebrew formulae over time.

Configuration

The following configuration syncs from Homebrew to a Postgres destination. The (top level) source spec section is described in the Source Spec Reference. The config for the postgresql destination is not shown here. See our Quickstart if you need help setting up the destination.
kind: source
spec:
  name: "homebrew"
  path: "cloudquery/homebrew"
  registry: "cloudquery"
  version: "v4.1.1"
  tables: ["*"]
  destinations:
    - "postgresql"
  backend_options:
    table_name: "cq_state_homebrew"
    connection: "@@plugins.postgresql.connection"
  spec:

Homebrew Spec

This is the (nested) spec used by the Homebrew source plugin:
  • concurrency (integer) (optional) (default: 50000)
    The best effort maximum number of Go routines to use. Lower this number to reduce memory usage.

Example Queries

select number, formula, count, percent from homebrew_analytics_installs_30d order by number asc limit 10;
number  formula          count   percent
------  ---------------  ------  -------
1       openssl@1.1      991372  2.03
2       ca-certificates  946778  1.93
3       xz               903305  1.85
4       icu4c            764268  1.56
5       jpeg-turbo       742750  1.52
6       fontconfig       652903  1.33
7       sqlite           633506  1.29
8       pcre2            633417  1.29
9       glib             603405  1.23
10      libx11           600437  1.23


Subscribe to product updates

Be the first to know about new features.