with Neon Postgres and Firebase Admin?
Emit new event when a new child object is discovered within a specific path
Emit new event when a new column is added to a table. See the documentation
Emit new event when a structured query returns new documents
Emit new event when a row is added or modified. See the documentation
Emit new event when a new row is added to a table. See the documentation
Creates or replaces a child object within your Firebase Realtime Database. See the docs here
Finds a row in a table via a lookup column. See the documentation
import { axios } from "@pipedream/platform";
import { neon } from "@neondatabase/serverless";
export default defineComponent({
props: {
neon_postgres: {
type: "app",
app: "neon_postgres",
}
},
async run({ steps, $ }) {
const { host, port, user, password, database } = this.neon_postgres.$auth
const connectionString = `postgresql://${user}:${password}@${host}:${port}/${database}`
const sql = neon(connectionString)
const result = await sql`SELECT version()`
const { version } = result[0]
return version
},
})
The Firebase Admin SDK API provides powerful backend functionality for Firebase apps. It allows you to interact with Firebase services like Firestore, Firebase Realtime Database, Firebase Storage, and Firebase Authentication directly from a server. With Pipedream, you can harness this API to automate complex workflows, respond to Firebase events in real-time, and integrate with countless other services.
import admin from "firebase-admin"
export default defineComponent({
props: {
firebase_admin_sdk: {
type: "app",
app: "firebase_admin_sdk",
},
},
async run({ steps, $ }) {
// Enter values for the following parameters below this code step,
// These get passed to the initializeApp method below.
const {
projectId,
clientEmail,
privateKey,
region = "firebaseio.com",
} = this.firebase_admin_sdk.$auth
// Before passing the privateKey to the initializeApp constructor,
// we have to replace newline characters with literal newlines
const formattedPrivateKey = privateKey.replace(/\\n/g, "\n")
// See https://firebase.google.com/docs/reference/admin/node/admin.credential.html#cert
if (!admin.apps.length) {
admin.initializeApp({
credential: admin.credential.cert({
projectId,
clientEmail,
privateKey: formattedPrivateKey,
}),
databaseURL: `https://${projectId}-default-rtdb.${region}/`,
})
}
},
})