Due to security requirement, most companies don’t allow Google Cloud SQL (Postgresql) to be accessible via public IP. This article shows how to configure private IP for the db so that a web service built on App engine can communicate
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
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) .
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
Postgresql upgrade from 9.6 to 10.0
The lasted Postgresql 10 brings in a number of exciting new features: parallel queries, partitions, new sequence and logical replication. Below are steps to upgrade v9.6 to v10. It has similar steps as described in my previous post “Postgresql upgrade
Enable debug in PostgreSQL
PgAdmin comes with built-in support for debugging your Pl/PgSQL programs. However in order to enable this, you’ll have to compile and install extra plug-in to PostgreSQL. I Googled a lot but didn’t find one single post with all steps so
Using Oracle SQL Developer Data Modeller (SDDM) for Postgresql
I have been searching for a good data modelling tool (ER modelling) for Postgresql – have tried a number of products but none of them are satisfactory except for SAP Powerdesigner which I really like. However it’s expensive and I don’t
Postgresql 10 new features
Personally excited about the new version of Postgresql V10. It’s still in beta stage but it has following exciting new features that I have been waiting for: Table partition. A genuine identify column. The previous serial is implemented by a separate
Google Cloud Platform – Introduction
I’ve been trying Google Cloud platform for a while and this article is about my experience with it. If you’re interested, you can get free trial for a year ($300 worth of credit). Initially Google Cloud platform looks daunting –