ExploreTemplatesDocsPricingBlogCommunity
Sign in
Sign up

Fauna

The distributed serverless database combining the flexibility of NoSQL with the relational querying capabilities of SQL systems.

Explore
/
Apps
/
Fauna
/
PostgreSQL

Integrate the Fauna API with the PostgreSQL API

Setup the Fauna API trigger to run a workflow which integrates with the PostgreSQL API. Pipedream's integration platform allows you to integrate Fauna and PostgreSQL remarkably fast. Free for developers.

Popular Ways to Connect Fauna with PostgreSQL

Delete Row(s) with PostgreSQL API on New or Removed Documents in a Collection from Fauna API
Fauna + PostgreSQL
 
Try it
Execute Custom Query with PostgreSQL API on New or Removed Documents in a Collection from Fauna API
Fauna + PostgreSQL
 
Try it
Find Row With Custom Query with PostgreSQL API on New or Removed Documents in a Collection from Fauna API
Fauna + PostgreSQL
 
Try it
Find Row with PostgreSQL API on New or Removed Documents in a Collection from Fauna API
Fauna + PostgreSQL
 
Try it
Insert Row with PostgreSQL API on New or Removed Documents in a Collection from Fauna API
Fauna + PostgreSQL
 
Try it

Popular Fauna and PostgreSQL Triggers

New or Removed Documents in a Collection from the Fauna API

Emit new event each time you add or remove a document from a specific collection, with the details of the document.

 
Try it
New Column from the PostgreSQL API

Emit new event when a new column is added to a table. See the documentation

 
Try it
New or Updated Row from the PostgreSQL API

Emit new event when a row is added or modified. See the documentation

 
Try it
New Row from the PostgreSQL API

Emit new event when a new row is added to a table. See the documentation

 
Try it
New Row Custom Query from the PostgreSQL API

Emit new event when new rows are returned from a custom query that you provide. See the documentation

 
Try it

Popular Fauna and PostgreSQL Actions

Delete Row(s) with the PostgreSQL API

Deletes a row or rows from a table. See the documentation

 
Try it
Execute GraphQL Query with the Fauna API

Performs an arbitrary authorized GraphQL query. See docs here

 
Try it
Execute Custom Query with the PostgreSQL API

Executes a custom query you provide. See the documentation

 
Try it
Import GraphQL schema with the Fauna API

Import graphQL schema to a database. See docs here

 
Try it
Find Row with the PostgreSQL API

Finds a row in a table via a lookup column. See the documentation

 
Try it

Overview of Fauna

Fauna API offers a powerful serverless database solution for modern applications. Its unique capabilities allow for highly scalable, secure, and flexible data management. With Pipedream, you can harness the power of Fauna to create intricate serverless workflows that react to various triggers, manage data efficiently, and connect seamlessly with other services and APIs to automate complex tasks.

Connect Fauna

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
module.exports = defineComponent({
  props: {
    faunadb: {
      type: "app",
      app: "faunadb",
    }
  },
  async run({steps, $}) {
    const faunadb = require('faunadb')
    const q = faunadb.query
    
    const client = new faunadb.Client({ secret: this.faunadb.$auth.secret })
    
    // Lists collections in the database tied to your secret key
    const collectionsPaginator = await client.paginate(q.Collections())
    
    this.collections = []
    await collectionsPaginator.each(page => {
      for (const collection of page) {
        this.collections.push(collection.id)
      }
    })
  },
})

Overview of PostgreSQL

On Pipedream, you can leverage the PostgreSQL app to create workflows that automate database operations, synchronize data across platforms, and react to database events in real-time. Think handling new row entries, updating records from webhooks, or even compiling reports on a set schedule. Pipedream's serverless platform provides a powerful way to connect PostgreSQL with a variety of apps, enabling you to create tailored automation that fits your specific needs.

Connect PostgreSQL

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import postgresql from "@pipedream/postgresql"

export default defineComponent({
  props: {
    postgresql,
  },
  async run({ steps, $ }) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/postgresql

    const queryObj = {
      text: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    const { rows } = await this.postgresql.executeQuery(queryObj);
    return rows;
  },
})
Pipedream, Inc. — San Francisco, CA
AboutTwitterDocsCommunityTermsPrivacy