#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.

Powered by Struct AI

1

Feb 08, 2023 (8 months ago)
Thomas
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:
Jason
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

1

Mar 29, 2023 (6 months ago)
Thomas
Photo of md5-a02d7b53d77592ed454fb8007647b04f
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.