Tags » PostgreSQL

Building a Concourse CI VM on CentOS

Recently, I’ve found myself needing a Concourse CI system. I struggled with the documentation on concourse.ci, couldn’t find any comprehensive build guides.  Knew for certain I wasn’t going to use VirtualBox.   897 more words


.NET Core, ASP.NET Core logging with NLog and PostgreSQL

This article shows how .NET Core or ASP.NET Core applications can log to a PostgreSQL database using NLog.

Code: https://github.com/damienbod/AspNetCoreNlog

Other posts in this series: 1,141 more words


How to Benchmark Alternative SQL Queries to Find the Fastest Query

Tuning SQL isn’t always easy, and it takes a lot of practice to recognise how any given query can be optimised. One of the most important slides of my… 2,169 more words


Use PostgreSQL Aggregate functions for inventory and asset tracking needs.

PostgreSQL’s Aggregate functions can be used to solve and answer many common questions and problems, allowing us to present our data in meaningful ways. Today we will look at an example of how to use some of these powerful functions for inventory or asset tracking needs. 1,042 more words


Configure Django with postgres

Django comes preconfigured with SQLite db. This is goood for playing with django features or doing some lightweight apps. For big applications we have to use the mysql or postgreSQL db. 338 more words


PostgreSQL 9.6 on RHEL 7.2 -FATAL: semctl(SETVAL) failed: Invalid argument

PostgreSQL 9.6 on RHEL 7.2 -FATAL: semctl(SETVAL) failed: Invalid argument

The error below started occurring once we upgraded to PostgreSQL 9.6 on RHEL 7.2. It was strange because all we did was had a user to login, check the status of pgsql and logout. 366 more words

Oracle Database

Delete existing record from PostgreSQL database with Python and Psycopg2.

Today’s blog post will show an example of how to delete an existing record from a PostgreSQL database utilizing Psycopg2 , a feature-rich Python library, that offers a tremendous amount of functionality for working with Python and… 1,098 more words