Open in app

Sign In

Write

Sign In

Pham Ngoc Quy
Pham Ngoc Quy

1 Follower

Home

About

Apr 17, 2022

Setup hot standby PostgreSQL

This is a guild for setup PostgreSQL replication hot standby Install PostgreSQL on two servers as primary and replication servers. Can refer to this article for installing PostgreSQL. Configuration on the primary server. The combination of Hot Standby and Standby Replication would make the latest data inserted into the primary…

Postgresql

2 min read

Postgresql

2 min read


Apr 17, 2022

Setup PostgreSQL from binary

This story is a guild to install PostgresSQL from the binary. Download specific PostgreSQL version: wget https://ftp.postgresql.org/pub/source/v11.1/postgresql-11.1.tar.gz --no-check-certificate Extract and install: mkdir -p pg_src tar xf postgresql-11.1.tar.gz --strip-components=1 -C pg_src # create env folder mkdir -p pg_env cd pg_src ./configure --prefix=pg_env make all -j4 make check make install

Postgresql

1 min read

Postgresql

1 min read


Dec 22, 2020

Understand DateTime converting on python

Have ever you confusing when converting the timezone on python. So, in this post, I will describe a simple way to understand and using timezone converting. We have two steps to conversion DateTime from a timezone to another timezone. 1. Determined current timezone. from datetime import datetime fdate = datetime.now() For the above code, the fdate variable will be assign timezone of local. I’m in Singapore fdate is in Singapore UTC+8.

Python

1 min read

Python

1 min read


May 12, 2020

Export and import firebase auth data

Follow this tutorial. So you need to install firebase tool using npm: npm install -g firebase-tools and login using: firebase login Export firebase user for a specified project on your firebase we have two output file format: CSV, JSON: firebase auth:export file_name.csv --format=json --project <project-id> Import firebase user data Go to your console firebase on page Authentication select user: Now, you can get hash_config of authentication data. You need this config to import your data:

Firebase

1 min read

Firebase

1 min read


May 12, 2020

Config virtual environment python on Jupyter Lab

Are you working with Jupyter Lab and Python? Do you have occurs when Jupyter lab using root python environments In this tutorial, I will guide you on how to config specify python virtual environments for the Jupyter lab. Create Virtual Environment with Virtualenv/venv A commonly used tool for virtual environments in Python is virtualenv. Since…

Python3

2 min read

Config virtual environment python on Jupyter Lab
Config virtual environment python on Jupyter Lab
Python3

2 min read


Nov 26, 2019

Multiple Database in Flask

How can we use multiple database in flask. Flask-SQLAlchemy can easily connect to multiple databases with binds Example Configuration Binds table to each other database: We need define name of table for each database

1 min read

1 min read

Pham Ngoc Quy

Pham Ngoc Quy

1 Follower

Dev-Ops, Data Engineer

Following
  • The Scratch Team

    The Scratch Team

  • Netflix Technology Blog

    Netflix Technology Blog

  • Chi Thuc Nguyen

    Chi Thuc Nguyen

  • Adam Geitgey

    Adam Geitgey

  • Mai Thanh Binh

    Mai Thanh Binh

See all (9)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech