# Is Glide suited for developing open-ended data apps?

**URL:** https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631
**Category:** Ask for Help
**Created:** [January 3, 2022, 11:49am UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631 "2022-01-03T11:49:53Z")
**Posts on this page:** 1
**Showing post:** 7

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [January 3, 2022, 2:15pm UTC](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631/7 "2022-01-03T14:15:02Z")

</div>

I’d like to see it too 💪

The problem source is how Glide handles data, it’s not a classic Client–server model.  
Glide needs to use/read its internal databases (base on Firebase) and no matter what external “database” we try to use (GS, Excel, MySQL, etc), any updated or new row (or value) must be replicated to Glide database in order to be loaded and used on our APPs.

Our data can be saved on our MySQL server but the data on our devices come from Glide databases ruled by Firebase and it’s a bottleneck unfortunately, the synchronization between both sources consumes time and resources.

On small/mid-size APPs, load all data can be a good idea but on large ones the performance and manipulation problems appear as we know. Use **Pagination** to load data dynamically will be the missing piece that Glide needs to implement.

Meanwhile, use a workaround like bellow to get data frequently without loading it might be an option;

> [@A Google Sheet working as a REST API: good or bad idea? bomb](https://community.glideapps.com/t/a-google-sheet-working-as-a-rest-api-good-or-bad-idea/35668):
>
> Hola! It’s just a Proof of Concept which I wanted to do since a long time ago to know how reliable and fast a Google Sheet can handle a large amount of data and be used as an API to receive/send data frequently. As you should know, GS is not a native database therefore, some key functionalities (like an indexed file) don’t exist and can’t be used to improve the lookup speed. GS has the Filter() and Query() as tools to search data but it isn’t enough to make a lookup fast or optimal, both of th…

Saludos

---

_[View the full topic](https://community.glideapps.com/t/is-glide-suited-for-developing-open-ended-data-apps/36631)._
