/

Postgres

&

Typesense

Integrate Postgres and Typesense

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

Node stack

Supported Postgres and Typesense Nodes

Add any other tools or your preferred database nodes. If an integration is not available generate your own using AI

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

Add Document

Creates or uses an existing Typesense collection to insert a document, utilizing provided schema and authentication details. [TypeSense API](https://typesense.org/docs/latest/api/)

Add Documents

Creates or uses an existing Typesense collection to insert documents, utilizing provided schema and authentication details. [TypeSense API](https://typesense.org/docs/latest/api/)

Create Collection

Create a new Typesense collection with the specified schema

Delete Document

Delete a document from a Typesense collection.

Full Text Search

Performs a full text search on a specified collection in Typesense.

Geo Search

Performs a geo-location based search in Typesense using specified parameters.

Get Document

Retrieve a document from a Typesense collection using the given Document ID.

Update Document

Creates or uses an existing Typesense collection to update documents, utilizing provided schema and authentication details. [TypeSense API](https://typesense.org/docs/latest/api/)

Vector Search

Perform a vector search in a Typesense collection and return the results.

Quick start

How to integrate Postgres and Typesense

Step 1 — Add the nodes to your workflow

Create a new workflow in BuildShip, click “Add node”, and select the Postgres and Typesense actions you want to use.

Step 2 — Configure each node

Go to each node to authenticate (or add your API key) and fill in the required parameters.

Step 3 — Connect the nodes

Each node in BuildShip can connect to others by using their output variables. When you reference a variable from one node in another, BuildShip automatically links them in the workflow.

Step 4 — Test your workflow

Define your starting data in the Inputs node and choose what to do with the result in the Flow Output node. Finally, run a test to see your workflow in action.

blog posts & tutorials

Recommended Reads

Below are recommneded blogs that will help in your journey