Web hosting mysql database

Seeking Advice
1

I want to create a website that uses a relational database in the backend to showcase my resume. I previously hosted on Heroku, but since they discontinued their free tier, I’m not sure where to host it now. I am just looking to host a small database with around 500 entries that I can query from my front end, which I plan to host on Netlify.

Does anyone have recommendations for a suitable hosting solution? Any advice would be greatly appreciated.

2

That’s something I could accomplish. However, I still want anything on the internet. I get what you’re saying. I just want the real deal, and I’m going to get a domain and use it for something real soon.

3

I migrated my database to Amazon RDS, which provides a free tier with a small instance that could be a good fit for your needs. It integrates seamlessly with other AWS services and is a dependable choice for hosting a relational database.

4

Given the relatively small size of your database (500 entries), you have several cost-effective hosting options to consider.

Cloud-Based Database Solutions

  • Firebase:
    • Provides a real-time database ideal for your needs.
    • Seamlessly integrates with other Google services.
    • Offers a free tier suitable for small-scale applications.
  • AWS RDS:
    • More robust, which might be more than necessary for your current database size.
    • Supports multiple database engines (MySQL, PostgreSQL, etc.).
    • Provides scalability to accommodate future growth.
  • DigitalOcean or Vultr:
    • Offers virtual private servers (VPS) where you can set up databases like MySQL or PostgreSQL.
    • Provides greater control but requires more technical expertise.

Considerations

  • Scalability: Evaluate how your database might expand in the future. Cloud-based solutions typically offer easier scalability.
  • Cost: Review the pricing models for each option based on your anticipated usage.
  • Security: Ensure that the chosen solution has robust security measures to protect your data.
  • Ease of Use: If you’re not comfortable with server management, a managed database service might be a better choice.

Additional Tips

  • Data Backup: Regularly back up your database to avoid data loss.
  • Performance Optimization: Optimize your database queries for better performance.
  • Security: Implement appropriate security protocols to safeguard your data.