# Glide App + MySQL **URL:** \ **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:** 1
**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, 12:48pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/1 "2022-01-07T12:48:17Z")
Hey Gliders! This is the first version of Glide Table + MySQL app with over 1,30,000 movies. I’ll be very happy if you guys test it out! I have created 1. Add Movie 2. Delete Movie 3. View Movie 4. Pagination Let me know your views and suggestions in the comments > **[Glide Table + MySQL](https://ms-mysqlconnect.glideapp.io/)** > > This a the beta version of the app with MySQL as backend with over 1,30,00+ data of movies.\\nSearch, Add and Delete functionality built.\\n\\nEdit is phase 2. This is just showcase! It may be a bit buggy! ---
**Author:** ![Aymeric\_de\_Maussion](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymeric_de_maussion/32/29505_2.png) [@Aymeric\_de\_Maussion](https://community.glideapps.com/u/Aymeric_de_Maussion)\ **Post date:** [January 7, 2022, 1:36pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/2 "2022-01-07T13:36:24Z")
My screen is empty ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7eaf47326c11da8a11bd43f33a29bb3786a01419.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 7, 2022, 1:37pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/3 "2022-01-07T13:37:33Z")
Same here. I can’t search. ---
**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, 1:41pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/4 "2022-01-07T13:41:13Z")
Ooh! Some glitch i guess… give me some time to fix it… ---
**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\ **Post date:** [January 7, 2022, 1:43pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/5 "2022-01-07T13:43:21Z")
Mine is empty too. And why you ask for unique ID in add movie? ---
**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, 1:58pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/6 "2022-01-07T13:58:54Z")
@Aymeric_de_Maussion @Jeff_Hager @Roldy You can try now! CSS was glitching it a bit! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 7, 2022, 2:16pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/7 "2022-01-07T14:16:10Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e0fdf8ccd29bdc58a1215c395322349ceda6ff02.png) I have tried searching but it’s been 3 minutes and I haven’t seen anything updated to the screen. ---
**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, 2:22pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/8 "2022-01-07T14:22:43Z")
I dont have Harry Potter 😂 Thank you for pointing this out… I should write in if no results are found ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [January 7, 2022, 2:24pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/9 "2022-01-07T14:24:02Z")
Was able to complete two searches after a bit of trouble (closing and opening app) When adding a new movie why not automatically generate a Unique ID instead of a text entry component? ---
**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, 2:25pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/10 "2022-01-07T14:25:55Z")
Yes… That is the plan! But currently it’s in very early stages… All counters then need to be local or synced or directly be auto generated by SQL… To make it easy! I have given out the entry field… I am sure phase 2 will be better once i fix all the loop holes and work on suggestions… Thank you for this suggestion… ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 7, 2022, 3:10pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/11 "2022-01-07T15:10:05Z")
Nice one! But my questions here is about the backend. How is this implemented? Is the same to handle the data? Curious to know more about it ---
**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, 3:12pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/12 "2022-01-07T15:12:57Z")
So basically a very fast api is written in back end which changes data in glide tables which then renders data in the app ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 7, 2022, 3:16pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/13 "2022-01-07T15:16:25Z")
So when you add or edit something, you’re doing it in mySQL but is rendered in glide tables? ---
**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, 3:17pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/14 "2022-01-07T15:17:46Z")
Yes sir!! ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [January 7, 2022, 3:34pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/15 "2022-01-07T15:34:36Z")
I typed in Sholay but database returned nothing. ---
**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, 3:37pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/16 "2022-01-07T15:37:54Z")
It’s possible sholay doesn’t exist… If you have added that movie, then it should come… ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [January 7, 2022, 3:54pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/17 "2022-01-07T15:54:53Z")
I get it. Thank you. ---
**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:01pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/18 "2022-01-07T16:01:18Z")
I just tried to search with an empty search and i had to wait for a few minutes before it returned nothing… Is it possible to restrict that it shows an error if the search bar is empty? Second question… The App seems to take long to return searches… My question would be, what would be the trade off between using glide tables as a database for a Pro App and then dealing with the lag that you normally get when you exceed the 25K row limit? I guess my question is in its current state (Your App) what advantages does it offer compared to using glide tables (For public Pro) and dealing with the slowness after hitting the 25K rows and beyond? This is not to take away from the great job you have done but just for information purposes or use case example. Thanks ---
**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:05pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/19 "2022-01-07T16:05:27Z")
This is more or less a proof of concept at this stage… I am sure Glide tables would be faster till 25000 rows… But as i mentioned! My database currently holds more than 130K+ records and still has viable functionality… True this is slow today a bit… And this currently is based on MySQL and Google scripts… If we go with a stand alone server with a database connection on always and cached. It may be a lot faster and alot of data can be handled simultaneously. UI currently requires a lot of upgrade too, such as informing of no rows or loading icon as such. This is phase 1 beta test and proof of concept… will be better with the next launch… ---
**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:34pm UTC](https://community.glideapps.com/t/glide-app-mysql/36805/20 "2022-01-07T16:34:18Z")
> [@ShantanuIyengar](#): > > And this currently is based on MySQL and Google scripts… Hola @ShantanuIyengar Good work although the delay problems were going to be obvious. If you can run a Query from Glide directly by using an Experimental Code column, the reply could be faster but I think it isn’t something native or easy to implement in JS, right? So, you can remove GS script from the middle of process and get faster replies. Nice work anyway, saludos! [Next page](https://community.glideapps.com/t/glide-app-mysql/36805.md?page=2)