[Edmond]

You might be interested in our "Preemptive Schema Data Modeling" technology (http://crudzilla.com/doc/eu-doc/#data-modeling )

It basically allows you to do what you are doing without having to manage tables by adding and removing columns.

The idea is simple, preemptively create a table with a certain distribution of column types and then allow the developer to define models in their app and map properties of their model to available columns.

It is a pretty robust idea and works well, we use it in our product.

I'll be doing a thorough write up on it sometime in the near future.

[jenkinsj]

Thanks Edmond! We used Firebase's validation rules to create a basic schema but something more robust might be called for in the future.

[Edmond]

no problem, feel free to get in touch if you need assistance trying it out.