---
title: @sushindustries/db
description: The schema and the client. Drizzle over Postgres, with the connection kept server-side by construction.
source: https://adamjurek.com/packages/db
---

[GitHub Packages](https://github.com/sushindustries/sushindustries/pkgs/npm/db)

The schema and the client. Drizzle over Postgres, with the connection kept
server-side by construction.

## Install

```bash
pnpm add @sushindustries/db
```

## Two entry points, on purpose

```ts
// Safe anywhere. Table shapes and inferred types, no driver.
import { packageStats, type PackageStat } from "@sushindustries/db/schema";

// Server only. Reads DATABASE_URL and opens a connection.
import { getDb } from "@sushindustries/db/client";
```

The split is the whole design. `schema` carries types a form or a table needs,
so a component can import them without pulling a Postgres client into the
browser bundle. `client.server.ts` carries the connection, and its `.server.ts`
suffix is in TanStack Start's default client deny list - importing it from
client-reachable code is a build error, not a code review note.

## Migrations

```bash
export DATABASE_URL=postgres://...
pnpm db:generate   # write SQL from the schema
pnpm db:migrate    # apply it
pnpm db:studio     # browse it
```

## Why the connection is lazy

Railway injects `DATABASE_URL` at runtime, not at build time. A module-scope
connection would be constructed during the build with an undefined URL and take
down the whole deploy, instead of failing the one route that actually needs a
database.

## Where the database lives

The site's Postgres is a Railway service in the same project as the web
service, built from Railway's own `postgres-ssl` image with a volume mounted
at `/var/lib/postgresql/data`. The web service reads
`DATABASE_URL=${{Postgres.DATABASE_URL}}` - a reference, not a copy, so
rotating the password in one place rotates it everywhere.

Migrations run from a developer machine against the service's TCP proxy,
never from the app: the runtime image carries only the compiled server, and
a deploy that can rewrite the schema is a deploy that can fail halfway
through doing it.