Programster's Blog

Tutorials focusing on Linux, programming, and open-source

Using PostGIS To Calculate Distance Between Two Points

Calculate the distance between two points on earth using PostGIS.

PostGIS - Importing Spatial Data

Import spatial data into PostgreSQL and query the data with the help of PostGIS.

Ubuntu 16.04 - Install PostGIS

Install PostGIS in PostgreSQL.

Ubuntu 16.04 - Install PostgreSQL Routing Extension (pgRouting)

Install the routing extension for PostgreSQL

PHP - Using UUID Instead of Auto Increment or Sequence

Learn how to use UUIDs in MySQL for your table IDs, rather than using auto_increment.

Ubuntu 16.04 - Install PostgreSQL 10

How to install PostgreSQL on Ubuntu 16.04

PostgreSQL Parallel Queries

Getting Started With Using PostgreSQL in PHP

Configuring PostgreSQL After Installation

Configure your PostgreSQL database

PostgreSQL Cheatsheet

A cheatsheet for using PostgreSQL

Debian 8 - Install PostgreSQL 9.x