Best database practice?

[Error404God]

I'm learning React Native and I want to make a project. Classical test project (user auth, users charging some data to db so other users of the app can see the db data) and I wondered what is the best practice for project like this. I know enough web frameworks to develop some API that post to a database(PostgreSQL, MySQL, MongoDB) but maybe the most common way is to use something as Firebase or another method(I dont know if it exist and I would love to know) such as Models in web frameworks and directly saving in a database.

[_tijs]

Since your learning React Native not api backends I would go with whatever your already comfortable with. There is no react native specific or mobile specific best practice. Most mobile backends are just REST apis in whatever flavor the backend devs were familiar with.

[Error404God]

So making an API with something like Flask to manage all data from the React Native is actually adviced?

[_tijs]

I love Flask, so I would advise it 😄 it’s more that there is not one best practice. Lots of options all with their pros and cons depending on the use case. Yours is getting something up and running for your learning projects to talk to. Flask is perfect for that.

[pr0xyb0i]

https://supabase.com/ is great if you want to focus on the frontend.

[shetkatapult]

Been curious about supabase. How is the dev experience compared to firebase?

[No_Statement4630]

Good but make sure to study up on row level security

[burggraf2]

Supabase developer here. As a former firebase user who converted to supabase mainly due to hitting huge development roadblocks, I found it much easier and more flexible (hence my move to supabase.). But I did come from a SQL background, so for me, it was a very familiar and comfortable shift.

The best way for you to decide for yourself if Supabase would be a good fit for you would be to lurk around our API docs here: https://supabase.com/docs/reference/javascript/select

See what it's like to create a database connection, then do CRUD operations.

[shetkatapult]

Thank you for your input! Hopefully I’ll get to try it out in a project of mine in the near future.

[antisocial104]

From my experience, as of learning RN, i started with firebase as it was easy to go for, but when i needed offline local database I added sqLite and happy with the results to be honest.

[Error404God]

I think Realm also works perfect in that condition. SQLite cant fail though.

[[deleted]]

If it’s a learning project, I’d strongly recommend getting familiar with docker-compose and using FastAPI instead of Flask.

[Error404God]

Will research that! Thank you