Integrate Postgres and OPENFORMAT to automate workflows with scalable backend

Connect Postgres and OPENFORMAT nodes to in your workflow. Integrate with any tool or database and ship powerful backend logic and APIs instantly - No code required!

getting started

How To Connect Postgres and OPENFORMAT

Supported Triggers & Actions

Postgres NODES

Delete Row

Deletes a row from a specified table in a Postgres database

Fetch Table Data

Fetch data from a Postgres DB

Fetch Table Schema

Fetch the schema of a specific table in a PostgreSQL database

Insert Data

Inserts data into a specified table in a Postgres database securely

Update Row Data

Updates a specific row in a Postgres database table securely

OPENFORMAT NODES

Check Missions

Checks whether the user has completed all of the actions that make up a mission, and whether they have already been rewarded for completing the mission. [Full Documentation Here](https://docs.openformat.tech/no-code/buildship/nodes/check-missions)

script

Create web3 Account

Creates a web3 account for your user. You can learn more about what this is and how it benefits your users here.

script

Get Leaderboard

Returns a leaderboard based on the amount of experience points (XP) users have earned.

script

Get User Information

Returns the user's experience point (XP) balance, the badges they have collected and the actions they have completed within that specific dApp.

script

Reward Badge

Reward a user with a badge for completing an action or mission. [Full documentation here](https://docs.openformat.tech/no-code/buildship/nodes/reward-badge)

script

Reward XP

Reward a user with experience points (XP) for completing an action.

script

blog posts & tutorials

Recommended Reads

Below are recommneded blogs that will help in your journey