MySQL is an open-source relational database management system.
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:
import mysql from 'mysql2/promise';
export default defineComponent({
props: {
mysql: {
type: "app",
app: "mysql",
}
},
async run({steps, $}) {
const { host, port, username, password, database, ca, cert, key } = this.mysql.$auth;
const sslConfig = ca && cert && key ? {
ssl: {
rejectUnauthorized: true,
ca,
cert,
key,
},
} : {};
const connectionConfig = {
host,
port,
user: username,
password,
database,
...sslConfig,
};
const connection = await mysql.createConnection(connectionConfig);
const [rows] = await connection.execute('SELECT NOW()');
return rows;
},
});
With the Trello API, you can:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
trello: {
type: "app",
app: "trello",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.trello.com/1/members/me`,
}, {
token: {
key: this.trello.$auth.oauth_access_token,
secret: this.trello.$auth.oauth_refresh_token,
},
oauthSignerUri: this.trello.$auth.oauth_signer_uri,
})
},
})