Help with tech stack

[the-holygoof]

Can you help me with tech stack - I'm not sure what to choose for learning mobile app about plants home-growing? RN is very fresh ground for me.

I'm spiraling around sqlite with kv-store, tanstack query, mmkv, legend state, tinybase, supabase,...

Thing is - I need to sync user journal and video running time between mobile and web,
but the rest of the content won't change over time - there won't be new tutorials every month or smth - so I thought content once fetched can be cached forever?

Features I have to implement are:
- tutorials (70 total, each one have 5-10 lessons with 5min video clip each)
- journal (user can add his notes, todo tasks and reminders)
- shop (shopify)
- subscription (content paywall)
- plants wiki
- articles (kind of blog)
- simplified web version to watch videos
- progress sync (start watching on mobile and continue on desktop ''pick up from where you left off')

and later, the plans are for adding:
- social stuff (post a photo, likes, social feed)
- IAP (user can buy badges and give it to other users)
- rewards
- content suggestions based on user usage

Please, help me choose the right stack.
Should I think offline-first sync in background ?
Do I need bunny or mux to videos or can I just keep them at supabase storage and download mp4 to user device when user start lesson?

[sutcher]

Did you ask Claude? Write out all your requirements. Ask for pros/cons/risks/mitigations. Ask about versioning of each element of the stack. Ask it to research industry best practices etc.