Supabase is an open source Firebase alternative.
Emit new event for every new row added in a table. See documentation here
Emit new event for every insert
, update
, or delete
operation in a table. This source requires user configuration using the Supabase website. More information in the README. Also see documentation here
Extract custom data from text using AI Textraction. See the documentation
Call a Postgres function in a database. See the docs here
Supabase is a real-time backend-as-a-service that provides developers with a suite of tools to quickly build and scale their applications. It offers database storage, authentication, instant APIs, and real-time subscriptions. With the Supabase API, you can perform CRUD operations on your database, manage users, and listen to database changes in real time. When integrated with Pipedream, you can automate workflows that react to these database events, synchronize data across multiple services, or streamline user management processes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
supabase: {
type: "app",
app: "supabase",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.supabase.$auth.subdomain}.supabase.co/rest/v1/`,
headers: {
Authorization: `Bearer ${this.supabase.$auth.service_key}`,
"apikey": `${this.supabase.$auth.service_key}`,
},
})
},
})
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
ai_textraction: {
type: "app",
app: "ai_textraction",
}
},
async run({steps, $}) {
const data = {"text":"John Doe is a software engineer with 5 years of experience. He specializes in web development and has expertise in multiple programming languages such as JavaScript, Python, and HTML. John has worked on various projects, including e-commerce websites and mobile applications. In his free time, John enjoys playing the guitar, hiking, and reading books.","entities":[{"var_name":"first_name","type":"string","description":"first name of the person"},{"var_name":"last_name","type":"string","description":"last name of the person"},{"var_name":"years_of_experience","type":"integer","description":"years of experience"},{"var_name":"programming_languages","type":"array[string]","description":"programming languages experienced with"},{"var_name":"hobbies","type":"array[string]","description":"hobbies"}]}
return await axios($, {
method: "post",
url: `https://ai-textraction.p.rapidapi.com/textraction`,
headers: {
"x-rapidapi-host": `ai-textraction.p.rapidapi.com`,
"x-rapidapi-key": `${this.ai_textraction.$auth.rapid_key}`,
},
data,
})
},
})