# App Glide + Mysql 🔥
**URL:** https://community.glideapps.com/t/app-glide-mysql/18719
**Category:** Ask for Help
**Created:** [November 21, 2020, 2:20am UTC](https://community.glideapps.com/t/app-glide-mysql/18719 "2020-11-21T02:20:45Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Tuttografica](https://community.glideapps.com/u/Tuttografica)
#### Post date: [November 21, 2020, 2:20am UTC](https://community.glideapps.com/t/app-glide-mysql/18719/1 "2020-11-21T02:20:45Z")
Hello, I found the way to make a Glide application, totally with data obtained from a Mysql database.
I wanted to know if any of you are working on something similar to share experiences.
The use case is an application that sends orders by WhatsApp for a company that has a wholesale distribution of food, with 10 sellers and about 250 orders per day, we will have prices updated in real time. (Argentina, changes the prices of products almost weekly)
In a second stage we will visualize the current accounts, which are integrated into the app-
And the improvement in the future is to be able to work with the stock in real time.
It opens up a lot of opportunities to be able to work with most of the management systems and platforms.
Cheers, Dario
---
### Author:  [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)
#### Post date: [November 21, 2020, 3:13am UTC](https://community.glideapps.com/t/app-glide-mysql/18719/2 "2020-11-21T03:13:44Z")
I have worked on a warehouse management system for a company whose core ERP is SAP.
Their complete data lives on MySQL
I am pulling that data using a JDBC connection into a spreadsheet and then using a GlideApp for warehouse management.
---
### Author:  [@Carlos\_Venegas](https://community.glideapps.com/u/Carlos_Venegas)
#### Post date: [November 21, 2020, 5:21am UTC](https://community.glideapps.com/t/app-glide-mysql/18719/3 "2020-11-21T05:21:04Z")
That would be a great contribution … how do you connect to Mysql? Could you explain this a little more 🙂
---
### Author:  [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)
#### Post date: [November 21, 2020, 8:10am UTC](https://community.glideapps.com/t/app-glide-mysql/18719/4 "2020-11-21T08:10:47Z")
Check out this add on
[https://kpibees.com/integrations-google-sheets/mysql/#:~:text=Step%203%3A%20Access%20the%20add,your%20spreadsheet%20to%20pull%20data](https://kpibees.com/integrations-google-sheets/mysql/#:~:text=Step%203%3A%20Access%20the%20add,your%20spreadsheet%20to%20pull%20data).
---
### Author:  [@Tuttografica](https://community.glideapps.com/u/Tuttografica)
#### Post date: [November 21, 2020, 3:19pm UTC](https://community.glideapps.com/t/app-glide-mysql/18719/5 "2020-11-21T15:19:14Z")
Hi, good day. and how many times a day do you refresh the data?
Cheers
---
### Author:  [@Tuttografica](https://community.glideapps.com/u/Tuttografica)
#### Post date: [November 21, 2020, 3:22pm UTC](https://community.glideapps.com/t/app-glide-mysql/18719/6 "2020-11-21T15:22:27Z")
Hello @Carlos_Venegas , in this case I do it with this tool.
For another client I have to migrate to google scripts.
Cheers
> **[SeekWell](https://www.seekwell.io/)**
>
> SeekWell brings SQL to the places your team already hangs out, including Google Sheets, Excel, Slack, and email.
---
### Author:  [@leandro](https://community.glideapps.com/u/leandro)
#### Post date: [November 21, 2020, 4:37pm UTC](https://community.glideapps.com/t/app-glide-mysql/18719/7 "2020-11-21T16:37:30Z")
Muito interessante vou me aprofundar mais sobre este tĂłpico obrigado pela ideia!
---
### Author:  [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)
#### Post date: [November 25, 2020, 4:23am UTC](https://community.glideapps.com/t/app-glide-mysql/18719/8 "2020-11-25T04:23:37Z")
Once every hour because that’s good enough for our use case
---
### Author:  [@Tuttografica](https://community.glideapps.com/u/Tuttografica)
#### Post date: [November 26, 2020, 12:25am UTC](https://community.glideapps.com/t/app-glide-mysql/18719/9 "2020-11-26T00:25:50Z")
Thanks for your answer.
In my case it also serves me periodically.
In the future I have a case where we will carry the stock in real time, it is impossible for me to update with each modification, since there will be about 2500/3000 per day.
So I’m thinking of making a virtual stock in the app.
since it is the only means of sale, it will be reflected as they sell.
As I use a specific user column and it does not write to me in the Google sheets I am trying to do it in the data with the new functions.
I’m trying to do it right now 🥵 🥵
---
### Author:  [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)
#### Post date: [November 26, 2020, 5:28am UTC](https://community.glideapps.com/t/app-glide-mysql/18719/10 "2020-11-26T05:28:36Z")
Yeah I did have this requirement and hence I maintained a separate stock in my Google Sheet with some adjustments but if you find a better way, I would love to know it.
Copying user specific columns to Google sheets is now possible using the new compound actions. You can use the user profile sheet and “set columns” action in any click through your app which automatically transfers all user specific columns in your Google Sheet.
---
### Author:  [@Tuttografica](https://community.glideapps.com/u/Tuttografica)
#### Post date: [November 26, 2020, 6:14pm UTC](https://community.glideapps.com/t/app-glide-mysql/18719/11 "2020-11-26T18:14:44Z")
That’s my line of work, Yesterday work for a while but it wasn’t enough. I have to go on later. Best regards.
I’ll keep you posted.