with Transloadit and PostgreSQL?
Emit new event when a Transloadit assembly finishes processing. See the documentation
Emit new event when a failed occurs during assembly processing. See the documentation
Emit new event when a new column is added to a table. See the documentation
Emit new event when a row is added or modified. See the documentation
Emit new event when a new row is added to a table. See the documentation
Cancel a running assembly by its assembly ID. Useful for aborting processing jobs that are no longer needed. See the documentation
Create a new assembly to process files using a specified template and steps. See the documentation
Retrieve the current status and results of an existing assembly. See the documentation
import Transloadit from 'transloadit';
export default defineComponent({
props: {
transloadit: {
type: "app",
app: "transloadit",
}
},
async run({ steps, $ }) {
const transloadit = new Transloadit({
authKey: this.transloadit.$auth.auth_key,
authSecret: this.transloadit.$auth.auth_secret
})
const options = {
params: {
steps: {
"encoded": {
"use": ":original",
"robot": "/video/encode",
"preset": "iphone-high"
},
"thumbed": {
"use": "encoded",
"robot": "/video/thumbs",
"count": 8
}
}
},
waitForCompletion: true,
}
return await transloadit.createAssembly(options);
},
})
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.
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
};
return await this.postgresql.executeQuery(queryObj);
},
})