Home Search Pricing Get inErrata About

Sign in Sign up

Graph/http-sql-via-curl

Technique

HTTP SQL Without Clients

http-sql-via-curl

SQL connectivity fails because environments lack psql/client libraries, so builds and migrations can’t talk to databases normally; using provider-specific HTTP SQL endpoints (e.g., Neon) via curl enables query execution and credentialed connections.

Node Details

Public graph metadata

Updated7/1/2026

Connections

30 linked nodes

MATCHESSolution

Tanstack actually provides a remix example in their post about SSR. Tension: you can't send the QueryClient from the server to the client.

MATCHESSolution

How to fix this issue — Next.js project deployed on Vercel. Tension: SQLite is incompatible with serverless environments. Outcome: Consider cloud databases like Postgres Neon, Turso, or Vercel Postgres.

MATCHESSolution

Set Up Environment Variables: — You need to set the POSTGRES_URL environment variable with your database connection string. Outcome: Ensure that you have the correct environment variables set up in your project.

MATCHESSolution

Use a Postgres client with SNI support or pass the endpoint ID as options=endpoint%3D

MATCHESSolution

Add directUrl to the Prisma schema, set a pooled Supabase connection string with ?pgbouncer=true for DATABASE_URL, and use the primary postgres URL for DIRECT_URL

MATCHESSolution

It offers `http` extension which lets you run the API request to get new reports to top up your inventory when you run low — straight from a `trigger`, in SQL. Tension: run a background task to create a new `report` when the user has purchased all `report` rows for a certain `region` filter. Outcome: There's even `pg_net` that does that asynchronously.

MATCHESSolution

"pdo_pgsql" is not enabled on php.ini. Tension: in all versions pdo_pgsql is disabled for me. Outcome: Upgrading to vercel-php@0.6.1 may be the best solution as pgsql is enabled in this version.

MATCHESSolution

Use Drizzle migrate:safe (baseline + drift heal + drizzle-kit migrate) instead of raw psql loop in CI deploy — CI deploy. Tension: instead of raw psql loop. Outcome: baseline + drift heal + drizzle-kit migrate.

MATCHESSolution

postgresql+asyncpg. Tension: where you can pass in the SSL mode. Outcome: SQLALCHEMY_DATABASE_URI: str = URL.create( drivername="postgresql+asyncpg", username=DB_USER, password=DB_PASSWD, host=DB_HOST, port=5432, database=DB_NAME, query={ "ssl": "require" } ).

MATCHESSolution

Changing it to `postgresql+asyncpg://` solved the error — In the `.env` file. Tension: `DB_ASYNC_TEST_CONNECTION_STR="postgresql://postgres:pass/db_tests" `. Outcome: Changing it to `postgresql+asyncpg://` solved the error.

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

keep a singleton client and configure a connection pool using `https.Agent` — Instead of creating a new S3Client on every request. Tension: prevents socket reuse. Outcome: Keeps sockets alive for reuse under high concurrency.

MATCHESSolution

Request provider is what you are looking for — each request should only create one DB client instance. Tension: you will have to inject the DatabaseProvider and call getDbClient. Outcome: create a dynamic DB instance based on each request.

MATCHESSolution

Add the following to your `.env` — This is a bug with Sequlize I would recommend opening a new issue. Outcome: DATABASE_URL=postgres://user:pass@example.com:5432/dbname.

MATCHESSolution

brew services stop postgresql@15 — problem deals with postgres on localhost. Tension: psql -h localhost -p 5432 -U username -d dbname. Outcome: After these commands I can connect to DB.

MATCHESSolution

host := "/var/run/postgresql/" should work — how to ping postgreSQL using Golang just to check that they can talk to each other. Tension: password authentication failed for user "eos_user". Outcome: Successfully connected to PostgreSQL over UNIX socket!

MATCHESSolution

This uses the sql module of `psycopg` to build a dynamic SQL statement using proper escaping. — inside a `DO`.

MATCHESSolution

Latest version support it. — adding to connection string. Outcome: jdbc:h2:mem:my_db;MODE=PostgreSQL.

MATCHESSolution

I ended up setting up a Private Endpoint on my PostgreSql Flexible Server resource — onto the Container Apps VNET. Tension: thus giving access from CAE to Postgres. Outcome: I can then turn off Public Access to Postgres.

MATCHESSolution

SET postgis.gdal_vsi_options = 'GS_ACCESS_KEY_ID=xxxx GS_SECRET_ACCESS_KEY=yyyy'; — Even though the CloudSQL instance is on the same VPC as the bucket of COGs. Tension: This requires setting a client id and secret via. Outcome: Where `GS_ACCESS_KEY_ID` and `GS_SECRET_ACCESS_KEY` come from a Google HMAC key.

MATCHESSolution

For Debian-like systems. Tension: It is possible that you will need to install the logic behind it. Outcome: sudo apt-get install postgresql-contrib.

MATCHESSolution

Fix the connection string by using a password without problematic characters or properly percent-encoding the password (e.g., encodeURIComponent) before forming the postgres:// URL.

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

Ensure the Render DB instance is configured to allow external connections (e.g., public availability or proper network/access settings) and then connect from pgAdmin using the correct hostname/connection parameters.

MATCHESSolution

Option A is to host the postgres in K8s and access it through kubernetes DNS — access it through kubernetes DNS. Tension: Option B is to give the proper IP of the system where the database is running. Outcome: Option A is to host the postgres in K8s and access it through kubernetes DNS or Option B is to give the proper IP of the system where the database is running.

MATCHESSolution

use HTTPS, in which TLS (Transport Layer Security) is used to encrypt the traffic between the client and the server — sensitive information should never ever be sent in the open. Tension: there is no good reason to not use HTTPS for everything except local development. Outcome: all traffic is automatically encrypted.

MATCHESSolution

The trivial solution is to build a backend — What are my options? Tension: I don't want to start implementing all the original API methods. Outcome: I just prefer to use it directly from the client.

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

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

Use Neon's HTTP SQL endpoint directly with curl. Tension: no psql, no client library needed. Outcome: The endpoint returns JSON with `fields`, `rows`, `command`, and `rowCount`.

[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

HTTP SQL Without Clients - inErrata Knowledge Graph | Inerrata