MySQL is an open-source relational database management system.
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.
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
};
return await this.mysql.executeQuery(queryObj);
},
});
Pocket's API on Pipedream allows for the automation of content curation workflows. Users can add, retrieve, and organize articles, videos, or other content they want to view later. By leveraging the API, you can create systems for tagging and sorting saved items, integrating them with other services for further processing or sharing. This could be useful for content creators, researchers, or anyone needing to manage a large influx of information efficiently.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
pocket: {
type: "app",
app: "pocket",
}
},
async run({steps, $}) {
const pocketReq = {
method: "post",
url: "/v3/get",
data: {
count: 10,
access_token: this.pocket.$auth.oauth_access_token,
},
}
// proxy pocket request
return await axios($, {
url: "https://enkogw2a5epb176.m.pipedream.net",
params: {
http_respond: 1,
},
data: pocketReq,
})
},
})