Question

Use one database for different apps

0

Hello, in our project we want to create a couple different apps for different users but they have to use one client base. Is there some trick to use one Mendix database for all my apps?

asked 2020-05-04

Kateryna Bondaren

3 answers

0

Thanks

answered 2020-05-05

Kateryna Bondaren

Mike Kumpf · Answer 1 · 2020-05-04

Kateryna,

There is not a way for Mendix apps to share databases as this would lead to database integrity issues. However, you can designate one of your apps as the system of record for customer information and then build Rest APIs to enable your other apps to interact with the system of record (i.e. create, read, update and delete customer info as needed).

Hope that helps,

Mike

Nirmalkumar · Answer 2 · 2020-05-05

Not if your applications are hosted in Mendix cloud, because Mendix does not allow. But may be you can try the same if applications are hosted in external cloud like AWS. I have been in a discussion with my cloud team recently about the same topic, where in-theory seems possible. Yet to try this ourselves.

But you must take care multiple things when you are doing this like: database tuple locking, transaction deadlocks etc which might be hard to manage this across multiple applications. If it is like 1 app writes and other apps reads, then should not be a big problem.

What Mike suggested is a good alternative if you want to read-write on same database from multiple apps.