[Postgresql] Implement PostgresBlobIdList

[quantranhong1999]

How

• Table structure:

  CREATE TABLE blobId_list (
  blob_id TEXT PRIMARY KEY
  );

  RLS disabled.

DoD

SingleSaveBlobStoreContract backed by Postgres?

[Arsnael]

• Guice bindings

[quantranhong1999]

https://github.com/linagora/tmail-backend/pull/988

[vttranlina]

sorry for rethinking it

I think we can re-use PostgresBlobStorageTable directly One index for the blob_id column is enough

The dedicated table blobId_list for Cassandra I guess comes from some limited query on single this column

[quantranhong1999]

Hmm the issue is we do not always use the Postgres blob implementation. We can use S3 for example.

[vttranlina]

Hmm the issue is we do not always use the Postgres blob implementation. We can use S3 for example.

it makes sense I forgot it