Integrate the Fauna API with the MySQL API

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

Popular Ways to Connect Fauna with MySQL#

Create Row with MySQL API on New or Removed Documents in a Collection from Fauna API

Fauna + MySQL

Try it

Delete Row with MySQL API on New or Removed Documents in a Collection from Fauna API

Fauna + MySQL

Try it

Execute Query with MySQL API on New or Removed Documents in a Collection from Fauna API

Fauna + MySQL

Try it

Execute Raw Query with MySQL API on New or Removed Documents in a Collection from Fauna API

Fauna + MySQL

Try it

Execute Stored Procedure with MySQL API on New or Removed Documents in a Collection from Fauna API

Fauna + MySQL

Try it

Popular Fauna and MySQL 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 MySQL API

Emit new event when you add a new column to a table. See the docs here

Try it

New or Updated Row from the MySQL API

Emit new event when you add or modify a new row in a table. See the docs here

Try it

New Row from the MySQL API

Emit new event when you add a new row to a table. See the docs here

Try it

New Row (Custom Query) from the MySQL API

Emit new event when new rows are returned from a custom query. See the docs here

Try it

Popular Fauna and MySQL Actions#

Create Row with the MySQL API

Adds a new row. See the docs here

Try it

Execute GraphQL Query with the Fauna API

Performs an arbitrary authorized GraphQL query. See docs here

Try it

Delete Row with the MySQL API

Delete an existing row. See the docs here

Try it

Import GraphQL schema with the Fauna API

Import graphQL schema to a database. See docs here

Try it

Execute Query with the MySQL API

Find row(s) via a custom query. See the docs here

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#

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 MySQL#

The MySQL application on Pipedream enables direct interaction with your MySQL databases, allowing you to perform CRUD operations—create, read, update, delete—on your data with ease. You can leverage these capabilities to automate data synchronization, report generation, and event-based triggers that kick off workflows in other apps. With Pipedream's serverless platform, you can connect MySQL to hundreds of other services without managing infrastructure, crafting complex code, or handling authentication.

Connect MySQL#

import mysql from '@pipedream/mysql';

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

    const queryObj = {
      sql: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    const { rows } = await this.mysql.executeQuery(queryObj);
    return rows;
  },
});