MySQL protocol proxy using MongoDB as backend. - Githubissues

open-source-ideas / ideas

💡 Looking for inspiration for your next open source project? Or perhaps you've got a brilliant idea you can't wait to share with others? Open Source Ideas is a community built specifically for this! 👋

6.56k stars 221 forks source link

MySQL protocol proxy using MongoDB as backend. #377

Open jclab-joseph opened 4 months ago

jclab-joseph commented 4 months ago

Project description

Create a proxy so that MySQL applications can run on the infrastructure that previously used MongoDB.

Relevant Technology

https://github.com/dolthub/go-mysql-server : MySQL protocol and SQL parser implementation.

https://github.com/FerretDB/FerretDB : A proxy acting as the opposite of this project. Controls Postgre backend with MongoDB protocol.

Complexity and required time

DDL/DCL queries need to be converted to mongodb commands appropriately. It's like, we need to create some kind of compiler.

Complexity

[ ] Beginner - This project requires no or little prior knowledge of the technolog(y|ies) specified to contribute to the project
[ ] Intermediate - The user should have some prior knowledge of the technolog(y|ies) to the point where they know how to use it, but not necessarily all the nooks and crannies of the technology
[X] Advanced - The project requires the user to have a good understanding of all components of the project to contribute

Required time (ETA)

[ ] Little work - A couple of days
[X] Medium work - A week or two
[ ] Much work - The project will take more than a couple of weeks and serious planning is required

Categories

[ ] Mobile app
[ ] IoT
[ ] Web app
[ ] Frontend/UI
[ ] AI/ML
[X] APIs/Backend
[ ] Voice Assistant
[ ] Developer Tooling
[ ] Extension/Plugin/Add-On
[ ] Design/UX
[ ] AR/VR
[ ] Bots
[ ] Security
[ ] Blockchain
[ ] Futuristic Tech/Something Unique

ats1999 commented 4 months ago

Spring Data does the same, you can easily change the database