Back to source list
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.7.24
Type
Source
Platforms
Date Published
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.7.24"
tables: ["*"]
destinations:
- "postgresql"
backend_options:
table_name: "cq_state_homebrew"
connection: "@@plugins.postgresql.connection"
# Learn more about the configuration options at https://cql.ink/homebrew_source
spec:
Homebrew Spec #
This is the (nested) spec used by the Homebrew source plugin:
concurrency(integer) (optional) (default:50000)A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.scheduler(string) (optional) (default:dfs) The scheduler to use when determining the priority of resources to sync. Supported values aredfs(depth-first search),round-robin,shuffleandshuffle-queue.For more information about this, see performance tuning.
Example Queries #
List the most popular Homebrew formulae by number of installs in the last 30 days #
select number, formula, count, percent from homebrew_analytics_installs_30d order by number asc limit 10;
number formula count percent
------ --------------- ------ -------
1 [email protected] 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