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. http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from-instagram The first two are of the most interest to us developer types, their use … Continue reading Handling a Large PostgreSQL Installation Article by Instagram →

Linux and Windows 2012 WebDev Cloud Servers – The Summary

Those of you that have been following me have now that over the last week I did a series of articles on Building a both a Windows and a Linux Cloud Server on Rackspace.com to be used as a WebDev WAS Server. This is my final thoughts after building both, and why I built … Continue reading Linux and Windows 2012 WebDev Cloud Servers – The Summary →

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 2 (The Data)

In part one we covered Case Sensitivity of the Data Definition Language (DDL), in part two we will move on to the data itself and once again examine some best practices that have worked for me.

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.

PostgreSQL Images with WinDev – Update 12/21/2012

If you want to store images in your postgreSQL database and display them directly in a WinDev image control, Then you need to configure your database to return the bytea format as 'Escape' instead of Hex. With V9 of PostgreSQL the default changed to Hex and apparently pcSoft has not caught up with the new … Continue reading PostgreSQL Images with WinDev – Update 12/21/2012 →

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.