npm install @latimer-woods-tech/analytics

wrangler secret put POSTHOG_API_KEY

import { CREATE_FACTORY_EVENTS_TABLE } from '@latimer-woods-tech/analytics';
await db.execute(CREATE_FACTORY_EVENTS_TABLE);

CREATE TABLE IF NOT EXISTS factory_events (
  id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  app_id      TEXT NOT NULL,
  user_id     TEXT,
  event       TEXT NOT NULL,
  properties  JSONB DEFAULT '{}',
  created_at  TIMESTAMPTZ DEFAULT now()
);

function track(opts: {
  db: Db;
  posthogKey: string;
  appId: string;
  event: string;
  userId?: string;
  properties?: Record<string, unknown>;
}): Promise<void>;

function identify(opts: {
  posthogKey: string;
  userId: string;
  traits: Record<string, unknown>;
}): Promise<void>;

function getEvents(
  db: Db,
  opts: {
    appId: string;
    userId?: string;
    event?: string;
    limit?: number;
    since?: Date;
  },
): Promise<FactoryEvent[]>;

import { track } from '@latimer-woods-tech/analytics';

await track({
  db: createDb(env.DB),
  posthogKey: env.POSTHOG_API_KEY,
  appId: 'focusbro',
  event: 'subscription.created',
  userId: user.id,
  properties: { plan: 'pro', mrr: 29 },
});