adding in things like ‘upsert’ ( in insert if fail, then update in one statement – in postgres 9.5 – which has helped for performance of things we’ve done in workers
implementing time zone awareness in an omnis application with postgres (its pretty dead easy, but took me a few days to solve the problem)
UPSERT Which is an insert, if fail UDPATE — which I’ve also built into a table class. Where we use it — saving window positions where we expect them to be there (but they might not) and duplicates are not allowed. so rather than find, if exist, update, else insert (2 statements), it becomes one —> insert, on duplicate fail, udpate. its great for some conditions.