Managing Multiple Databases in a Project

[kennetpostigo]

I'm working with multiple postgres databases in one project both of which use sqlx. I have a few questions about managing configuration, macros, offline support when working with multiple databases with sqlx in a project.

Configuration:

1. I have the multiple database url variables inside of my .env file as app_database_url , chat_database_url, etc. I'm not sure how to specify the variable to sqlx-cli that should be used when commands are run, is there a way to specify the env_var sqlx-cli should use?

2. Is there a config that sqlx-cli reads from for it to understand what to use for each database as far as environment variables, migrations folders, and offline?

Macros

1. Ever since multiple databases have been a I get the following error at all macro usage sites for query! and query_as!:

failed to find data for query

Offline

1. Is there anything I need to be worried about with offline mode when the projects makes queries/mutations to and from different databases?

[esmevane]

Hey @kennetpostigo - did you make any headway with this design? I think I'm in a similar scenario, except with different adapters and I'm looking for leads on good workarounds or advice.