<title>Skraak.app | Bioacoustic Data Management</title>

    <title>Skraak | Bioacoustic Data Management</title>

  sampleRate: integer("sample_rate").notNull(),

  index("idx_cluster_location_id").on(table.locationId),

    sample_rate INTEGER NOT NULL,

CREATE INDEX idx_cluster_location_id ON cluster(location_id);

-- Need an index on cluster(location) because I need to get all clusters for any given location

-- Add index to cluster(location_id)
CREATE INDEX idx_cluster_location_id ON cluster(location_id);
SELECT NOW();
-- 2025-04-22 22:17:46.187398+00

-- remove the location string from cluster names, so only trip date reamains

ALTER TABLE cluster ADD COLUMN sample_rate INTEGER;
SELECT NOW();
-- 2025-04-22 22:25:23.215437+00
 
UPDATE cluster
SET sample_rate = subquery.sample_rate
FROM (
    SELECT
        cluster_id,
        MAX(sample_rate) AS sample_rate
    FROM
        file
    GROUP BY
        cluster_id
) AS subquery
WHERE cluster.id = subquery.cluster_id;
SELECT NOW();
-- 2025-04-22 22:44:07.339884+00
ALTER TABLE cluster
ALTER COLUMN sample_rate SET NOT NULL;
SELECT NOW();
-- 2025-04-22 22:48:22.82773+00
-- remove the location string from cluster names, so only trip date remains
UPDATE cluster
SET name = SUBSTRING(name FROM ' [0-9]{4}-[0-9]{2}-[0-9]{2}');
SELECT NOW();
-- 2025-04-22 22:58:08.068198+00