import { Client } from "pg";
export default defineComponent({
props: {
questdb: {
type: "app",
app: "questdb",
}
},
async run({ steps, $ }) {
const client = new Client({
host: this.questdb.$auth.host,
port: this.questdb.$auth.port,
user: this.questdb.$auth.user,
password: this.questdb.$auth.password,
database: this.questdb.$auth.database,
ssl: this.questdb.$auth.ssl
});
await client.connect();
const readAll = await client.query("SELECT version()");
await client.end();
return readAll.rows;
},
})
QuestDB uses API keys for authentication. When you connect your QuestDB account, Pipedream securely stores the keys so you can easily authenticate to QuestDB APIs in both code and no-code steps.