Postgres and Open Source Experts

24x7x365 since 1997

Blog

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 …

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 …