Programster's Blog

Tutorials focusing on Linux, programming, and open-source

Play with PostreSQL Through Docker

Play around with PostgreSQL with docker so that you don't have to install it locally and can throw it away.

Ubuntu 18.04 - Install PostgreSQL

Install PostgreSQL client/server in Ubuntu 18.04.

PostgreSQL - Leaderboard Query Example

A buildup of how to generate a query to create a "leaderboard" of of your top scorers.

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