Skip to content

feat(db): Postgres Db adapter — pg driver, pooler-safe schema scoping (HT-20) #18

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
zaridan merged 4 commits into from
Jul 11, 2026
Merged

feat(db): Postgres Db adapter — pg driver, pooler-safe schema scoping (HT-20) #18

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
4 commits
Select commit Hold shift + click to select a range
a97d11f
feat(db): Postgres Db adapter over pg with pooler-safe schema scoping…
zaridan Jul 11, 2026
ac6027a
fix(db): harden Postgres adapter per Codex adversarial review
zaridan Jul 11, 2026
2c90cd7
fix(db): address review findings — barrel exposure, pool resilience, …
zaridan Jul 11, 2026
132b1f7
Merge origin/main (HT-19 Gmail adapter) — union package deps
zaridan Jul 11, 2026
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
258 changes: 258 additions & 0 deletions package-lock.json
View file
Open in desktop

Some generated files are not rendered by default. Learn more about how customized files appear on GitHub.

3 changes: 3 additions & 0 deletions package.json
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -20,11 +20,14 @@
"dependencies": {
"@electric-sql/pglite": "^0.5.4",
"mimetext": "^3.0.28",
"pg": "^8.22.0",
"postal-mime": "^2.7.5"
},
"devDependencies": {
"@biomejs/biome": "2.5.3",
"@electric-sql/pglite-socket": "^0.2.7",
"@types/node": "^20.19.43",
"@types/pg": "^8.20.0",
"@vitest/coverage-v8": "4.1.10",
"typescript": "7.0.2",
"vitest": "4.1.10"
Expand Down
15 changes: 11 additions & 4 deletions src/db/index.ts
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -1,13 +1,20 @@
/**
* Barrel for the DB layer (`src/db/**`). Store modules (`src/store/**`) and
* anything wiring up a database connection import from here — never reach
* into `client.ts`/`migrate.ts` directly, and never import `@electric-sql/pglite`
* outside this directory (see `src/db/client.ts` for why the raw-SQL seam
* exists: the same SQL must run unmodified against a future Supabase-backed
* `Db`, so nothing above this barrel should know PGlite exists).
* into `client.ts`/`migrate.ts`/`postgres.ts` directly, and never import
* `@electric-sql/pglite` or `pg` outside this directory (see
* `src/db/client.ts` for why the raw-SQL seam exists: the same SQL runs
* unmodified against PGlite locally and real Postgres/Supabase in
* production, so nothing above this barrel should know which one it got).
*/

export type { Db, Queryable, Row, SqlValue } from './client.js'
export { createPgliteDb, PgliteDb } from './client.js'
export type { Migration } from './migrate.js'
export { migrate } from './migrate.js'
export type { PostgresDbOptions } from './postgres.js'
// Factory only — deliberately NOT the PostgresDb class: its constructor
// skips createPostgresDb's schema validation/provisioning, so exposing it
// would offer an unvalidated side door. (postgres.ts still exports the class
// for its own tests; nothing above this barrel should touch it.)
export { createPostgresDb } from './postgres.js'
Loading
Loading