We chose Firestore for Paragraph and I regret it. No native typescript support, lots of dumb limitations, poor web UX, and noSQL complicated a few things vs relying on relations. Would likely have gone with Planetscale/Supabase instead
Got it, thanks for sharing - have you explored migrating from Firestore to Supabase, or are you kicking that can down the road? https://supabase.com/docs/guides/resources/migrating-to-supabase/firestore-data
What are the considerations you had when picking firestore in the first place? have you considered supabase (the open source alternative) ?