Connection string with localhost don't work in library mode about crystal

[benjie]

The CLI takes the flags and converts them into library-mode equivalents, e.g. here's where it takes the connection CLI flag and adds it to the configuration for library mode:

crystal/postgraphile/postgraphile/src/cli.ts

Lines 204 to 212 in 6124725

	const newPgServices = [
	makePgService({
	connectionString,
	schemas,
	superuserConnectionString,
	...(rawSubscriptions ? { pubsub: true } : null),
	}),
	];
	preset.pgServices = newPgServices;

Please can you show a reproduction of your issue?

[sidux]

Sorry, actually it's due the -c option not really related to the library mode.

file : .env

DATABASE_URL=postgres://dev:dev@locahost:5430/flashdb

file : graphile.config.js

import { PostGraphileAmberPreset } from "postgraphile/presets/amber";
import { PgSimplifyInflectionPreset } from "@graphile/simplify-inflection";
import { makePgService } from "postgraphile/adaptors/pg";
import dotenv from "dotenv";

dotenv.config({ path: ".env" });

const preset = {
  extends: [PostGraphileAmberPreset, PgSimplifyInflectionPreset],
  schema: {
    pgJwtSecret: process.env.JWT_SECRET,
  },
  gather: {
    pgJwtTypes: "jwt_token",
  },
  pgServices: [
    makePgService({
      connectionString: process.env.DATABASE_URL,
      pubsub: true,
    }),
  ],
  grafserv: { watch: true },
};

export default preset;

when running postgraphile it doesn't work (error : postgres says: Error: getaddrinfo ENOTFOUND locahost)
when running postgraphile -c 'postgres://dev:dev@localhost:5430/flashdb' it works fine

If edit .env file with :

DATABASE_URL=postgres://dev:[email protected]:5430/flashdb

both work fine

[benjie]

You’ve misspelt localhost as locahost.

[sidux]

Oh yeah sorry, It was a mistake while trying to reproduce, but still after fixing it DATABASE_URL=postgres://dev:dev@localhost:5430/flashdb

bun postgraphile command works
but
bun server.ts doesn't work

both work well with 127.0.0.1

here is my server.ts

import Fastify from "fastify";
import { grafserv } from "grafserv/fastify/v4";
import preset from "./graphile.config.js";
import { postgraphile } from "postgraphile";

const pgl = postgraphile(preset);
const server = pgl.createServ(grafserv);
const app = Fastify({ logger: true });

server.addTo(app).catch((e) => {
  console.error(e);
  process.exit(1);
});

app.listen({ port: preset.grafserv?.port ?? 5678 }, (err, address) => {
  if (err) throw err;
  console.log(`Server is now listening on ${address}`);
});

[sidux]

Btw I understood the real cause, it works well with localhost using tsx server.ts but doesn't with bun, for some reason I had to use 127.0.0.1 instead for bun to work.

[benjie]

Please in future mention you’re using bun up front, this probably goes for filing an issue against any Node.js module that you’re having issues with under bun or any alternative runtime. Glad you figured it out.