Postgresql 10 introduced identity column which offers better manageability than the old fashioned serial. Refer to this post for more detail I followed the post above and converted most of serial columns into identity, worked all good until one day
PostgreSQL logical replication
Logical replication was introduced in PostgreSQL 10. It offers better flexibility than stream replication in a number of ways: Publisher and subscriber can be on different major versions Replication can be done at table level, sharing a subset of the
Use Cloud function to start and stop Cloud sql
We have setup a Cloud sql database for development but would like to save cost by shutting it down during night. This article shows how to achieve this. The overall architecture is Cloud function is used to hold Python code
Bigquery parallel loading
There are many ways to load data into BQ but using Python gives us the most control. Below I’m going to demonstrate loading files into BQ in parallel. My test scenario is: 191 csv files, sizing from 10Mb – 1Gb
Dates in SAP
My first post on SAP based on my working knowledge. I’m not a SAP support or developer so there are still lots of unknown to me There are so many dates in SAP: Baseline date, net due date, invoice date,
Postgresql upgrade from 11.x to 12.1
This is a new post based on my previous “Postgresql upgrade from 9.6 to 10.0“, with necessary updates and corrections. The latest Postgresql 12 (12.1) further improved performance on parallel queries, partitions, automatic (but overridable) inlining of common table expressions (CTEs) .
Domain and email hosting
I recently moved my email service to Zoho as the free email service offered by my hosting company (Inmotionhosting) had never been great: delays, failures of sending and sometimes even email loss. OK, it’s a free service so nothing to
Data recovery tool
I was really amazed by a data recovery tool I recently used – it recovered files used to be on Windows from a Linux formatted disk! A really great tool I highly recommend! The tool R-Studio has Windows, Linux and
Building a PostgreSQL docker container with debugger (pldebugger)
Further to my previous post, I wanted to enable debugging in PostgreSQL Docker container so that it can be used together with PGAdmin4. The challenge is it is not enabled by default in any of available Docker images; I also
Building a development box on Docker
This article is going to show steps and configurations on how to build a development box (PHP CodeIgniter + Apache + PostgreSQL) using Docker on Windows. Why Docker Comparing to VirtualBox, it’s a lot easier and probably faster Portable. Files