Join Slack
Powered by
what is the best way to sync postgres data into ty...
# community-help
c
capitalized time
11/24/2025, 11:34 PM
what is the best way to sync postgres data into typesense for doing migrations when adding new fields?
https://typesense.org/docs/guide/syncing-data-into-typesense.html#sync-changes-in-bulk-periodically
looking at the docs, it seems like ORM hooks, change listeners, or polling is create when records are deleted or added, but not sure the SOTA for migrations
f
Fanis Tharropoulos
11/25/2025, 8:49 AM
You could take a look into Sequin.
https://sequinstream.com/
It has a Typesense integration
c
capitalized time
11/25/2025, 7:57 PM
sweet, thank you
capitalized time
11/25/2025, 7:58 PM
is there different approaches between reindexing for documents that have been updated vs reindexing for a database migration?
f
Fanis Tharropoulos
11/26/2025, 10:36 AM
If a migration has deleted / changed a field's type or added new ones, you should either update the collecton's schema to match it, or use an Alias and create a new collection pointing to that alias:
https://typesense.org/docs/29.0/api/collection-alias.html#list-all-aliases
21
Views
Open in Slack
Previous
Next