I can’t work out whether it’s possible to increment column values or whether it is only possible to plain upsert. In
postgres SQL it would be
INSERT INTO ReservationCounter (student_id, reservation_count) VALUES (1, 1) ON CONFLICT (student_id) DO UPDATE SET reservation_count = reservationcounter.reservation_count + excluded.reservation_count;
Is this possible with
ksqldb, or some other similar ready-made system, or will I have to roll my own for this (pushing to
postgres, if that makes a difference)?