long2ice / meilisync

Realtime sync data from MySQL/PostgreSQL/MongoDB to Meilisearch
https://github.com/long2ice/meilisync
Apache License 2.0
247 stars 37 forks source link

Related Field Referencing in Meilisync? #21

Open zebra-f opened 11 months ago

zebra-f commented 11 months ago

I couldn't find anything in the documentation mentioning this feature, but it would be nice if meilisync could reference related fields (foreign keys in MySQL and PostgreSQL)

Here's an example of how it could work:

    fields:
      id:
      title:
      user__username: username

or

    fields:
      id:
      title:
      user: 
        username:

Edit: Now that I think about it; the tricky part would be dealing with updates to related fields.

long2ice commented 11 months ago

Yes, maybe you can use plugins docs in https://github.com/long2ice/meilisync#plugins-optional

ishaqkhattana commented 5 months ago

Hey @zebra-f Did you figure it out?

@long2ice After reading the documentation, I'm still not able to figure out how to structure my meilisync project to get my plugins to work