Table of Contents
- What is a Database as a Service (DBaaS)
- Why I use multiple Database as a Service Providers
- Service Providers - Aiven
- Service Providers - Supabase
What is a Database as a Service (DBaaS)
Using a database as a service simplifies the development pipeline. Having a service provider handle this for you is a great way to save time and money.
Why I use multiple Database as a Service Providers
Splitting up the necessary transactions and data transfer costs helps keep costs low. I use Aiven for logs, analytics and backup storage. Supabase is used for user authentication and other player data. Both services are fully encrypted from my server to theirs, and all client data is routed through my server.
Service Providers
Aiven
The Aiven Free Tier runs on Digital Ocean. All data is fully encrypted from end-to-end, offering 5GB of storage for free.
Locations
The free tier on Digital Ocean is available in many cities such as Toronto, Canada. As well as New York and San Francisco, USA. Amsterdam, London, Frankfurt in Europe. Singapore and Bangalore, India or Sydney, Australia.
Free Tier
You can create one free PostgreSQL, one free MySQL, and one free Redis service with 5GB of storage.
Usage
5GB of database storage is useful for retaining log information and analytics data. Extra latency is not an issue for this type of data.
Having the option to setup a MySQL service in Asia or Australia is great for future expansion.
Supabase
Supabase uses a Postgres database that runs on Amazon Web Services. They are an open-source alternative to Google’s Firebase that is very developer-friendly.
Locations
Locations: North California; North Virginia; Central Canada; UK; Ireland; Germany; India; Japan; Korea; Australia; Brazil
Free Tier
Supabase offers a free tier that allows for 2 free projects, 500MB database and 1GB file storage, up to 5GB bandwidth, 50,000 monthly active users, and 1-day log retention.
A second service can be added for faster access in other regions, utilizing the same Postgres codebase.
Usage
I use Supabase for user authentication. Encrypted passwords are stored in the database, and all data is encrypted in transit. Removing sensitive data from my server and storing it in a secure location is a great way to protect user data.
