Hey everyone! I'm currently working on my Computer Science capstone project, where we're developing a chess app to compete with chess.com for both iOS and Android using React Native for the front end. I'm tasked with database design and management, and I'm weighing my options for the database architecture. Since I'm still pretty new to this area, I'm looking for some advice.
Right now, I'm considering AWS RDS and Supabase for managing my Postgres database. Are both of these good choices for our prototype? They won't handle much data at this stage, primarily serving a prototype. However, I'm leaning towards RDS to gain experience in cloud-based database management, APIs, network security, and other related fields. Would I gain more valuable skills working with AWS RDS compared to Supabase, and is knowledge of AWS beneficial in the job market? Thank you for your insights!
5 Answers
Postgres is generally a solid choice if you don't have special requirements, so go for it! It handles a wide variety of data operations pretty well, making it a good default system to work with.
If you want to dig deeper and truly understand database setup, consider running Postgres on an EC2 instance instead of RDS. RDS is easy to use, but managing your own database setup can be immensely valuable for your learning.
Great tip! Getting familiar with EC2 would definitely enhance your understanding of the entire setup process.
I think Postgres is an amazing choice! If you want flexibility, you can develop locally with Docker, and when you're ready, you can easily switch to RDS. Just make sure you're not exposing your database directly to the Internet when you go live!
Using RDS might be overkill for your prototype, but you will definitely learn a lot about AWS services. In the end, you'll find that networking and setup take most of your time, so be ready for that.
Both AWS RDS and Supabase are good options, but if budget is a concern, Supabase can make your life easier. It's simpler and doesn't have some of the complexities that can come with AWS. Plus, Postgres remains consistent across platforms!
Yeah, Postgres can do a lot of things pretty efficiently. If you're looking to become proficient with one tool, it's a great pick!