Drizzle ORM is a very popular TypeScript ORM that provides type safe access to your database, automated migrations, and a custom data model definition.
With the recent beta release of Xata’s Postgres service you are now able to connect to your Xata database with Drizzle over the Postgres wire protocol too with the drizzle-orm/node-postgres or drizzle-orm/postgres-js drivers.
Also, we are excited to announce that we have added support for the drizzle-orm/xata-http driver. This driver allows you to connect to your Xata database using the Xata HTTP API. This is a great option if you are using Drizzle in a serverless environment or if you are using a language that does not have a native Postgres driver.
Setting up with Xata
Before starting you will need an empty Xata database that has direct access to Postgres enabled.
Creating a new database
You will first need to enable direct access to Postgres in your workspace settings.
You will also need to enable direct access to Postgres when you create your new database.
After this point you will want to update your Xata SDK to the next release to ensure you have the latest beta features.
Setting up Drizzle
There are two ways to set up Drizzle: using the native Postgres adapters or the Xata HTTP adapter.
node-postgres
To use Drizzle with the node-postgres driver, you will need to install the drizzle-orm and pg packages.
After that, you can use Drizzle as you normally would, but with the node-postgres driver.
import { getXataClient } from ‘./xata‘; // Generated client
import { Client } from ‘pg‘;
const xata = getXataClient();
const client = new Client({ connectionString: xata.sql.connectionString });
const db = drizzle(client);
postgres-js
To use Drizzle with the postgres-js driver, you will need to install the drizzle-orm and postgres-js packages.
After that, you can use Drizzle as you normally would, but with the postgres-js driver.
import { getXataClient } from ‘./xata‘; // Generated client
import postgres from ‘postgres‘;
const xata = getXataClient();
const client = postgres(xata.sql.connectionString);
const db = drizzle(queryClient);
xata-http
To use Drizzle with the xata-http driver, you will need to install the drizzle-orm package.
After that, you can use Drizzle as you normally would, but with the xata-http driver.
import { getXataClient } from ‘./xata‘; // Generated client
const xata = getXataClient();
const db = drizzle(xata);
Get started
And that’s it, it’s that easy to connect Drizzle to your Xata database. This functionality is currently only available with the public beta of our Postgres service.
Sign up today to get started! We’re always around if you have any questions. Pop into Discord and say hi or reach out on X | Twitter. Happy building 🦋
