remove duplicates feature

[romainds-tech]

I have a table with a lot of entries (+440,000).

However, I have a lot of duplicates (a duplicate can be defined when the same column in 2 rows is identical). And I can't see how I can simply delete them from the interface? Here's an example of the SQL query I had to make when connecting to the database (in the docker container). :

WITH duplicates AS (
  SELECT 
    ctid,
    ROW_NUMBER() OVER (
      PARTITION BY “column_name”
      ORDER BY ctid
    ) AS rn
  FROM “schema_name”. “table_name”
)
DELETE FROM “schema_name”. “table_name”
WHERE ctid IN (
  SELECT ctid
  FROM duplicates
  WHERE rn > 1
);

---

If this feature is added at the interface level when you're on a grid, there could be a sort of 'delete duplicates' button with a column to be defined. I don't know if the scope of this feature stops there, or if it encompasses other possibilities for deleting duplicates.

[tea-artist]

Removing duplicate content involves different strategies and is a "write" operation. It is better to implement this requirement through plugins.

We are perfecting the infrastructure of the plug-in system to support such requirements flexibly