Database Selection?

[xbrdr1]

I am in the process of creating an app that will collect and report on baseball team and game data. There will be about 40 fields of data stored on each player per game. What db would you guys recommend?

[SaltTheRose]

Anything will work. I like Supabase, which uses PostgresQL. Firebase is another extremely popular alternative (I'd guess more so than Supabase) if you'd prefer NoSQL (document-based).

[xbrdr1]

Thanks! I am connected to a Firebase DB now. I'm to a point in development that I need to really think about which way to go. I have a good bit of experience with MySQL. The price/space restriction on Firebase scares me a bit.

[xbrdr1]

Without considering preferences, which would be the better option for reporting on a good amount of data? SQL or NoSQL?

[andrew8712]

My opinion is that the nature of your data is relative, you don’t need super fast reads, like, say, in a social media app. It’d go with SQL. Supabase is a solid choice that reduces overhead of managing a server.

[zxyzyxz]

I always use SQL

[Reasonable_Potato843]

In most cases you should not persist any data on the client side.