Back
Storing database/collection/document ids in different environments (dev and prod)
I'm kinda confused when it comes to the database querying in both Firebase and Supabase I use table/collection names but here with Appwrite I use IDs, should those ids be stored securely unlike names of tables/collections?
How to handle this when I have different environments (dev, stage, prod), I already have different projects for dev and prod. I can't imagine storing a lot of ids for each environment in .env file or something similar
TL;DR
Developers are unsure how to handle storing database IDs securely in different environments such as dev and prod. They are puzzled by the discrepancy between using table/collection names in Firebase and Supabase, and IDs in Appwrite. Storing numerous IDs for each environment in .env files seems impractical. 