Yannick 3YH

with t1 (stat, ts, ndx) as ( select monitor_status, performed_at, row_number() over(order by performed_at) from uptime_checks ) , t2 (stat, startts, endts) as ( select t1.stat, t1.ts, coalesce(t2.ts, now()) from t1 left join t1 t2 on t2.ndx = t1.ndx + 1

	import { useRef, useEffect } from 'react';

	const useInterval = (callback, delay) => {
	const savedCallback = useRef();

	// Remember the latest function.
	useEffect(() => {
	savedCallback.current = callback;
	}, [callback]);

	with t1 (id, stat, ts, ndx) as (
	select monitor_id, monitor_status, performed_at, row_number() over(order by performed_at)
	from uptime_checks
	),

	t2 (id, stat, startts, endts) as (
	SELECT t1.id, t1.stat, t1.ts, coalesce(t2.ts, now())
	from t1
	left join t1 t2
	on t2.ndx = t1.ndx + 1