What does Idempotent mean? #SQL #postgresql #coding #programming

preview_player
Показать описание
A statement is Idempotent when it can be run multiple times without causing side effects - the outcome is exactly the same! 🧠

Insert is not idempotent because every time you run it you create a new row.

Upsert is idempotent because you either create a new row, or update the existing one, but either way you end up with a single row containing the data - even if you run it 100 times!

👇 Learn more about Supabase 👇

Рекомендации по теме
Комментарии
Автор

Never thought that being idempotent would make a good life motto

rembautimes
visit shbcf.ru