Remote Objects: master issue

[FelixMalfait]

This is the master issue to group all issues related to remote objects

Stripe integration

Preview Give feedback

1. [Remotes] Create stripe connection #5119
   scope: backend +1
   
2. [Remotes] Add stripe integration option #5060
   scope: front +1
   
3. [Remotes] Fetch stripe tables #5120
   scope: backend +1
   
4. [Remotes] Sync and unsync stripe tables #5121
   scope: backend type: chore +2
   
5. [Remotes] Add connection label in form #5599
   type: chore +1
   
6. [Remotes] Add missing stripe tables and fields #5600
   type: chore +1
   
7. Check why the limit is 100

Relations

Preview Give feedback

1. Fix relation search on tasks #5366
   type: chore +1
   

Connection update

Preview Give feedback

1. [Remotes] Add endpoint to update server connection #4765
   scope: backend +1
   
2. [Remotes] Edit a connection #4774
   scope: front +1
   
3. [Timebox] Investigate FDW failed states #5083
   +0
   
4. [Remotes][BE] Remote table structure out of sync #4532
   scope: backend +1
   
5. [Remotes][FE] Warn user out of sync table #5062
   scope: front +1
   
6. [Remotes] Update foreign table with new schema #5069
   scope: front +1
   
7. Investigate bug coco: somethings / something
8. Migrate fields metadata when remote table schema is updated #5610
   type: chore +1
   
9. Handle distant table column data type change #5611
   type: chore +1
   
10. Allow schema update in remote server edition #5612
    type: chore +1
    

Misc V1

Preview Give feedback

1. [Remotes] Allow sync when name already exists #5058
   scope: back+front type: chore +2
   
2. Fix toggle button issues #5363
   +0
   
3. [Remotes] Sorting does not work #5362
   type: chore +1
   
4. Check the order of syncable tables remains the same
5. Issue with table names containing digits (marie)
6. Handle remote table connexion issues #5126
   scope: back+front type: chore +2
   
7. Check what happens if a distant table is deleted #5364
   type: chore +1
   
8. [Remotes][Bug] Fix refresh issue after creating/deleting connection #5057
   scope: front +1
   
9. Hide logs for Remote objects
10. [Timebox] Test in prod

Non-blocking

Preview Give feedback

1. [Remotes] Update Workspace health to flag not up to date remote objects #4535
   scope: backend type: chore +2
   
2. I should be able to delete a remote object #5408
   +0
   
3. Update user guide
4. Block creation of a second connection to the same db (marie)
5. Info banner dark mode version

Legacy

Backend Tasks

Preview Give feedback

1. Delete DataSource object #3741
   scope: backend type: chore +2
   
2. Create remoteServer object within metadata schema #3742
   scope: backend +1
3. Create remoteServer API #3922
   scope: backend +1
4. Create query to list available tables in a remote server #3923
   scope: backend +1
5. Create Mutation to import a foreign table #3924
   scope: backend +1

Fronted Tasks

Preview Give feedback

1. Display remote objects as read-only on UI #3926
   scope: back+front +1
2. 🔌 [Master] Remote Objects - Settings/Integrations #4539
   2 of 2
   scope: front type: feature +2
   
3. 🔌 [Master - frontend] Remote Objects - Settings/Integrations/Database #4543
   3 of 3
   scope: front type: feature +2
   
4. 🔌 [Master] Remote Objects - Settings/Integrations/Database/New Connection #4544
   3 of 3
   scope: front type: feature +2
   
5. 🔌 [Master] Remote Objects - Settings/Integrations/Database/Connection #4552
   5 of 6
   scope: front type: feature +2
   

Temporary notes

Specific config per wrapper?
E.g. for postgres_fdw:

• Let's set updatable = false for every server for v1

• keep_connections by default set to true - let's leave it like that for v2but we'll probably need to followup later as this might cause scaling issues.

• createdAt/updatedAt position (defaultSort?)

• relationship with attachments, favorites, activityTarget...

Tasks

Preview Give feedback

No tasks being tracked yet.