Blog

Escaping data madness

We had an interesting issue crop up this past week. The question was, "How do we properly escape the following string...?". The string was:

You can't have it that way can you?

That seems like a pretty simple string right? On insert you would do one of the following:

   (E'You can\'t have it that way can you?');
   ($$You can't have it that way can you?$$);
   ('You can''t have it that …

Registration closing for PostgreSQL Conference East

As a reminder for all of those in our community that like to register at the last minuted (that means most of us), registration will be closing on Wednesday April first. On line registration is much easier than registering at the door so please bounce on over to PostgreSQL.us/purchase and get your registration in.

PostgreSQL Training

Command Prompt has offered training since we began as a one man shop back in 1997. It has always been, "by request". Since that time a lot of things have changed and we are regularly receiving training requests from multiple companies. We have decided to finally bring our training into the light and make it a forefront of the services that CMD offers. Interestingly we are going to be providing …

PostgreSQL Conference East: Final Schedule announced

PostgreSQL Conference East is the Eastern segment of the United States PostgreSQL Conference series. The event is being held at Drexel University. It starts on April 3rd and runs through April 5. We kick the conference off on April 3rd with three sessions. For DBAs we have Mastering PostgreSQL Administration a four hour training, presented by PostgreSQL Core Team member Bruce Momjian. For Developers we have a Database Normalization, a …

Remembering excellence from past PostgreSQL Conferences

Just about 5 months ago we held PostgreSQL Conference, West 2008 in Portland Oregon. It was a very successful conference with approximate 20% growth over the previous West in 2007. It was also a three day conference over the previous West event which was a single day conference. As we prep to hold PostgreSQL Conference, East 2009 at Drexel University I wanted to look back at one of my favorite …

Pg Conference East 09, Registration open

This year is shaping up to be an even larger even than last year with 3 days, four rooms, and multiple tracks. East runs from April 3rd to April 5th at Drexel University. To register please point your Open Source web browser to PgUS. Registration is free for Students and Professors and starts at as low as 40.00 for University staff. Once you have registered make sure to visit and …

Seven things

Theo Schlossnagle recently wrote a blog post called seven things. The idea is, seven things that you "might" want to know about him. Along those lines he listed me as someone he would like to know seven things about. It has taken me a while to get to the post because I have been busy with various things. So here we go, seven things about me.

I have crashed …

PostgreSQL Conference: Talk deadline approaching

The deadline (Feb, 23rd) is fast approaching for PostgreSQL Conference East talk submissions. Get your talk in today!

PostgreSQL mininum requirements

In this article we will be discussing the minimum requirements for production usage of PostgreSQL whether on-prem or in the cloud. We will not be discussing proprietary forks such as Amazon RDS or other Open Source forks such as Yugabyte or Greenplum.

PostgreSQL is the Linux of databases. It provides the kernel and key features to the most critical database services available today.

Postgres and Open Source Experts

Blog

Escaping data madness

Registration closing for PostgreSQL Conference East

PostgreSQL Training

PostgreSQL Conference East: Final Schedule announced

More PostgreSQL Conference goodness, West 08 Keynote

Remembering excellence from past PostgreSQL Conferences

Pg Conference East 09, Registration open

Seven things

PostgreSQL Conference: Talk deadline approaching

PostgreSQL mininum requirements

Recent blogs

Why You Should Review Your Authentication Strategy

PgManage 1.4 – SQL Server Support, Faster Interface Navigation, Spreadsheet‑like Data Grids & More!

PostgreSQL Version 13 Reaches End of Life: Migration and Extended Support Strategies

Cost Optimization for PostgreSQL: Practical Tips for Technical Teams

PostgreSQL 18: Revolutionary Performance Boost Now Available

Why Growing Teams Are Moving from Aurora to RDS or EC2: Cost and Control Considerations on AWS

PgManage 1.3.1: Enterprise Edition Released