Research Database options

[kodebae]

Research task involving documenting possible Database options.

• What can we use as a database that can easily intergrade into the RoR app?
• Firebase
• Google Sheets API?
• MySQL Lite and localized history?
• Can we get a demo DB spun up with seed data to manually test the pros and cons?

[Arhaan-Siddiquee]

I suggest going with PostgreSQL for your Ruby on Rails app, and here’s why:

Seamless Rails integration: PostgreSQL works beautifully with Rails, so setup is straightforward, and you won’t hit any compatibility issues. Scalability: Whether you're starting small or planning for growth, PostgreSQL can handle it. It’s great for both small projects and larger apps down the road. Powerful features: It supports advanced features like complex queries and JSON, giving you flexibility if your data needs become more complex in the future. Data reliability: It’s designed to ensure your data stays consistent and safe, which is key when dealing with critical information. Great support: Since it’s popular and open-source, there’s a huge community, so finding help or resources when needed is easy.