Questions tagged [multiple-databases]
631 questions
0
votes
1 answer
Multi app architecture and databases
I have just developped a Human Ressource WebApp in Laravel.
So in this app, I have my user database.
Now, I have 2 old apps, that I'm about to rewrite / Migrate to Laravel.
The first one is to manage employee payments.
The second app is for…

Juliatzin
- 18,455
- 40
- 166
- 325
0
votes
1 answer
Getting query results from 3 dbs when result only matches parameters of 1 db
Say I have 3 companies that all have customers. I want to write a code that searches all 3 companies for customers that have been terminated and laid off, then returns all the companies that that person is a customer with, regardless of that…

Scott Pelletier
- 1
- 3
0
votes
0 answers
cakephp3 multiple database connections with plugin not loading
I am trying to load some data from a plugin model which uses a different database. I have added an entry in my config/app.php as follows:
/**
* The test connection is used during the test suite.
*/
'alternate1' => [
…

user4838338
- 83
- 1
- 5
0
votes
0 answers
Is there a way to avoid default database setting in Django project?
According to Django we can keep default database as empty dictionary {} but when we run it , raises Improperly configured database settings.
I have used automated routers in my app files and registered them on settings.py . Django cannot avoid…

Avii
- 31
- 1
- 8
0
votes
0 answers
MariaDB databases in different directories
I have the following scenario:
On a Raspberry Pi (Raspbian Jessie) I run a python script receiving a huge number of individual data sets from a measuring device via UART. These data sets are "cached" in a mariaDB database (engine: MEMORY) and from…

Fantilein1990
- 155
- 1
- 6
0
votes
1 answer
SAS, SQL explicit passthrough, multiple Teradata databases
I have inherited a steep Teradata SQL query which runs on 3 Teradata databases.
Preferring not to get bogged down in the functional aspects of the query (with various windowing statements), I would like to pass the query explicitly through to…
0
votes
1 answer
Getting NoUniqueBeanDefinitionException when extends QueryDslRepositorySupport and multiple datasources
I need to use multiple databases.
I am using Spring Boot + Spring Data JPA,
so I have two configuration classes:
@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(basePackages="com.rest.dao.first",
entityManagerFactoryRef =…

OKIHOUSE
- 33
- 6
0
votes
1 answer
Different database for each user
We are building a web application using asp.net mvc and sql server 2012. The users of this application are sql developers, each of them have sql server installed in their local machines.
If user A opens the application, the data from User A's local…

Kalyan Chakravarthy S
- 716
- 2
- 7
- 20
0
votes
0 answers
Mongoose switching database according to userid
My system is designed so that every user has their own database with 3 collections inside.
I'm designing an admin system that need to connect to the user db when they log in - how do I design this using Mongoose?
I know that Mongoose has useDb that…

touchaponk
- 404
- 4
- 17
0
votes
1 answer
Logging into Multiple sites
I have two different websites written in Rails(W1) and PHP(W2) both
on different hosts. I used Authlogic for W1's authetication now I want to allow user
of W1 to login into W2 using same username and password (as of W2).
How can I do this?

Bhushan Lodha
- 6,824
- 7
- 62
- 100
0
votes
2 answers
Multiple datasources with Grails 3.1.5 and Postgresql
I am trying to connect to two postgresql databases from a single Grails 3.1.5 application, my application.yml looks like this:
hibernate:
cache:
queries: false
use_second_level_cache: true
use_query_cache: false
…

Eddard Stark
- 3,575
- 8
- 35
- 51
0
votes
2 answers
Database Error while updating the ci_session? I am using mulitiple Database?
Error Number: 1146
Table buz85ftp_buzoonga2.ci_sessions doesn't exist
UPDATE `ci_sessions` SET `last_activity` = 1468474888, `user_data` =…

Puneeth Kumar
- 182
- 2
- 14
0
votes
1 answer
Importing multiple .db files to sybase using SQL Anywhere 16 and merging Tables
I am kinda new to sybase/SQL programming, but I am having to work with 160 databases with .db files that are accessible through Sybase Central (64-bit). Each database has several tables related to different chemicals (160 different chemicals thus…

Ram Siwakoti
- 1
- 2
0
votes
1 answer
Mapping entities across 2 (or more) databases
Context
I'm developing a website where I have to use data from two distinct databases (one local with full access, one external on read only).
One of "local" entities needs mapping to an "external" entity.
The external entity won't have its data…

Michael De Keyser
- 787
- 1
- 17
- 45
0
votes
1 answer
Database documentation and reverse engineering
I know this question has been asked in various forms over and over again but I cannot find a single complete answer and I believe it is a general problem in the RDBMS/data area and industry. To explain the problem I will tell you a short (and maybe…

urban
- 5,392
- 3
- 19
- 45