MuffinFlavored on Show HN: Pg-typesafe – Strongly typed queries for PostgreSQL and TypeScript

any reason why you did

    const { rows } = client.query(
      "select id, name, last_modified from tbl where id = $1",
      [42],
    );

instead of

    const { rows } = client.query(
      "select id, name, last_modified from tbl where id = :id",
      { id: 42 },
    );

That is the way node-postgres works. pg-typesafe adds type safety but doesn’t change the node-postgres methods

Comments