[Bug] Table not syncing and acting weird when working along with a friend

[JoacoG]

Bug Description

I exported a project from notion, we had there a table for organizing task, the default one given in Notion. We were working wonderfully until some weeks ago. We have reunions to talk about the project and write thing at the same time in the table, but since those weeks the table is not updating in real time the changes, and even is moving rows around and acting glitchy. My friend tried to install AppFlowy from scratch but the problem persists.

The table now acts glitchy even if we do no write things at the same time, but this is more rare.

How to Reproduce

Create an empty project in Notion, with a table for organizing tasks. Then export this project to AppFlowy and try to write thing at the same time with another person in the same table por some time. Try creating rows, renaming fields, deleting rows and so on.

Expected Behavior

I would expect the table to show the changes my friend does in real time, sometimes this is what really happens. At least I would want the app to not act glitchy.

Operating System

Windows 11

AppFlowy Version(s)

0.9.1

Screenshots

No response

Additional Context

No response

[khorshuheng]

There are a few known sync issue with database type:

1. New rows created on one table does not get reflected on another device until approximately a minute later. And even then, the user need to navigate away and come back to the table to see the new rows.
2. Changing group on Kanban does not result in immediate UI refresh on another device. This means, even though the underlying data for Kanban is already updated on another device, it doesn't get reflected until the user navigate away and come back.

Deleting rows should work fine, however. So is modifying column values. How big is the table?

[JoacoG]

Hello. Thank you for your quick response !

1. This is not our experience. In our workflow my friend write his tasks in the table/grid and I do mine. For example, my friend did not opened Flowy from a long time ago and then we had a reunion today and he couldn't see the tasks I wrote a week ago. It also happens that it is hard to create rows themselves, maybe this is due to the fact that we try to write things in the same row. It also happens to me that I try to write an entry in the grid but then the page of the row opens up without me triggering it and it is hard to create the row itself. The grid shows a very erratic behaviour in my opinion.
2. We are not really using kanban in a synced manner so that I have no feeback here.

The table has 120 rows (aproximately) and 8 columns (exactly)

[khorshuheng]

There has been quite a bit of changes on AppFlowy App itself that affect synchronization, so i would suggest upgrading the client versions to see if it helps. And does this happens only to one specific grid, or every grid?

[JoacoG]

But I already have the last version, 0.9,1. Or am I missing something? My friend should have the last version too.

About the last question, this is the only grid we use, so that, I don't know.

[ljcucc]

I have the same issue, if I create a new column at web ui, and fill it with values, the flutter version will showing blank, unless I reset the properties type.

for example:

1. create new column on webui
2. fill column with value on webui
3. view it on flutter app (which will be blank)
4. set property of the column to the same or something else on flutter app
5. reload the page on flutter app
6. the value could be view again on flutter app

this could be reproduce both on selfhost and official server.

could be reproduce on 0.9.4, 0.9.3