How to create a versioned table from a crud table in Postgres with triggers

Example You have a user table in Postgres: CREATE SCHEMA tutorial; CREATE TABLE tutorial.crud_users ( id INT NOT NULL, username VARCHAR NOT NULL, CONSTRAINT crud_table_pkey PRIMARY KEY (id) ); You insert new users and update usernames for existing users. Update is a destructive operation that overwrites data, so how do you keep track of what …

How to create a versioned table from a crud table in Postgres with triggers Read More »

Comparing the Corona outbreak in Scandinavia and South/South-East Asia

I have read the WHO’s sitreps on CoViD-19 daily since the end of January 2020, where I was visiting Viet Nam. I now live in Denmark (a Scandinavian country) where the Corona virus has shut down society and many people have tested positive. When I compare the numbers for Scandinavia (Denmark, Norway, Sweden) with a …

Comparing the Corona outbreak in Scandinavia and South/South-East Asia Read More »