Category: PostgreSQL

Handling a Large PostgreSQL Installation Article by Instagram

Just so you don't think Uncle Pete has forsaken PostgreSQL Instagram has one of the largest PostgreSQL installations in the world, and they just recently posted an article on their blog with 5 tips for handling large PostgreSQL installations.   The first two are of the most interest to us developer types, their use … Continue reading Handling a Large PostgreSQL Installation Article by Instagram

Auto Incrementing with PostgreSQL and Windev (Updated 10/3/2012)

Photo by bling_rocks There are a few challenges when attempting to use auto-incrementing keys with PostgreSQL and Windev. But once we understand what the issues are, its easy enough to work around. PostgreSQL uses sequences to accomplish auto auto-incrementing fields, for those that normally work with SQL Server this is a little different than the Identity Columns of SQL Server. … Continue reading Auto Incrementing with PostgreSQL and Windev (Updated 10/3/2012)

PostgreSQL Case Sensitivity Part 1 (The DDL)

Anytime you discuss PostgreSQL, the issue of case sensitivity quickly boils to the top of the conversation. Having used PostgreSQL in several high volume production systems for the last 3 years I will attempt to seperate some of the myth and legend out of the conversation and provide some best practices methods that have worked for me.

SQL 101: Inline Views

SQL is a deceptively simple language, there are very few keywords and it doesn't take long to be proficient at simple select, update and delete statements. However SQL is a very powerful language that can be built upon for ever more increasingly complex calculations. This is the first in a planned series of articles on SQL, to assist others in understanding the basic building blocks and recombining them to achieve new heights with SQL. This article will be a quick primer into inline views. Inline views are a concept that is very important to understand as many of your more complex queries can be accomplished with the use of inline views.