Just excellent service

POSTGRES CENTERED FULL STACK SUPPORT, CONSULTING & DEVELOPMENT

Blog

Reverse DNS Zones With AWS Simple AD

Consider a fairly complex design of a DNS service in AWS cloud: one that includes native AWS Route 53, AWS Simple AD and traditional BIND service running on EC2 instances to cater to different needs of development and production environments in terms of serving DNS requests and providing directory services.

All EC2 hosts in one of your production VPCs are pointed to Simple AD DNS servers that are your primary …

Keys to Moving Forward In Your Life and Career - How Self Awareness Affects Your Life

Finding the right path when moving forward with your career can be challenging. From the difficult subject of compensation increases, to knowing when you are ready to move up into a new role, to refining the skill set you have; there are many steps that have to be put in place in order to further your career. In this series, I’ll provide tips as a COO for what I …

Meet Tiffany Gustanski: Our Well-Rounded Project Manager

Welcome to our blog series: Meet the Team, where we will introduce you to the minds behind Command Prompt. This month we speak with Tiffany Gustanski, Assistant Project Manager at Command Prompt.

How long have you been with Command Prompt?

I’ve been with Command Prompt since August 2020.

What’s your background and expertise?

Before Command Prompt, I was a project manager for a cloud SAAS company, implementing their …

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 compelling product …

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 past year …

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 …

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 …