An ORM simplifies working with Hydra. It turns tables into objects, queries into code. Less SQL, more logic. ORMs unlock efficient data modeling and transaction management. Hydra is Postgres so all existing ORM integrations with Postgres are compatible. In this guide we will focus on Drizzle ORM, but feel free to connect with your preferred ORM by navigating to their Postgres documentation.
This guide assumes familiarity with:
Drizzle has native support for PostgreSQL connections with the 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:
node-postgres
, you can install pg-native
to boost the speed of both node-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.If you need to provide your existing driver:
If you need to provide your existing driver:
We recommend
An ORM simplifies working with Hydra. It turns tables into objects, queries into code. Less SQL, more logic. ORMs unlock efficient data modeling and transaction management. Hydra is Postgres so all existing ORM integrations with Postgres are compatible. In this guide we will focus on Drizzle ORM, but feel free to connect with your preferred ORM by navigating to their Postgres documentation.
This guide assumes familiarity with:
Drizzle has native support for PostgreSQL connections with the 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:
node-postgres
, you can install pg-native
to boost the speed of both node-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.If you need to provide your existing driver:
If you need to provide your existing driver:
We recommend