community-archive/sql/functions/threads/ at main · alice.mosphere.at/community-archive

alice.mosphere.at / community-archive

this repo has no description

community-archive / sql / functions / threads /

at main 5 files

ri72miieop Move conversation_id from tweets table to a new table called conversations Change materilized view to calculate info for all threads for a function that does that same for a single conversation_id Create view tweets_w_conversation_id 1y ago

01_update_conversation_ids.sql

restore comment that was mistakenly removed

1 year ago

02_post_upload_update_conversation_ids.sql

Move conversation_id from tweets table to a new table called conversations Change materilized view to calculate info for all threads for a function that does that same for a single conversation_id Create view tweets_w_conversation_id

1 year ago

02_update_conversation_ids_optimized.sql

Fix conversation ID update timeout issues and optimize performance (#277)

6 months ago

03_get_main_thread.sql

Move conversation_id from tweets table to a new table called conversations Change materilized view to calculate info for all threads for a function that does that same for a single conversation_id Create view tweets_w_conversation_id

1 year ago

03_update_conversation_ids_optimized_v3.sql

Fix conversation ID update timeout issues and optimize performance (#277)

6 months ago