Camunda database without foreign keys

Camunda 7 Topics Discussion & Questions
1

Hi,

I am trying to use Camunda (Spring Boot embedded) with SingleStore distributed DBMS as the backend.

SingleStore uses the same SQL as mysql and applications can use mysql jdbc drivers when connecting to Singlestore.

However Singlestore doesn’t support foreign keys.

I have manually created all camunda tables and indexes( from identity and engine sql of mysql) in my singlestore db. However I have skipped the sql for foreign keys. My question is will Camunda work as expected without the foreign keys ?

2

Hi @AbdulAzeez,

Nobody knows until you try it. You can run the unit tests of the Camunda engine against your database: https://github.com/camunda/camunda-bpm-platform/blob/master/TESTING.md#what-about-database-technology-x-in-environment-y.

Hope this helps, Ingo

1 Like