DT
Drizzle Team•5mo ago
ewert

Drizzle multi databse config (MySQL)

Hey! I need to use drizzle on a new product, which also access a legacy database. I would like to use Drizzle for multiple database connections (MySQL), along with drizzle kit. (like two database_url s) Is it possible? and if yes how? Also is it possible somehow to mix db engines? Like one config for MySQL and one for Postges? Both working with drizzle-kit?
2 Replies
ewert
ewert•5mo ago
Can someone help? 🫠
piechart
piechart•5mo ago
For drizzle-orm you'd have to instantiate two separate db objects and pass the correct db object as an argument to your functions if you want to reuse the same query logic. For drizzle-kit it should be possible too, with separate schemas and two separate config.ts files. You can specify the one to use with each command with --config
Want results from more Discord servers?
Add your server
More Posts
Add a Exclusion Constraint for PostgresI want to add an exclusion constraint to a table where I want to make sure there is only one row witCan I generate migrations folder at runtime?I'm using Electron to build my app, and I'd like to generate the migrations folder at runtime so thaHow can I extend drizzle tables?I noticed that I write a lot of boilerplate code. When I had to update one of such types, I refactorHow to convert sql.raw`` to camelCase?I have queries I need to run with sql.raw but I'd like the result to come out neatly just how it comdrizzle-kit push:pg and sql commandsI have a schema that I can easily push to my PostgreSQL database. But whenever I have something I waCircular Dependency HellIs it just me or does using the relations API result in a bunch of circular deps that aren't lazily