# Glide App + MySQL

**URL:** <https://community.glideapps.com/t/glide-app-mysql/36805>\
**Category:** Project Showcase\
**Created:** [January 7, 2022, 12:48pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805 "2022-01-07T12:48:17Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [January 7, 2022, 4:36pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/21 "2022-01-07T16:36:21Z")

</div>

JDBC in JS is not available actually… i tried experimental columns but they are slower than gscript webapps…  
Will try to set up a server and keep connection to MySQL live rather than connecting always…

---

<div class="post-metadata">

**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\
**Post date:** [January 7, 2022, 4:46pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/22 "2022-01-07T16:46:53Z")

</div>

Thanks for the explanation. Great job still on the proof of concept. Wishing you all the best in working further on it…  
Such endeavours help us “nocoders” to see what is possible with glide and just how far it can be pushed in terms of limits etc…

---

<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 7, 2022, 4:47pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/23 "2022-01-07T16:47:53Z")

</div>

> [@ShantanuIyengar](#):
>
> JDBC in JS is not available actually

Isn’t it available? Really? 🙃

I use a JDBC connection to retrieve data from a MS SQL Server database daily and works fine so far but it’s running from a GS script and now, reading your reply, I wonder why I haven’t tested my code by using an XC in GDE?? 🤒

Let me try it and let you know any good result.

Bye

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [January 7, 2022, 9:13pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/24 "2022-01-07T21:13:52Z")

</div>

Hi I tired and its laggy and slow unfortunately not reliable

---

<div class="post-metadata">

**Author:** ![Tuttografica](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tuttografica/32/16484_2.png) [@Tuttografica](https://community.glideapps.com/u/Tuttografica)\
**Post date:** [January 12, 2022, 12:06am UTC](https://community.glideapps.com/t/glide-app-mysql/36805/25 "2022-01-12T00:06:50Z")

</div>

Hello @ShantanuIyengar ,congratulate you.  
Add a title and within 5/6 seconds it updated.  
Currently I have an app connected to mysql but it reads the information once a day and writes me the mysql table every certain period.  
do you use an external connector?  
I use Scripts for both cases

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [January 12, 2022, 5:07pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/26 "2022-01-12T17:07:28Z")

</div>

Hello!  
Yes this uses gscript only but the information is fetched as soon as you search for something!  
The information is sent back quickly but it takes time to render it in the app!

---

<div class="post-metadata">

**Author:** ![Tuttografica](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tuttografica/32/16484_2.png) [@Tuttografica](https://community.glideapps.com/u/Tuttografica)\
**Post date:** [January 13, 2022, 10:43pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/27 "2022-01-13T22:43:13Z")

</div>

Great, very good.  
Greetings 👏 👏

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [January 17, 2022, 7:03pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/28 "2022-01-17T19:03:47Z")

</div>

I have a question @ShantanuIyengar about how you are resulting the array into an inline list ?

---

<div class="post-metadata">

**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\
**Post date:** [January 17, 2022, 8:27pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/29 "2022-01-17T20:27:15Z")

</div>

have you tried this in Glide pages? Since glide pages DO have pagination, maybe it works better?

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [January 18, 2022, 11:07am UTC](https://community.glideapps.com/t/glide-app-mysql/36805/30 "2022-01-18T11:07:36Z")

</div>

I am returning a limited set of 20 json objects in an array when searched! And then using jquery i transform the json entirely in the app

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [January 18, 2022, 11:08am UTC](https://community.glideapps.com/t/glide-app-mysql/36805/31 "2022-01-18T11:08:05Z")

</div>

Its not about rendering in pagination!  
Its about fetching so much data and then computing it in glide! Which is bit time consuming!

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [January 18, 2022, 11:36pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/32 "2022-01-18T23:36:42Z")

</div>

So you conncet them to a static emtpy rows ?

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [January 19, 2022, 7:28am UTC](https://community.glideapps.com/t/glide-app-mysql/36805/33 "2022-01-19T07:28:51Z")

</div>

Yup!  
I get the json file! Use a single value for static 20 rows and then I use jquery to sort the data and then render it!

---

<div class="post-metadata">

**Author:** ![Blue\_Community](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blue_community/32/16616_2.png) [@Blue\_Community](https://community.glideapps.com/u/Blue_Community)\
**Post date:** [March 7, 2022, 9:16pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/34 "2022-03-07T21:16:58Z")

</div>

this is pretty awesome… im kinda wondering how you got the search/add button combo… nice work!

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [March 16, 2022, 5:57am UTC](https://community.glideapps.com/t/glide-app-mysql/36805/35 "2022-03-16T05:57:47Z")

</div>

Hey @Blue_Community  
Its actually done using CSS!  
The buttons are reduced in size to fit 20% of the screen! There is no text just icon! and margin-top is set to negative 100px to make it come up! Then i put the three elements side by side by setting margin right as 60% and 80% respectively

---

<div class="post-metadata">

**Author:** ![scorpio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scorpio/32/38799_2.png) [@scorpio](https://community.glideapps.com/u/scorpio)\
**Post date:** [March 16, 2022, 11:36am UTC](https://community.glideapps.com/t/glide-app-mysql/36805/36 "2022-03-16T11:36:21Z")

</div>

> [@Wiz.Wazeer](#):
>
> Sholay

if you give it a search without putting a title, about 10 more or less come out but VERY VERY SLOW

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9c49048dd3be4ffcab9ff26c02623ce188798df2.png)

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [March 17, 2022, 5:33pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/37 "2022-03-17T17:33:01Z")

</div>

It was a proof of concept!  
Still working on a better solution

---

<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:** [May 13, 2022, 8:15pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/38 "2022-05-13T20:15:12Z")

</div>

I think this thread can be useful for @hani_ibrahim to understand some technical issues we have to overcome.

Saludos!

---

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 13, 2022, 8:44pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/39 "2022-05-13T20:44:30Z")

</div>

I was reading the entire topic, then suddenly i found my name 😂. Thank you for remembering me.

However, I think, we need to find a way to solve that issue by limiting the data itself using a way or another.

For example, we are now using “User Specific Column” to limit the data to be tailored to the current user. However, we may extend that to be not only the current user, but may be to the current project team members or by any condition might be adjusted by the app developer “Us”.

Once we fetch the require limited data, then Glide can start do the required computation.

I don’t know how to implement that or the border limits to be incorporated, but it is a way of loudly thinking with you all.

---

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 13, 2022, 8:47pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/40 "2022-05-13T20:47:03Z")

</div>

Opening such limit will allow me to run multi companies and multi modules under one umbrella for easy management and better linking the modules together.

Like inspection module, drawing module, inventory module and accounting module etc.

[Previous page](https://community.glideapps.com/t/glide-app-mysql/36805.md?page=1)

[Next page](https://community.glideapps.com/t/glide-app-mysql/36805.md?page=3)
