Stack Overflow
Stack Overflow

Questions tagged [multi-database]

120 questions
2
votes
1 answer

Symfony2: how to work with data from another db?

I have one master database that hosts all master and transaction details of my users. Now I would like to have 3 web-applications (symfony2) connected to this database, A B and C. All of them have a local database. A is for my users, B and C will…
xfscrypt
  • 16
  • 5
  • 28
  • 59
2
votes
2 answers

playframework2 how to open multi-datasource configuration with jpa

i want to configure multiple datasources in Play framework 2.1 with jpa. one is H2, and the other is Oracle. so i added the code like this in application.conf: db.default.driver=org.h2.Driver …
Sheldon Wei
  • 1,198
  • 16
  • 31
2
votes
1 answer

Update a colum with a Value that matches in two other tables

I have 3 Databases. One of them contains wrong data. The structure is like: DB_1: Tbl: ID - otherID - Guid DB_2: Tbl: ID - otherID - Guid DB_3: Tbl: ID - otherID DB_1 Containes the "otherID" that should stored in DB_3. The "Guid" of DB_1 and BD_2…
Wr4thon
  • 554
  • 1
  • 5
  • 11
2
votes
0 answers

Django database with router returns a count, but no records

I have a django-orm database populated with data collected in spreadsheets. I am trying to write a diff function to check the current state of the database against the contents of a spreadsheet. I load the data from the spreadsheet using a router to…
Michael Dunn
  • 8,163
  • 4
  • 37
  • 54
1
vote
0 answers

Multi DataSources: 1 RW + many RO

We have an app with single database 'dbMain', with set of read and write operations. Now we need to add using extra databases db1-db10 for read-only operations, for using in SomeServiceImpl. The problem is: I need to use several DAO (for dbMain and…
vlasov
  • 88
  • 1
  • 8
1
vote
1 answer

Integrating multiple system with graphql and postgres

Application is built using graphql (hasura), postgres and nodejs. The app gets deployed to each clients separately having different DB and so on. Currently, we need to make connection to different clients, so they can access each other DB. One…
phantom
  • 1,014
  • 1
  • 7
  • 15
1
vote
1 answer

Laravel custom middleware for 2 databases

I don’t know how to create middleware for two databases tokens. (First of all my english is not very well and I am beginner in laravel) I created a Laravel project that has two Eloquent Authenticatables that separate the database. I successfully…
Santi Phannolath
  • 13
  • 2
1
vote
0 answers

MariaDB10.4 - W10 machine, one slave + few regular standalone DBs - how to?

I'm running a simple home/small business php/db server with Windows 10 and xampp with MariaDB. I'd like to expand it to being it a DB slave for a "failover" PHP application hosted on another machine (if the main one fails, users can at least…
Crestwood
  • 11
  • 1
1
vote
2 answers

Django how to validate a form in CreateView when using foreignkeys and using multiple databases

Hello This is my first question so please forgive the formatting: Current lab setup 1 project: library 1 app catalog 2 databases library_admin_db (admin-mysql) catalog_db (mysql1 I'm trying to add a database object on "catalog_db" database…
bekevin
  • 13
  • 4
1
vote
1 answer

Working with multi-tenancy/multi db in laravel

I'm working for the first time on a multitenacy application with multidatabase for each tenant made with laravel using the Tenancy for Laravel Saas - Boilerplate . Being the first time for me working on such kind of application, I've read the whole…
Gianmarco
  • 69
  • 1
  • 9
1
vote
1 answer

Django database routers - how do you test them, especially for migrations?

I've read the documentation on database routers in Django 2.2. I more or less understand the concept - including keeping certain tables together - except that it seems somewhat tricky to do in practice. My instincts when things are complicated and…
JL Peyret
  • 10,917
  • 2
  • 54
  • 73
1
vote
0 answers

Unsupported driver []

I have Laravel project with multiple databases project is working fine on local serve but when I uploaded my project to server its showing unsupported driver [] error Laravel version 7.0 php version 7.4 after login I am trying to get data from third…
firm tech sol
  • 11
  • 3
1
vote
1 answer

Tenant Multi tenancy Laravel Unit Testing issue

Here is the test case that i created for category testing. I am getting 404 on this route while i have correctly configured the tenant test case and this route is exist on subdomain that was created on chrome browser. public function…
Ali Hyder
  • 41
  • 12
1
vote
1 answer

Dynamic USE statement

I am looking if anyone has any reason why the code below is a bad idea. This challenge deals with a challenge I have encountered in several different places and circumstances. How to run the same query against identical table structures in multiple…
Paul Wichtendahl
  • 117
  • 7
1
vote
1 answer

Inserting a record into a table's ManyToMany field while using multiple databases

My project uses Django's builtin multi-database support and I am trying to synchronize data in 2 different databases by taking a record from one database and inserting it into another one. I have tried to do this in the usual way using the add…
Rocckk
  • 406
  • 1
  • 5
  • 9
1
2
3 4 5 6 7 8