News for hackers. Stuff that matters.
Re:PostgresJs: The Fastest full featured PostgreSQL client f... by Exuma on Saturday October 14, 2023 @08:28AM (#37879952)
What do you mean multiple schemas ? What is an example of a non readable type?
Re:PostgresJs: The Fastest full featured PostgreSQL client f... by pimeys on Saturday October 14, 2023 @08:54AM (#37880108)
Like this, it's pretty common way to use Postgres (with multiple schemas):

  CREATE SCHEMA a;

  CREATE SCHEMA b;

  CREATE TABLE a.foo (id SERIAL PRIMARY KEY);

  CREATE TABLE b.foo (id SERIAL PRIMARY KEY);
Re:PostgresJs: The Fastest full featured PostgreSQL client f... by xctr94 on Saturday October 14, 2023 @02:17PM (#37882847)
I didn’t know support for schemas had landed, but the docs still seem obtuse for joins and upserts. Compared to plain SQL files in PgTyped — which admittedly needs some annotations to work, and lacks transactions —, I find the lateral joins in Zapatos really verbose and ugly. Lots of extra parameters too.

Which isn’t to say it’s not a great tool! You pick what you like :)

Re:PostgresJs: The Fastest full featured PostgreSQL client f... by alde on Saturday October 14, 2023 @08:06PM (#37885491)
Glad you are liking pgTyped. Transactions are supported as pgTyped is just a thin wrapper around node-postgres: https://github.com/adelsz/pgtyped/discussions/448
Re:PostgresJs: The Fastest full featured PostgreSQL client f... by xctr94 on Thursday October 19, 2023 @02:48AM (#37939380)
Ah, I meant having a single transaction in a SQL file, as that’s how we’re using it. So having multiple queries with a BEGIN and COMMIT wrapping them.