consumer/src/db/sql/postgate_upsert.sql at feat-viewer-interactions

quilling.dev / parakeet

forked from parakeet.at/parakeet

fork atom

Rust AppView - highly experimental!

fork atom

parakeet / consumer / src / db / sql / postgate_upsert.sql

at feat-viewer-interactions 7 lines 394 B view raw

wrap content

mia.omg.lol feat(consumer): Consumer Performance Improvements 9mo ago

c2fc8913

1INSERT INTO postgates (at_uri, cid, post_uri, detached, rules, created_at)
2VALUES ($1, $2, $3, $4, $5, $6)
3ON CONFLICT (at_uri) DO UPDATE SET cid=EXCLUDED.cid,
4                                   post_uri=EXCLUDED.post_uri,
5                                   detached=EXCLUDED.detached,
6                                   rules=EXCLUDED.rules,
7                                   indexed_at=NOW()