Making Hyperswitch Server support for mysql with diesel library

[subhash972001]

Discussed in https://github.com/juspay/hyperswitch/discussions/4179

^{Originally posted by manojradhakrishnan March 22, 2024}

Context

To keep things simpler, we initially chose PSQL for building Hyperswitch. However the vision was to keep Hyperswitch pluggable with any database technology.

Since we adopted Rust as the programming language, we chose diesel as our database communication library, due to its ORM nature.

Problem

With MySQL having greater than 40%+ market share in the Relational Database market, we would prefer to have Hyperswitch compatible with MySQL.

Diesel supports communication with PSQL, MySQL and SQLite - Hyperswitch is currently built to support only PSQL. The challenge is to extend the support to MySQL.

How to get started?

• Setup Hyperswitch by following these instructions on your local machine and make a test payment. This is also a prerequisite.
• Configure diesel with mysql and try running the application
• Discover the gaps that needs to be addressed in order to successfully run Hyperswitch with MySQL support

Expected Outcome

Share a proposal on how you can help us implement this in a clean manner. Create the proposal as Github issue and share under this discussion.

[varshith257]

@subhash972001 Whether it has to create my proposal as an issue here or in my repo

[ssarkar551]

Hey @subhash972001, doesn't #4191 discuss the same issue?