Postgres Upsert On Conflict Where Clause

A basic example of a Postgres Upsert using “on conflict do update” with a where clause.    Postgres Upsert ON CONFLICT with WHERE clause create table z_test( f1 text PRIMARY KEY, f2 text, f3 text, f4 text ); insert into z_test (f1,f2,f3,f4)...

A Few WordPress Database Queries

A few basic WordPress database queries as an example, to gain basic insight into the WordPress database entity relationships:   View the code on...

MySQL Cheat Sheet

This article introduces some basic MySql database concepts including definitions, database connections sql, sql to import and create a MySql database.

About Me

I am a software developer with over 20 years experience. I have team lead/management experience and have worked both on-site and freelance/remote (both as a permanent staff member and as a contractor) at various stages of my career. I have worked internationally in London, Dublin and Cape Town. I'm currently based in Cape Town.

Pin It on Pinterest

Share This