I need a database of around 20MB for my game. What I actually want is to be able to use GET and POST APIs from the game to fetch and modify data. After doing some research online, I saw that I might need a colocation or a VPS server, but I’m not exactly sure which one I should use. I’m not going to use Roblox’s DataStoreService for this.
There are some good options out there, but determining which one to use is based on what you’re aiming towards.
If you want to store data in a (free-at-first) no SQL database, you should try Firebase. If you use Firebase DB, I’d recommend having a backend server to sit in between your game and the database to handle requests more easily. Another no SQL database you could look at is MongoDB
If your data is structured, you can give a managed SQL database a shot. There are a ton of free-tier, managed databases you can look at: AWS, Fly, Microsoft Azure. As with the databases mentioned above, a proxy server to handle requests would be recommended.
If you are comfortable managing your database yourself, you can likely find a cheap VPS to host it on, but that is up to you and your experience!