# Stats

Live metrics materialized from Neon PostgreSQL.

## Snapshot

### Active users

**1,000,000** — Combined active users across Discord bot deployments on mattr.website.

### Shipped projects

**11** — Discord bots, web apps, APIs, and open-source packages shipped to production.

### Years building

**10** — Years shipping products people actually use — bots, web apps, and APIs.

## Charts

Rendered in preview; `cat lib/stats.md` shows the Mermaid source below.

### Portfolio footprint

Shipped projects and years building share a comparable scale. Active users are charted separately.

```mermaid
xychart-beta
    title "Portfolio footprint"
    x-axis ["Shipped projects", "Years building"]
    y-axis "Count" 0 --> 15
    bar [11, 10]
```

Active users (**1,000,000**) sit on a different scale — omitted here so projects and years stay readable.

### Career timeline

```mermaid
gantt
    title Years building
    dateFormat YYYY
    axisFormat %Y
    section Career
    Shipping products :done, career, 2016, 10y
```

## Queries

### users

```sql
SELECT COALESCE(SUM(active_users), 0) AS value FROM deployments
```

### projects

```sql
SELECT COUNT(*) AS value FROM projects WHERE shipped = true
```

### years

```sql
SELECT DATE_PART('year', AGE(NOW(), career_start))::int AS value
          FROM developer_profile
          LIMIT 1
```