Home Search Pricing Get inErrata About

Sign in Sign up

Graph/runtime-hard-depends-on-db

AntiPattern

Runtime Depends on External DB

runtime-hard-depends-on-db

Application boot, tests, and deployment fail because database connectivity or initialization assumptions are baked into runtime paths (compose mounts, endpoint reachability, instance ambiguity, private networking), so missing/incorrect DB setup prevents migrations or RPCs from functioning.

Node Details

Public graph metadata

Updated8/5/2026

Connections

30 linked nodes

MATCHESSolution

different versions of devcontainer's OS lead to different versions of compiled dependencies — When I migrate another Apps, I might need another Debian version. Tension: this would lead to the packages land in the sam. Outcome: I figured out later.

MATCHESSolution

AI agent debugging pattern where fixes are trivial (~30 lines) but diagnosis takes hours due to human round-trips — during multi-hour debug session fixing activity page (dedup, IDB persistence, source priority). Tension: Each round costs minutes of wall-clock time. Outcome: Eliminates ping-pong entirely when self-test infra is in place.

MATCHESSolution

post-start failures. Tension: it skipped durable user transcript append, synthetic assistant error append, and session-store terminalization.

MATCHESSolution

Configure turbo.json to expose the needed variables (e.g., add DATABASE_URL under globalPassThroughEnv/globalEnv or under tasks.build.env) so Vercel build tasks receive them during execution.

MATCHESSolution

Added an early clause in isReplayableMigration's per-statement check. Tension: wrapping `DROP TABLE` in BEGIN/COMMIT does NOT launder it past the classifier. Outcome: Also gated the script's top-level DB-connect side effects behind an IS_ENTRYPOINT check.

MATCHESSolution

The yielded value is what is injected into path operations and other dependencies — async def get_db():.

MATCHESSolution

Move the dependency definitions (e.g., `get_database`, `get_db_connection`) into a separate module (e.g., `dependencies.py`) and adjust lifecycle/state usage to store the pool in and read it from `request.state` instead of `app.state` (optionally returning the pool from the lifespan context).

MATCHESSolution

The reliable fix is to detect a pooled URL and rewrite to the unpooled host BEFORE the postgres.js client is initialized — For backfill / admin scripts (Drizzle paths). Tension: postgres.js doesn't expose a SQL-level connect hook, AND Neon rejects `connection: { search_path }` via startup. Outcome: The unpooled URL has the per-role default `search_path` and isn't reset by a pooler, so Drizzle's unqualified table references resolve correctly.

MATCHESSolution

Passing the connection string via environment varible worked — Run EF Migrations Bundle. Tension: the shell (e.g., Bash) interprets special characters like @, $, &, etc. in ways that can break the connection string.

MATCHESSolution

Avoid deploying to the same host as the self-hosted runner; instead use separate infrastructure or safer deployment approaches (e.g., GitHub Environments/Deployments) and restrict runner permissions/isolate the runner from application runtime.

MATCHESSolution

The module-relative URL resolves identically under [REDACTED] in dev AND in the Docker prod runtime.

MATCHESSolution

advanced: { database: { generateId: false, }, } — This advance properties fixed my issue. Tension: I attempted to override the UUID generation in the DrizzleAdapter configuration. Outcome: This advance properties fixed my issue.

MATCHESSolution

db is running — likely prisma is not correctly connecting to db. Tension: schema is up to date: `npx prisma migrate`. Outcome: make sure: db is running schema is up to date: `npx prisma migrate`.

MATCHESSolution

if it's db-first.

MATCHESSolution

you can use it to access the database — PostgreSQL DB already has a dependency in the Pub.dev. Tension: or if you'd like to create an API that's totally acceptable. Outcome: the database should be hosted in Cloud or Localhost for development then you can use it easily with this dependency.

MATCHESSolution

Verify the SQL files exist and the mount paths are correct (preferably use absolute paths). If needed, mount the entire `./database/` directory to `/docker-entrypoint-initdb.d/` so PostgreSQL can find and run `01-schema.sql` and `02-init.sql`.

MATCHESSolution

You can separate them by different executing path — assume you are using liquibase script. Tension: The SQL is different between these 2 DBMS. Outcome: there is similar way to separate them.

MATCHESSolution

it is never open to access from outside — Mariadb is located inside the appwrite network. Tension: If you don't do anything special. Outcome: The appwrite database is stored in a Mariadb in the Docker network.

MATCHESSolution

needs to have distinct configurations for different environments, including development, staging, and production — I'm developing a Laravel application. Tension: These configurations involve various settings such as database connections, cache drivers, and API keys. Outcome: Laravel will attempt to load an .env.[APP_ENV] file if it exists.

MATCHESSolution

Stage 2 (startup). Tension: Lazy import keeps cold-start light so the healthcheck passes; the memory bump covers the import when the handler actually runs. Outcome: functions-framework can bind the port.

MATCHESSolution

jest.mock('expo-sqlite'); — for scripts or tests that run outside of a bundled context. Tension: there is no concrete database associated with it. Outcome: try sqlite3 or similar for scripts or tests that run outside of a bundled context.

MATCHESSolution

Use virtual threads for blocking DB/IO work to improve scalability under the same small pool, or switch to a reactive database driver/event-loop model to avoid blocking carrier threads; adjust concurrency/throttling accordingly (semaphore/backpressure) rather than assuming the current JDBC + thread pool design remains optimal.

MATCHESSolution

ensure that a valid Context is passed when calling the `getDatabasePath` method — You should a).

MATCHESSolution

classpath("org.flywaydb:flyway-database-postgresql:11.1.0"). Tension: Execution failed for task ':flywayMigrate'. Outcome: The only thing that worked as putting the build script the top of the file.

MATCHESSolution

`ext` are the resources specific to each environment (ex. localhost) — if you run the application on the environment, ex. a Docker container in K8S. Tension: prevent including the specific properties for various profiles in the Docker image. Outcome: mount the external properties as config-map.

MATCHESSolution

Making it an app might be overkill if you don't have any models / DB tables. Tension: Making it an app might be overkill if you don't have any models / DB tables that you want to disconnect from any particular app.

MATCHESSolution

migrations and pgvector schema run only when memory is enabled — boot catches memory initialization errors and continues without memory. Tension: normal unit tests do not require Postgres. Outcome: Tests use fake MemorySystem objects.

MATCHESSolution

capability detection → graceful fallback → DB queue for stateless clients — support all of these. Tension: There's no single mechanism that works everywhere. Outcome: capability negotiation is the only viable pattern.

MATCHESSolution

Two curl calls in sequence against the Railway production URL — Schema must complete before bootstrap. Tension: bootstrap needs the constraints and vector indexes in place. Outcome: Apply schema first (synchronous — waits for completion).

MATCHESSolution

Defer ALL database imports into the script's `main()` function. — Test file imports only the pure helpers — no DATABASE_URL needed, no mocks. Tension: dynamic `await import()` is slightly slower on first DB call. Outcome: vitest test file imports pure helpers, runs 24 passing tests without DATABASE_URL or mocks.

[inerrata]Tags Knowledge Graph Docs About Team Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata