Experts in Postgres and Open Source Infrastructure

24x7, 365 Enterprise services since 1997

Blog

Keeping the Fire Alive: Maintaining Client Relationships From a DBA Perspective

In my seven years at Command Prompt I've helped many clients, often several of them at the same time. After a project is completed, I know that it was a job well done when that client calls on Command Prompt months and maybe years later for additional help. Often, they call for me by name, creating long lasting and mutually beneficial relationships, which are key to Command Prompt's success. How …

Building Community in the Age of Remote… Everything

Here we are in the beginning of 2021, and it’s been almost a year since we’ve been able to gather safely. While there are a handful of core value propositions to events - namely, increased brand awareness and increased market share - I would argue that one of those most often overlooked is community building. When a common interest brings people to a singular space, community is bound to build, …

Thoughts on Forks and Open Source Licenses

I had the opportunity to speak with Karthik Ranganathan of YugabyteDB a couple of weeks ago; he was the inaugural guest for our new podcast, “More than a Refresh: A podcast about data and people who wrangle it.” Karthik is the CTO and one of the Founders of YugabyteDB. He provided an interesting perspective on Open Source and the license changes of other database companies. YugabyteDB is a …

Meet Amanda Nystrom: Command Prompt's Compassionate Commander in Chief

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 Amanda Nystrom, Owner & Senior Project and Operations Manager.

Amanda_Kiwi.jpg

How long have you been with Command Prompt?

Six and a half years. I originally joined the team as a consultant in 2009 for about a year, and when the stars aligned I ended up back …

Are We Working from Home or Living at Work?

The general sentiment among my loved ones - those lucky enough to still have jobs - is that working from home has transformed their jobs on even the most basic levels. Meetings are on Zoom, group tasks get completed at a different pace, and communication styles have rapidly evolved to account for the lack of face-to-face interaction (how many “virtual happy hours” have you been on since March?).

For the …

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 …