Page MenuHomeSoftware Heritage
Create Task
Maniphest T3019

Add an index for raw_extrinsic_metadata.id in swh.storage.postgresql
Open, HighPublic
Actions

Description

  1. new column with the hash
  2. fill it (will need a migration with python code)
  3. add unique index
  4. make the new index a primary key?

Related Objects
Search...

StatusAssignedTask
 ResolvedardumontT2685 Test update of deposit with metadata-only in integration tests
 OpenNoneT2344 Build a connector for software deposit via Zenodo/InvenioRDM
 ResolvedNoneT2538 Add new option for the CLI swh-deposit for the metadata-only deposit
 OpenNoneT1021 SWORD deposit of metadata about an existing SWH object
 ResolvedardumontT2537 Extend new deposit endpoint to support metadata-only deposits
 Work in ProgressvlorentzT2540 support the loading of metadata-only deposits in the metadata storage
 Work in ProgressvlorentzT2779 Put information (client, collection and deposit-id) inside metadata for metada-only deposit
 OpenNoneT2201 Indexing / mining
 OpenNoneT2202 Extrinsic metadata
 Work in ProgressvlorentzT2513 Copy metadata on revisions to the extrinsic metadata storage
 Work in ProgressolasdT2520 Setup dedicated kafka cluster on new rocquencourt hardware
 OpenolasdT2686 Use hashes for all kafka keys
 ResolvedvlorentzT2668 Package loaders should write extrinsic metadata on directories instead of revisions/releases
 OpenvlorentzT2703 Use intrinsic identifiers/hashes for RawExtrinsicMetadata objects
 OpenvlorentzT3018 Allow querying raw_extrinsic_metadata by hash in swh-storage
 OpenvlorentzT3022 Deduplicate RawExtrinsicMetadata by hash instead of a subset of their fields
 OpenvlorentzT3019 Add an index for raw_extrinsic_metadata.id in swh.storage.postgresql
 OpenvlorentzT3074 Migrate all packages away from the old SWHID class
 OpenNoneT3034 generalize usage of SWHID for referencing SWH archive objects

Event Timeline

vlorentz triaged this task as High priority.Tue, Feb 2, 1:37 PM
vlorentz created this task.
vlorentz removed subscribers: rdicosmo, moranegg.Tue, Feb 2, 1:40 PM
vlorentz renamed this task from Allow querying raw_extrinsic_metadata by hash in swh.storage.postgresql to Add an index for raw_extrinsic_metadata.id in swh.storage.postgresql.Tue, Feb 2, 2:20 PM
vlorentz added a parent task: T3022: Deduplicate RawExtrinsicMetadata by hash instead of a subset of their fields.
vlorentz added a subtask: T3074: Migrate all packages away from the old SWHID class.Fri, Feb 26, 6:57 PM
About · Developer information · Legal