Viewing profile — haki

Some a prime example of a service that naturally peaks at round hours. We have a habbit of never scheduling long running processes at round hours. Usually because they tend to be b…

See psycopg Identifier for binding table names https://www.psycopg.org/psycopg3/docs/api/sql.html#psycopg.s...

Since at least two people noticed, I would just say that the insert-select-insert approach was added later, after I took some inspiration from Django's implementation of get_or_cre…

If you store large jsonb values in the database, storing them out of line may be a good thing - for example, you can query metadata much faster. Also, worth mentioning that jsonb i…

I used excalidraw.com

You can utilize transactional DDL for that https://hakibenita.com/sql-tricks-application-dba#make-index...

I'm always looking for new copy tricks. Is "copy" a temporary table? Or a variable...?

See relevant section in the article: https://hakibenita.com/python-mypy-exhaustive-checking#the-f...

Starting at PostgreSQL 12 you don't even have to feel bad about all of those CTE's.

See this https://hakibenita.com/fast-load-data-python-postgresql