Drizzle ORM
This guide assumes familiarity with:
- Database connection basics with Drizzle
- node-postgres basics
- postgres.js basics
node-postgres
and postgres.js
drivers.
There are a few differences between the node-postgres
and postgres.js
drivers that we discovered while using both and integrating them with the Drizzle ORM. For example:
- With
node-postgres
, you can installpg-native
to boost the speed of bothnode-postgres
and Drizzle by approximately 10%. node-postgres
supports providing type parsers on a per-query basis without globally patching things. For more details, see Types Docs.postgres.js
uses prepared statements by default, which you may need to opt out of.
node-postgres
Step 1 - Install packages
Step 2 - Initialize the driver and make a query
postgres.js
Step 1 - Install packages
Step 2 - Initialize the driver and make a query
What’s Next?
We recommend- following the migration documentation from Object Storage (S3, GCS), Amazon RDS, Heroku, Render, Postgres.
- learning about Hydra, our team and partners behind the project
- scanning the Hydra architecture