I’m a bit confused by the new postgres sync. Is this a 2-way sync or one way? The video for the newest version of BaseRow makes it seem like the synch is 2-way, but then when setting up a synch, we get this notification in Baserow," Even though Baserow only selects data, we strongly recommend limiting the user to a read-only connection." So if Baserow only selects data, then I guess it’s not 2 way, as a read only connection can’t write back to the postgres database. If the synch is only 1 way, what’s the point of this feature exactly? Why would I edit information in Baserow and not have it update in postgres?
Hello @ddsgad, currently, this is a one-way sync process. Baserow fetches data from the data source and populates a Baserow table with it. You have the option to update the synchronization, which will update the table with the latest changes from the data source. The next step is adding a possibility to configure existing data sync.
Apologises for any confusion caused by the video.
The synced table’s structure seems to be read only in Baserow. So I can change the data but not the structure. This remains so even if I duplicate the table… the duplicate will still have a read only structure. How do I make the synced (imported) table’s structure editable? This is key to import databases into Baserow and then working with them, for example by making relations between the imported tables.
Hi @andrisi! Synced data is currently read-only, but you can link to this data from other tables and perform the manipulations you need. Here’s an example: https://youtu.be/s2zmRWklOkI?si=3N6l37Oi9Jmoh-yQ&t=103.
We plan to make the synced data editable in the future.