What does HackerNews think of postgres?

That said, it is true that the Node/JS world is primarily hype-driven by "thought leaders" and people seeking personal brand and clout. Go on JS/React Twitter and prepare to loudly groan at the self importance on display.

There are good packages out there that try to do things in a sane way without wasting your time. Postgres.js [1] is one of them.

[1] https://github.com/porsager/postgres

but personally i handwrite my queries with https://github.com/porsager/postgres for flexibility and performance

most orms use node-pg lib which has shit performance.

For instance - I would love to be able to use https://github.com/porsager/postgres with sqlite.

[1] https://github.com/porsager/postgres

Here's an example where it really shines:

  const users = [
    { name: 'Murray', age: 68 },
    { name: 'Walter', age: 80 },
  ];

  await sql`insert into users ${ sql(users) }`;

Also, node-postgres is ripe for sql injections because you just concatenate strings yourself when using it...

[0] https://github.com/porsager/postgres

[1] https://deno.land/manual/testing

You should take a look at Postgres.js [0] which supports Deno and TypeScript. Version 3.x was released recently and discussed in this HN thread [1].

The client is implemented in JavaScript. Queries can be written using JavaScript template literals.

[0] https://github.com/porsager/postgres [1] https://news.ycombinator.com/item?id=30794332