search

juspay / hyperswitch

An open source payments switch written in Rust to make payments fast, reliable and affordable
https://hyperswitch.io/
Apache License 2.0
12.34k stars 1.34k forks source link

Making Hyperswitch Server support for mysql with diesel library #4185

Open subhash972001 opened 7 months ago

subhash972001 commented 7 months ago

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](http://diesel.rs/) 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](https://docs.hyperswitch.io/hyperswitch-open-source/local-setup) 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 commented 7 months ago

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

ssarkar551 commented 7 months ago

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