#community-help

Syncing PostgreSQL with Typesense using Debezium or Airbyte

TLDR Thomas asked for advice on syncing PostgreSQL with Typesense using Debezium or Airbyte. Jason suggested looking into Airbyte, but the issue remained unresolved as Thomas experienced issues with integer data types.

6mo

Join the chat

Feb 08, 2023 (8 months ago)

Photo of md5-a02d7b53d77592ed454fb8007647b04f

Thomas

08:29 AM

#ASK anyone....,

Does Anyone have sync postgresql with typesense? for CDC (change data capture) ?

I used to debezium or perhaps i see airbyte from typesense official website but somehow it looks on alfa release and not ready for production/cloud.

Is there someone can share the approach for this? Advice? :bow::skin-tone-2:

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

05:22 PM

Here’s an article on this topic: https://typesense.org/docs/guide/syncing-data-into-typesense.html

I’d recommend looking into Airbyte

Mar 29, 2023 (6 months ago)

Thomas

08:08 AM

actually i have created the other sync and running well, but somehow its not applied with table including integer as datatype on postgresql.

somehow the status on airbyte always successful with no errors, but somehow on typesense cloud no document created.

Image 1 for actually i have created the other sync and running well, but somehow its not applied with table including integer as datatype on postgresql.

somehow the status on airbyte always successful with no errors, but somehow on typesense cloud no document created.

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 2776 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

Integer Datatype Issue in Airbyte PostgreSQL to Typesense Connection

Thomas experienced issues with integer datatype while creating connections in Airbyte. Jason requested log details.

6mo

Issue with Syncing Typesense with Airbyte.

Christoph is facing issues while syncing Typesense with airbyte. Jason recommended checking the error logs for a possible cause.

8mo

Airbyte Connector for Typesense Integration and Issue Resolution

Cirdes shares the creation of an Airbyte connector for Typesense, later experiencing timeout issues with large-scale data synchronization. Jason provides solutions for adjustment of timeout thresholds and batch sizes, successfully resolving the issue.

11mo