db diff doesn't detect changes to publication

[markszente]

Bug report

Describe the bug

db diff doesn't detect changes to publication

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Enable realtime for a table or create a publication with SQL
2. run db diff

Expected behavior

A new migration is created

Additional context

Probably related: https://github.com/supabase/cli/issues/805

[parkernilson]

What is the recommended way of enabling publications in my migration files, given that db diff does not work.

Can I just write the following in my migrations:

CREATE PUBLICATION mypublication FOR TABLE mytable;

[syntaxaire]

Still an issue as of supabase CLI 2.12.1

[keeandev]

Any updates on this? This would be really convenient to toggle a powersync publication in the dashboard only, instead of also having to modify the migration to add the publication for the table.

[keeandev]

Any updates on this?

@sweatybridge