what is the best way to sync postgres data into ty...
# community-help
c
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
You could take a look into Sequin. https://sequinstream.com/ It has a Typesense integration
c
sweet, thank you
is there different approaches between reindexing for documents that have been updated vs reindexing for a database migration?
f
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