I wanted to have a bug/feature request/roadmap tools in my latest project, Aurora, but I don't want users to sign in another tool just to do that.
Then I discovered the amazing Embedding features by Dashibase, which allow user to embed form and still respect the RLS. I reached out to SK (Thank you! ๐๐ผ) to learn the mechanism.
After that, I expose the NEW schema (so that it won't clogged up public schema), and utilized Supabase powerful Postgrest endpoint, as well as the embedding feature above to build this tool.
Enjoy! ๐
Login to your Supabase instance that you want to setup this tool.
Copy SQL script from sql/v1
, following the file number 1,2,3, and paste it into your Supabase SQL editor and RUN
it.
In 1.supabase_function.sql, you will need to add your admin users' uuid to make sure the admin have the capabiltites to handle admin stuff.
Go to Dashboard Settings โ API โ Settings โ Schema, and add the newly created supaembed schema into the Schema field.
Copy the script
below and paste in the HTML where you want it to be rendered.
It's ok to paste your url and keys here because it's gonna be public anyway ๐
<script src="https://cdn.jsdelivr.net/gh/zernonia/[email protected]/dist/embed.js" async defer></script>
<div id="supaembed" data-url="YOUR SUPABASE URL" data-anon-key="YOUR SUPABASE ANON KEY"></div>
Let me know if anything stuck!
Yarn
npm install --global yarn
git clone https://github.com/zernonia/supaembed.git
cd supaembed
yarn install
yarn dev
Contributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are greatly appreciated.
git checkout -b feature/AmazingFeature
)git commit -m 'Add some AmazingFeature'
)git push origin feature/AmazingFeature
)Thank you SK for discovering the possibilities of embedding tools that respect User's RLS and share it with me! Check out Dashibase!
Thank you Austin Malerba for Supabase Comment Extension that scaffold the comment for this project. Check out Scrollex
Not Associated with Supabase.
Distributed under the MIT License. See LICENSE
for more information.
Zernonia - @zernonia - [email protected]
Also, if you like my work, please buy me a coffee โ๐ณ