3 ms·
drizzle-orm is another good JS sql query builder I'm able to write raw sql queries with the `sql` template literal function https://orm.drizzle.team/docs/sql
by trinovantes 3y ago
drizzle-orm is another good JS sql query builder
I'm able to write raw sql queries with the `sql` template literal function
https://orm.drizzle.team/docs/sql https://orm.drizzle.team/docs/sql
- catlover76 3y agoLooks cool, thanks for sharing
- droptablemain 3y ago+1 for Drizzle. I was really drawn to Prisma because it seemed elegant, but the problems surfaced by this blog post are really concerning.
- joshxyz 3y agothere's also https://kysely.dev/ https://kysely.dev/ but personally i handwrite my queries with https://github.com/porsager/postgres https://github.com/porsager/postgres for flexibility and performance most orms use node-pg lib which has shit performance.
- ShadowBanThis01 3y agoI'm hand-writing stuff right now for Deno with MariaDB. Is there a "default" or "native" Postgres client, and what makes Porsager better if so?
- joshxyz 3y agoThere's a core client interface here: - https://www.postgresql.org/docs/current/client-interfaces.html https://www.postgresql.org/docs/current/client-interfaces.ht... On what makes it postgres.js faster, from author himself: > it seems Postgres.js is actually faster than, not only pg, but of any driver out-there - https://github.com/porsager/postgres/discussions/627 https://github.com/porsager/postgres/discussions/627 - https://porsager.github.io/imdbench/sql.html https://porsager.github.io/imdbench/sql.html
- ShadowBanThis01 3y agoThanks for the reply!