4 ms·
This reminds me of a what I did for a friends app project to give them the tools they needed, allow them to iterate quickly, and minimize need for backend engi
by Legogris 6y ago
This reminds me of a what I did for a friends app project to give them the tools they needed, allow them to iterate quickly, and minimize need for backend engineer involvement (use-case: frontend smartphone app, data admin of hierarchical data by non-technical team members):
Using Firestore as main datastore, exposed to app by stupid Cloud Function. Backend admin is done through Google Spreadsheets, using a custom script that syncs each spreadsheet to an entity type. The only required/static fields are the "relational" columns that maps parents/childs. Apart from that they can add/remove/rename columns as they want, which maps to JSON fields in the API output. All values are JSON serialized.
With Airtable, the JSON can be abstracted away from the user.
After the initial setup, they have been working and iterating on it for months now and the frontend app can do all the changes they want in terms of data and all it takes is editing the spreadsheet.
This is obviously not suitable for when/if the product takes off and starts scaling, but for the hack it is I found it ideal at the exploratory stage. No need for any kind of CRUD app, teaching new tools, or involving backend/db admin for schema/API changes.