Module @esposter/db - v2.36.0

@esposter/db

Database connection utilities for Esposter — server environment only. Provides composables for Drizzle ORM (PostgreSQL), Azure Table Storage, Azure Blob Storage, Azure AI Search, and Azure WebPubSub.

📖 Documentation
⚖️ License

📖 Documentation

We highly recommend you take a look at the documentation to level up.

What's Included

Composable / Service	Description
Drizzle (PostgreSQL)	`drizzle-orm` client wired to the `DATABASE_URL` connection string
Azure Table Storage	`useTableClient` — creates a typed `TableClient` for a given table name
Azure Blob Storage	`useBlobServiceClient` — creates a `BlobServiceClient`
Azure AI Search	`useSearchIndexClient` — creates a typed `SearchIndexClient`
Azure WebPubSub	`useWebPubSubServiceClient` — creates a `WebPubSubServiceClient`
Link preview	`getLinkPreview` — fetches Open Graph metadata from a URL

Architecture Notes

Server-only: this package must not be imported in browser code.
Depends on @esposter/db-schema for Drizzle relation and schema definitions.
Azure clients currently use the credential form required by each caller. Some app-facing paths still use connection strings or keys because the main app is hosted outside Azure and does not have managed identity.

Commands

Run from packages/db/:

pnpm build        # compile to dist/
pnpm test         # vitest watch mode (coverage is run from the repo root)
pnpm lint:fix     # auto-fix lint
pnpm typecheck    # type check