Connecting ZingGrid to Supabase: Add a Backend in Minutes
Cross post from my article on the Zing blog.
Supabase is an open source Firebase alternative. There are a variety of services they offer, but for the purposes of this article, we'll be diving into how it can act as a simple backend for our grids.
Initial Setup
There are a few steps we need to run through on the Supabase side of things before we can start configuring our grids.
1. Account Creation
We first need to create the Supabase account that we will be connecting to. You can sign up for Supabase using this link. Once your account has been created and email confirmed, continue to the next step.
2. Create Your First Project
Go ahead and head over to the dashboard page and create a new project. Make sure to note down the project name and database password.
3. Note Down Project Info
It is at this point you should see your Project URL and your API Key. We will need to give both of these to ZingGrid in our code later so make sure to store them in a secure local file.
4. Create Your First Table
From the side bar click the Table Editor section. From here we can create our first table
First step is to give our table a name, here I'll use demoTable
Then we can edit the columns, I'll have two columns for this example. One for first names and one for last names.
5. Add Some Sample Data
6. Update Security Settings
We'll temporarily disable Row Level Security so we can easily read and write from our table for the purpose of this demo. In production we'll want to set up proper roles with authentication.
⚠️ NOTE: This settings change is just for the purpose of this demo, this is not meant for production
Supabase Adapter - REST API
ZingGrid supports both ways of interacting with Supabase - via the REST API and via the client script. We'll first go over using the REST API.
Using the initial demo code below, make sure to replace the following:
- ***link*** - The Project URL that you noted down earlier
- ***tableName*** - The name of the Supabase table you just created
- ***apiKey*** - The Supabase API Key you noted down earlier
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<script src="/lib/zinggrid.js"></script>
<title>Supabase</title>
</head>
<body>
<zing-grid
page-size="5"
sort
pager
title="Supabase"
editor-controls
editor-disabled-fields="id"
src="https://***link***.supabase.co/rest/v1/***tableName***"
>
<zg-data adapter="supabase">
<zg-param
name="headers"
value='
{
"Authorization": "Bearer ***apiKey***",
"apikey": "***apiKey***"
}'
></zg-param>
</zg-data>
</zing-grid>
</body>
</html>
When viewing that page in the browser, you should start to see the initial data we populated come through!
SupabaseJS Adapter - Client Script
If your app happens to use the Supabase JavaScript Client Library (which you can read more about on their docs site), you are able to store your Supabase credentials outside of your markup making it much more flexible.
Amending the previous example, we first create a Superbase client object (more on that in their docs)
const supabaseUrl = 'https://***link***.supabase.co/'; const supabaseKey = '***apiKey***'; const supabaseClient = supabase.createClient(supabaseUrl, supabaseKey);
and then register that client with ZingGrid
ZingGrid.registerClient(supabaseClient);
Finally we set the adapter attribute on zg-data to supabaseJS and we have the following
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Supabase</title>
<!-- ZingGrid -->
<script src="https://cdn.zinggrid.com/zinggrid.min.js"></script>
<!-- Supabase Client Library -->
<script src="https://cdn.jsdelivr.net/npm/@supabase/supabase-js@2"></script>
</head>
<body>
<script>
const supabaseUrl = 'https://***link***.supabase.co/';
const supabaseKey = '***apiKey***';
const supabaseClient = supabase.createClient(supabaseUrl, supabaseKey);
ZingGrid.registerClient(supabaseClient);
</script>
<zing-grid
page-size="5"
sort
pager
title="SupabaseJS"
editor-controls
editor-disabled-fields="id"
>
<zg-data adapter="supabaseJS">
<zg-param name="dataTable" value="***tableName***"></zg-param>
</zg-data>
</zing-grid>
</body>
</html>
Working the same as before
The above is the detailed content of Connecting ZingGrid to Supabase: Add a Backend in Minutes. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What should I do if I encounter garbled code printing for front-end thermal paper receipts?
Apr 04, 2025 pm 02:42 PM
Frequently Asked Questions and Solutions for Front-end Thermal Paper Ticket Printing In Front-end Development, Ticket Printing is a common requirement. However, many developers are implementing...
Demystifying JavaScript: What It Does and Why It Matters
Apr 09, 2025 am 12:07 AM
JavaScript is the cornerstone of modern web development, and its main functions include event-driven programming, dynamic content generation and asynchronous programming. 1) Event-driven programming allows web pages to change dynamically according to user operations. 2) Dynamic content generation allows page content to be adjusted according to conditions. 3) Asynchronous programming ensures that the user interface is not blocked. JavaScript is widely used in web interaction, single-page application and server-side development, greatly improving the flexibility of user experience and cross-platform development.
Who gets paid more Python or JavaScript?
Apr 04, 2025 am 12:09 AM
There is no absolute salary for Python and JavaScript developers, depending on skills and industry needs. 1. Python may be paid more in data science and machine learning. 2. JavaScript has great demand in front-end and full-stack development, and its salary is also considerable. 3. Influencing factors include experience, geographical location, company size and specific skills.
How to achieve parallax scrolling and element animation effects, like Shiseido's official website?
or:
How can we achieve the animation effect accompanied by page scrolling like Shiseido's official website?
Apr 04, 2025 pm 05:36 PM
Discussion on the realization of parallax scrolling and element animation effects in this article will explore how to achieve similar to Shiseido official website (https://www.shiseido.co.jp/sb/wonderland/)...
The Evolution of JavaScript: Current Trends and Future Prospects
Apr 10, 2025 am 09:33 AM
The latest trends in JavaScript include the rise of TypeScript, the popularity of modern frameworks and libraries, and the application of WebAssembly. Future prospects cover more powerful type systems, the development of server-side JavaScript, the expansion of artificial intelligence and machine learning, and the potential of IoT and edge computing.
Is JavaScript hard to learn?
Apr 03, 2025 am 12:20 AM
Learning JavaScript is not difficult, but it is challenging. 1) Understand basic concepts such as variables, data types, functions, etc. 2) Master asynchronous programming and implement it through event loops. 3) Use DOM operations and Promise to handle asynchronous requests. 4) Avoid common mistakes and use debugging techniques. 5) Optimize performance and follow best practices.
How to merge array elements with the same ID into one object using JavaScript?
Apr 04, 2025 pm 05:09 PM
How to merge array elements with the same ID into one object in JavaScript? When processing data, we often encounter the need to have the same ID...
How to implement panel drag and drop adjustment function similar to VSCode in front-end development?
Apr 04, 2025 pm 02:06 PM
Explore the implementation of panel drag and drop adjustment function similar to VSCode in the front-end. In front-end development, how to implement VSCode similar to VSCode...
