# Recap: Building Glide apps on SQL data **URL:** \ **Category:** Community Resources\ **Tags:** sql, community-event\ **Created:** [November 2, 2023, 5:30pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484 "2023-11-02T17:30:41Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [November 2, 2023, 5:30pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/1 "2023-11-02T17:30:41Z")
This week’s Glide Next session covered the beta launch of our SQL data sources. I was joined by @Yasin_Hassanien, who shared great demos of PostgreSQL and Google Cloud SQL. - [Skim the recap blog post](https://www.glideapps.com/blog/glide-next-sql-data) - [Watch the replay on YouTube](https://www.youtube.com/watch?v=uygQwC72aN0) or view it below [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/97c5c75f264bb802d1cb4de7123726a458fc972d.jpeg "Building Glide apps on SQL data | Glide Next") ](https://www.youtube.com/watch?v=uygQwC72aN0) ## Documentation - [MySQL](https://www.glideapps.com/docs/essentials/data-sources/mysql) - [PostgreSQL](https://www.glideapps.com/docs/essentials/data-sources/postgresql) - [Google Cloud SQL](https://www.glideapps.com/docs/essentials/data-sources/google-cloud-sql) - [Microsoft SQL Server](https://www.glideapps.com/docs/essentials/data-sources/sql-server) ## Q&A **How does SQL data compare/ interact with the Glide data editor. Is it separate?** - SQL data appears in the Data editor like any other data table. **What SQL hosting provider do you recommend?** - There are lots of options. Cloud-hosted easiest to get started with, e.g. [Neon](https://neon.tech/), [Supabase](https://supabase.com/), [Google Cloud SQL](https://cloud.google.com/sql), or [Microsoft Azure](https://azure.microsoft.com/). **What are the settings for refresh rate of SQL database?** - Your database is queried when you view data in the builder, or when a user views the data in the app. You can force a refresh with a Reload Query action. **Any future possibility for reading local databases?** - Self-hosted servers should work as long as they’re properly configured and accessible on the internet. There are currently no plans to connect to servers on a local network. **Glide Tables versus SQL data sources: which should we use?** It depends on the solution you’re trying to build. Considerations: - Whether you already have SQL data in production. - What computation you need. Computations in Glide Tables happens client-side in your Glide app. Computations in SQL happens server-side. Server configuration, network speed, etc… will affect responsiveness of your SQL data. - SQL data sources are similar to Big Tables, e.g. you can’t build relations to computed columns, or rollups of computed columns. You can write custom SQL queries or run computations server-side to overcome those limitations. - You can combine SQL data sources and native Glide Tables in the same app. You can also have multiple SQL data sources connected. The right configuration for your app may be a mix of these. **Which plans are eligible for SQL?** - The SQL beta is available for teams on an Enterprise plan. If you’d like to try SQL and aren’t on an Enterprise plan, [get in touch with our team](https://www.glideapps.com/enterprise). _Have additional questions? Please drop them below!_ ---
**Author:** ![Connor\_Finlayson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/connor_finlayson/32/79079_2.png) [@Connor\_Finlayson](https://community.glideapps.com/u/Connor_Finlayson)\ **Post date:** [November 2, 2023, 5:42pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/2 "2023-11-02T17:42:52Z")
That custom query feature is very handy! Any chance we can implement similar for other data sources? ---
**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:** [November 3, 2023, 10:22am UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/3 "2023-11-03T10:22:52Z")
Like which source do you suggest having this ? ---
**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:** [November 4, 2023, 12:03am UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/4 "2023-11-04T00:03:01Z")
Here’s a summary using Claude: - Introductions and Agenda - Glide’s Product Roadmap - SQL Data Sources in Glide - Live Demo - Q&A ---
**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:** [November 4, 2023, 12:53am UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/5 "2023-11-04T00:53:28Z")
A couple of FAQs generated by Claude, can you help verifying this @NoCodeAndy . 1. What is Glide Next? Glide Next is a series where Glide shows what’s new and what’s coming to Glide. This is mentioned in the beginning when Andy says “welcome to Glide Next, where we’re show sharing what’s new and what’s coming to Glide”. 1. How do you connect Glide to a SQL database? You can set up a connection to your SQL server. Once connected, you can add SQL tables as data sources in Glide and write custom SQL queries to pull in read-only data. This is explained when Andy talks about how SQL data sources work. 1. What SQL databases can you connect to Glide? Currently Glide supports connecting to MySQL, Postgres, Microsoft SQL Server, and Google Cloud SQL. Andy lists these when talking about the SQL data sources now available. 1. Is the SQL data stored in Glide? No, the SQL data remains in your database. Glide runs queries against the database to load data into your app as needed. This is mentioned by Andy when explaining how SQL data sources work. 1. Can you write to SQL tables from Glide? Yes, SQL tables added as data sources can be read/write. You can add, edit and delete data in those tables from Glide. Yasin demonstrates this by adding data to a Postgres table. 1. How do you handle refreshing read-only SQL data? You can use the reload query action to refresh read-only SQL data for users. Yasin explains using this to refresh a read-only view table after editing data. 1. What are some limitations with SQL data sources? There is no real-time synchronization across users like with Glide tables. Also, you cannot currently add new columns through Glide, they must be added directly in the database. Yasin covers some limitations in his discussion. 1. When should you use SQL versus Glide tables? Use Glide tables for smaller datasets like dropdown options. Use SQL for large datasets you expect to grow significantly over time. Yasin provides examples of when to use each. 1. What tools help work with SQL databases? Tools like pgAdmin, Looker Studio, and ChatGPT can help with writing SQL queries, analyzing data, and more. Yasin demonstrates these tools. 1. What Glide plans currently support SQL? SQL data sources are currently in beta for enterprise plans. You can request access for other plans by contacting the Glide team. This is covered at the end when discussing availability. ---
**Author:** ![Monj](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monj/32/62349_2.png) [@Monj](https://community.glideapps.com/u/Monj)\ **Post date:** [November 5, 2023, 12:36am UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/6 "2023-11-05T00:36:53Z")
It really would be great to have access to SQL (MySQL and ProgresSQL) on the Business plan at least. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [November 6, 2023, 2:49pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/7 "2023-11-06T14:49:16Z")
Keep in mind we _just_ launched the beta. We built this data source with enterprise teams in mind, so we’re starting with there. 🙂 If you’re on a Business plan and want access to SQL data sources, [get in touch with the team](https://www.glideapps.com/enterprise) and we can discuss options. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [November 6, 2023, 2:49pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/8 "2023-11-06T14:49:37Z")
@ThinhDinh - Helpful! Thanks for compiling those. 🙏 ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [November 6, 2023, 3:07pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/9 "2023-11-06T15:07:59Z")
@ThinhDinh The summary and FAQ you generated with Claude are amazing. I noticed you have been mentioning Claude quite a bit. You’ve had better success with Claude than with MacWhisper, MacGPT and ChatGPT? I use ChatGPT daily, mostly text to text on OpenAI’s website directly, but have never used Claude before. Thanks for the inspiration. ---
**Author:** ![Monj](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monj/32/62349_2.png) [@Monj](https://community.glideapps.com/u/Monj)\ **Post date:** [November 6, 2023, 5:53pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/10 "2023-11-06T17:53:35Z")
@NoCodeAndy Are there any limitations with ProgresSQL tables such as computed columns. In other words, are there anything that Glide tables can do that ProgersSQL table will not be able to do? ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [November 6, 2023, 6:23pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/11 "2023-11-06T18:23:47Z")
@Monj - The big ones are limitations on computed columns. I.e. in Glide, you can’t build relations or rollups against computed columns on a SQL data table. The workaround @Yasin_Hassanien shared is to run more computations in SQL server-side, then work with the output of those calculations in Glide. Another way to think about it: - Glide Tables live in Glide. Computations run client-side in your Glide app on the user’s device. - SQL data sources live in your SQL server. Glide serves query responses through your app. Some computations are best handled server-side, while others can be handled client-side. Which approach is best? That depends on the type of data you’re working with; where it’s already stored; the volume of data; and the type of computations you need to run in your app. …hope that helps. 🙂 ---
**Author:** ![Monj](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monj/32/62349_2.png) [@Monj](https://community.glideapps.com/u/Monj)\ **Post date:** [November 6, 2023, 6:32pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/12 "2023-11-06T18:32:12Z")
@NoCodeAndy, Thanks for that. I believe the server side makes better sense. I have a business plan and would like to test it out. You did mention to contact support about looking into getting access to the beta, correct? ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [November 6, 2023, 7:51pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/13 "2023-11-06T19:51:44Z")
> [@Monj](#): > > You did mention to contact support about looking into getting access to the beta, correct? Correct. E.g. if you’re on a Business plan but would like access to the beta, you should still [get in touch with the sales team](https://glideapps.com/enterprise). We might be able to work something out. 👍 ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [November 6, 2023, 8:10pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/14 "2023-11-06T20:10:17Z")
I’ve added the session Q&A to the initial post. 👍 ---
**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:** [November 6, 2023, 11:03pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/15 "2023-11-06T23:03:51Z")
I usually use Claude to analyze long-form text. Before, MacWhisper is just for getting the transcription, and then I use Claude to process it. I wrote a new flow though, this should be much better, and faster. > **[Podcast Summarization - Flow](https://docs.google.com/document/d/1BcLIhWa9NKNmtKcqI8ag7bn1PurWw7vUA163FJsJFlI/edit)** > > This Doc is private @NoCodeAndy you might like this as well, if you listen to a lot of audio. DeepGram is amazing, and has an API if you want to build apps with it. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [November 10, 2023, 6:11pm UTC](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484/16 "2023-11-10T18:11:15Z")
> [@ThinhDinh](#): > > DeepGram is amazing, and has an API if you want to build apps with it. Speakin’ my language. Thanks!