Q: One database and several domains
My databases are SQL Server, SQLite, and MySQL, so I will have to do additional work to extract the data and store it in Supabase. That said, and aiming to add less work/complexity, can I consolidate my 5 databases into a single Supabase one and use a field (domain_id) to differentiate from which domain the emails should be sent in each campaign created? For example: the table will have 100 records, of which 20 records belong to my app/domain #1, 30 records belong to my app/domain #2, 40 records belong to my app/domain #3, and 10 records belong to my app/domain #4. Different campaigns, with different domains, using the same database. Otherwise, I would have to create 5 databases and the time/work I save using DREAMLIT, I will have to invest in the whole process of managing 5 databases. I acquired tier 3.