Mike Organek questions

Mike Organek answers

• how to calculate overlap duration of two non-periodic time series + grouped
• What happens if I subscribe to a MQTT topic which has never been published to?
• Is it possible to have a persistent psql connection in bash?
• Count events with a cool-down period after each instance
• Can Django's select_for_update deadlock when used on the same record twice?
• Criteria and strategy for partitioning a large table in Postgres
• Swapping column values in PostgreSQL
• Can't start postgresql on WSL Ubuntu
• SQL Find pairs of rows with next best timestamp match
• Is there a way to do conditionals inside Python (3) for loops?