What is the best way to connect to two databases to the same project?

I have a Typescript project that needs to connect to two different Xata databases. I used

xata init

xata init

xata init

xata init to initialise the project with one database and I was thinking it could be best to set up another XataClient with the other database URL, however this will mean the types will be out. Any help would be great!

kostas•2/12/24, 1:38 PM

That's right, the Xata SDK is generally designed to work with a single database per project, which is set in .xatarc. So

xata init

xata init

leaves you with one database connected to the current project folder that all CLI commands correspond to. You can run xata init in a different path to generate the client (src/xata.ts) and copy that file into your project with a different name (src/xata2.ts for example) to add another db connection and its types.

JFurnOP•2/12/24, 1:42 PM

Perfect thanks for the quick response!

kostas•2/12/24, 1:45 PM

Here is an example from a user's application utilizing multiple databases in the same project https://github.com/apprendamos/apprendamosdotcom/blob/main/xata/clients/index.ts

Kaligraphy•11/10/24, 5:19 PM

I have been looking for this

Kaligraphy•11/10/24, 5:19 PM

thanks

What is the best way to connect to two databases to the same project?

Similar Threads

Similar Threads

Similar Threads