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?
[ Parent
| on HN ]
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