PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
Assuming you want a few paragraphs on what you can do with the PostgreSQL API:
The following examples demonstrate some of the things that can be done with the
PostgreSQL API:
import pg from 'pg';
export default defineComponent({
props: {
postgresql: {
type: "app",
app: "postgresql",
}
},
async run({steps, $}) {
const { host, user, password, port, database, ca, cert, key } = this.postgresql.$auth;
const sslConfig = ca && cert && key ? {
ssl: {
rejectUnauthorized: true,
ca,
cert,
key,
},
} : {};
const clientConfig = {
host,
database,
user,
password,
port,
...sslConfig,
};
const client = new pg.Client(clientConfig);
await client.connect();
const results = (await client.query("SELECT NOW()")).rows;
await client.end();
return results;
},
});
The SWAPI (Star Wars API) provides a wealth of data about the Star Wars
universe to build applications. With the SWAPI, developers can access detailed
Star Wars related data about people, planets, films, species and much more.
From web and mobile applications to data analysis, the possibilities are
limitless.
Here are a few examples of what developers can build using the SWAPI:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
swapi: {
type: "app",
app: "swapi",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://swapi.dev/api/films/1/`,
})
},
})