Open-source relational database
Get a URL and emit the full HTTP event on every request (including headers and query parameters). You can also configure the HTTP response code, body, and more.
Get a URL and emit the HTTP body as an event on every request
Emit new event when you add or modify a new row in a table. See the docs here
Emit new event when the content of the URL changes.
MySQL is a powerful database management system used by some of the largest
organizations in the world, including Facebook, Google, and Amazon. MySQL is an
open-source relational database management system (RDBMS), as well as a popular
choice for web applications used by millions of websites.
Some applications that can be built using the MySQL API include:
module.exports = defineComponent({
props: {
mysql: {
type: "app",
app: "mysql",
}
},
async run({steps, $}) {
const mysql = require('mysql2/promise');
const { host, port, username, password, database } = this.mysql.$auth
const connection = await mysql.createConnection({
host,
port,
user: username,
password,
database,
});
const [rows, fields] = await connection.execute('SELECT NOW()');
console.log(rows)
},
})
// To use any npm package on Pipedream, just import it
import axios from "axios"
export default defineComponent({
async run({ steps, $ }) {
const { data } = await axios({
method: "GET",
url: "https://pokeapi.co/api/v2/pokemon/charizard",
})
return data.species
},
})