Django is a popular Python web framework, below is how to use IIS(Internet Information Service) to host Django application on Windows. Install Python on Windows https://python.org Create a python virtual environment so your future development won’t rely on existing Python executables
Deploy pgAdmin as a web service under venv environment
pgAdmin can be deployed as a web server therefore user doesn’t need to install any client to access DB. This also provides a securer way of accessing your database: suppose your web server is on the same network as your
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
Blurry text on big monitor (full HD)
I recently bought a 2nd monitor (Samsung S24F350FHE 23.6” Full HD) and connected it to my laptop; It however annoyed me that everything I dragged to this big screen appeared ugly – fonts looked blurry comparing to what’s on my built-in
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
Configure Google Cloud Platform – Creating a virtual machine
In this article, I’m going to demonstrate how to configure a Virtual Machine(VM) on Google Cloud Platform. Create a VM Go to Home->Compute Engine, and “CREATE INSTANCE” Once an instance is created, it will
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 –
Postgresql upgrade from 9.3 to 9.6
Have been using Postgresql 9.3 for a while until recently after upgrading to PgAdmin4 1.3, I cannot import my backup due to compatibility issue, so I decided to upgrade Postgresql to the current version 9.6. Below are my notes on steps: