Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

Optimizing the documentation

The community has spent a lot of time optimizing features over the years. Excellent examples include parallel query and partitioning which have been multi-year efforts to increase the quality, performance, and extend features of the original commit. We should consider the documentation in a similar manner. Just like code, documentation can sometimes use a bug fix, optimization, and/or new features added to the original implementation.

Technical documentation should only be …

Null Characters: Workarounds Aren’t Good Enough

By Anders Cornell, Jr. DBA

PostgreSQL is a great piece of software. Its features are well-designed, and they compose elegantly. It’s among the most versatile and reliable software I've ever used and its comprehensive superiority over other relational database products leads me to think of PostgreSQL as the data-store that can do anything. But today I'm here to discuss something that PostgreSQL can't do: handle null characters (also known as …

Meet Lindsay Rae Hooper: Command Prompt's fun-loving haystack

Welcome to our blog series: Meet the Team, where we will introduce you to the minds behind Command Prompt. This month we are talking with Lindsay Rae Hooper, Director of Marketing and Events

LRH Canaries.jpeg

How long have you been with Command Prompt?

I started with Command Prompt in September 2019, so I’ve been here a little over a year. I knew JD and Amanda through Postgres Conference so when I left …

IS OF

I am on the phone with Eric Ridge of ZomboDB and PGX fame. We chat often on the People, Postgres, Data Discord server (yes you should join) and we have unofficial “we are human so we get on the phone” calls about twice a month. The calls are generally about PostgreSQL and the awesome Open Source projects he is building around our famed database. However, on this call I got a question I don’t normally get: how good is your SQL?

Professionalism Matters - Even When Working Remote

Today we are working from home, from the road, or from family’s homes. Article after article has been written about how to work productively outside of our normal work environment. What they tend to leave out is that professionalism isn’t just for the cubicle; it extends to all matters of the office including working remotely.

That means being purposeful and professional every day. That includes being respectful, dressing for …

Meet Justin Graf: Command Prompt's Offgrid Aficionado

Welcome to our blog series: Meet the Team, where we will introduce you to the minds behind Command Prompt. This month we are talking with Justin Graf, DBA.

pic5.png

How long have you been with Command Prompt?

I started in March 2020, but I’d known about Command Prompt since 2004/05. At the time I was looking for a new ERP/MRP package for the company that I was working for as the …

Pay it Forward

Where were you the first time you were told to “pay it forward?” Were you the recipient of someone else’s good deed, or did a friend or mentor help you out of a pickle? Paying it forward is a fascinating concept with far reaching effects. According to Dictionary.com’s Pop Culture Dictionary, Paying it Forward is defined as “an expression for when the recipient of an act of kindness …

The COVID-19 Pivot: An Opportunity for Reflection

As we get more immersed in our careers and lifestyles, we get comfortable. And when we’re comfortable, we avoid tasks outside of our wheelhouse like the plague (or pandemic). Yes, we grow and we learn, but we love to stay in our field; our realm of comfort, our box. Generally speaking, we can stay where we want, but with the changes of 2020, the question for many people has now …

Meet Ron Farrer: Command Prompt's Lifelong Tinkerer

Welcome to our blog series: Meet the Team, where we will introduce you to the minds behind Command Prompt. This month we are talking with Ron Farrer, one of Command Prompt's System Administrators and JR DBA. 

Ron1

Where are you based?

I’m from Bellingham, Washington. I currently reside 20 minutes north, but in a few weeks I’ll be moving back to Bellingham.

How long have you been with Command Prompt?

I’ve …

Meet Debra Cerda: Command Prompt's Ranged Attack Expert

Welcome to our blog series: Meet the Team, where we will introduce you to the minds behind Command Prompt. This month we are talking with Debra Cerda, Director of Business Development.

 

Where are you based?

I’m based in Austin, Texas, and I’ve been here since 1993. I’m a native Texan, born and raised in Houston, but I visited Austin in ‘93 and fell in love with it. “Keep Austin Weird” …