I am developing an Ecommerce APP, which is my MVP, but I have 150 products with different variants that when multiplied add up to 5,200 rows.
At the moment the company does not have the capacity to acquire a superior plan.
What advice can you give me to manage the queues without exceeding the limit of the free plan while I validate the idea and the application begins to grow?
Hello, Juan Camilo, how are you? I think you are putting the variants wrong, a variant is a possibility of a user’s choice regarding your product. You can list in columns the choices that the user has regarding your product, which would not affect the number of rows. what do you use.
It is important that you develop your e-commerce so that it only affects one row at the time a customer places an order, as this could also affect the number of rows in your free application.
Create a table that we are going to call variants.
In this table create a column in which you are going to list the different types of variants of each product an example color and list blue, yellow, red.
Create within the product session a choice where you list the choices for that product. I attach an image of variants of a hamburger so you can understand it better
the pick is spanish sorry i speak spanish xD
Lo que haces es lo típico y normal en un sistema con base de datos formal para tener una arquitectura clara y evitar desperdiciar data (no tener muchos valores nulos) en una tabla pero estamos en Glide y aquí hay que ahorrar todo lo que se pueda y la recomendación de Dillan es válida para éste y otros casos.
Te sorprenderías de las cosas y trucos que hacemos para ahorrar filas y columnas en Glide!
Esos trucos son bien recibidos, ya que como estoy en proceso de validación de mi MVP, no justifica pagar algún plan aún.
Agradezco mucho la orientación, ya que como dije. Apenas estoy iniciando con mi aplicación. Y que suerte encontrar personas de habla hispana para que juntos podamos seguir aprendiendo.