Blog

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. 

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 been with Command Prompt for five years. JD posted in the Bellingham Linux Users Group and I didn’t know it at the time, but JD was also located in Bellingham. All I knew was that Command Prompt did open source work and a lot of stuff with Linux ...

Read More

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” is a throwback to the ‘60s and ‘70’s of Austin, the very hippie culture - I’ll definitely say that’s something that appealed to me when I first visited. It’s very laid back and eclectic.

How long have you been with Command Prompt?

I joined Command Prompt in May of 2017 ...

Read More

Meet Andrew Smith: Command Prompt's Australian Altruist

Welcome to our blog series: Meet the Team, where we will introduce you to the minds behind Command Prompt. Last month we talked with Andrew Smith, one of Command Prompt's senior Developers. 

Where are you based?

I’m based in Cebu, Philippines. There are probably more people telecommuting from Cebu than anywhere else in the world, and Cebu felt like the most natural place to live because I telecommute anyway. 

I’m originally from the Sunshine Coast, Queensland, Australia. I moved to Tasmania in my late 20’s, and a few years ago I decided to challenge myself with the most difficult and scary thing that I could possibly imagine doing, and that was moving to a different country entirely ...

Read More

How to add seconds to a timestamp to get an ending timestamp?

Command Prompt is one of the oldest Postgres support companies in the world and we have been blessed to be extremely busy with Professional community development including meetups and conferences. With the current climate we thought it would also be useful to remind people of “Simple Tips”. Simple tips will help new users of Postgres and related technologies to answer those pesky little questions that are in the back of their heads about how to do “insert idea here”.

How to add seconds to a timestamp to get an ending timestamp?

Assume you have have 2 values:

starting timestamp

duration (seconds)

How do you determine the ending time? 

 

There are a number of ways this can be done ...

Read More

Meet Eric Worden: Command Prompt's Mushroom Maven

Welcome to our new blog series: Meet the Team, where we will introduce you to the minds behind Command Prompt. This month we are talking with Eric Worden, one of Command Prompt's senior DBAs. 

Where are you based?

Bellingham, WA. It’s a pretty cool coincidence that this is where JD and Amanda live as well.

How long have you been with Command Prompt?

I’ve been with Command Prompt for five years and a few months, so I’m going on six years.

What’s your background and expertise?

Well I studied zoology and biochemistry in college, and my first job was teaching middle school science. Later, in my first IT job, I got started in databases. I designed an Access ...

Read More

How to Achieve Success When Working From Home

In today’s world it is important to know that you have a team to back you up. From all of us at Command Prompt, we are here to help. It is our goal to help our clients, partners, and community succeed.

As a pioneer in building a successful employment from home culture we have moved through the trial and test phases of what does and doesn’t work when working without a central office. In an effort to help you transition with ease, we have put together a list of important things to take into consideration. 

  How to achieve success when working from home: 

Set a routine and stick to it. 

  • Your work schedule shouldn’t change much ...

Read More

Coronavirus (COVID-19) Update - Letter From Our Founder

As the global spread of COVID-19 (SARS-CoV-2) hits home, disrupting lives and communities, our Command Prompt team has been working diligently to ensure that our clients receive the quality and excellence in experience we've promised them. As Command Prompt is a strategically globally distributed company, our staff continue to do their best work – all in a safe, remote, and productive environment.

Please be aware that we are committed to supporting your company and team needs during this time of uncertainty. We have and will continue to deliver high-quality and reliable professional Postgres support and service as we’ve done for over two decades.

Our technical support, education, and project management teams are standing by to help you in this ...

Read More

Meet Eugene Dubinin: Command Prompt's Postgres Sailor

Welcome to our new blog series: Meet the Team, where we will introduce you to the minds behind Command Prompt. This month we are talking with Eugene Dubinin, one of Command Prompt's senior Developers. 

Longform Questions:

How long have you been with Command Prompt?

I’ve been working with Command Prompt since May 2016, so almost four years now

What’s your background and expertise?

Computer science started as a hobby around 8th grade. My first job in technology was when I was in school: I started out as a part time systems administrator for the university. 

I did a lot of IT-related work after college, and I have a background as a systems administrator for a regional ISP ...

Read More

Meet Ivan Lezhnjov: Command Prompt's Open Source Detective

Welcome to our new blog series: Meet the Team, where we will introduce you to the minds behind Command Prompt. First up is Ivan Lezhnjov, Lead Systems Administrator.

Longform Questions

How long have you been with Command Prompt?

Since the fall of 2012, so around 7+ years.

What’s your background and expertise?

I’m a Lead Systems Administrator / DevOps Administrator. I'm self-taught and have been fascinated with Linux and the free software movement since the early days. When I was in highschool, and throughout university, I was really fascinated with Linux as a hobbyist. Somehow that transformed into a career. 

What’s your favorite project of all time?

It’s so difficult, because there’s so many great open source projects and ...

Read More

Recognizing and Developing Emotional Intelligence

There are many ways to define intelligence, and the most commonly accepted definition being in relation to facts, figures, and reasoning. This leaves out the emotional, interpersonal, or social aspects of intelligence, known as the Emotional Intelligence Quotient, or EQ. According to Merriam-Webster, intelligence is defined as:

  • (1): the ability to learn or understand or to deal with new or trying situations : REASON also: the skilled use of reason
  • (2): the ability to apply knowledge to manipulate one's environment or to think abstractly as measured by objective criteria (such as tests)

Per Google, Emotional Intelligence is the capacity to be aware of, control, and express one’s emotions, and to handle interpersonal relationships judiciously and empathetically. EQ is ruled by ...

Read More

Keys to Moving Forward In Your Life and Career - Making the Leap to Uncomfortable


Finding the right path when trying to move forward with your career can be challenging. From the difficult subject of compensation increases, to knowing when you are ready to move up in a role, to refining the skill set you have; there are many stepping stones that have to be put in place in order to successfully move forward in your career. In this article series I provide tips as Senior Management for what I look for and what has been expected of me over the years to help you reach your professional and personal goals. 

---

Making the Leap to Uncomfortable

In the last article I discussed the importance of getting out of your own way and becoming uncomfortable ...

Read More

Keys to Moving Forward In Your Life and Career - Get Out of Your Own Way

Finding the right path when trying to move forward with your career can be challenging. From the difficult subject of compensation increases, to knowing when you are ready to move up in a role, to refining the skill set you have, to truly understanding what your boss expects of you; there are many stepping stones that have to be put in place and in the right sequence in order to successfully move forward in your career. In this article series I provide tips as Senior Management for what I look for and what has been expected of me over the years to help you reach your professional and personal goals. 

---

Get out of your own way

There are many ...

Read More

Hacking on PostgreSQL snap at Snapcraft Summit 2018

As you may know, Command Prompt, Inc. develops and maintains PostgreSQL snap packages as a service to community. If you used it, you also know that unfortunately it is not yet a drop-in replacement for DEB builds distributed via PGDG APT repository.

PostgreSQL is one of the major open source projects out there that is extremely popular with all sorts of crowds: from enthusiasts to unicorn startups. And as the Snapcraft ecosystem matures more and more, a fully-functional PostgreSQL snap package becomes absolutely necessary for reasons ranging from developers being able to easily run PostgreSQL in strictly isolated test environments, to providing more complex software solutions that build on PostgreSQL (e.g. Travis CI people expressly stated they were very ...

Read More

Command Prompt Inc. Invites You to Attend InnoTech Houston

One of my favorite annual technology events takes place each October in my hometown of Austin, Texas -- Innotech Austin. I've attended for several years in support of local nonprofit groups including Chick Tech Austin and Austin Women in Technology, as well as for Command Prompt Inc. I thoroughly enjoy the networking opportunities and the professional yet relaxed atmosphere of this event. While attending and exhibiting at Innotech Austin earlier this month, I met several potential partners in supporting PostgreSQL not only for users, but also for students aspiring to a career in full stack and open source development.

This year Innotech has expanded to three other major metroplexes and tech hubs in Texas -- San Antonio, Dallas/Fort Worth, and Houston ...

Read More

Is it time for a newbie-hacker mentor for PostgreSQL.org?

At PostgresConf US 2018, Bruce Momjian, Grant Zhou, and I had a meeting to discuss potential opportunities for the Chinese PostgreSQL community to participate in the wider International community, including submitting patches to PostgreSQL.Org. Then at Postgres Open China the International Consultants Committee had a meeting to discuss more opportunities in depth. Between the two meetings there were a lot of ideas but one opportunity that was considered needs further discussion:

Volume

There are many volumes within the PostgreSQL community. Email volume (over 3000 emails to -hackers alone in the first 6 months of 2018), side channel volume, idea volume, and, arguably most important, code volume. The investment someone has to make in order to submit a feature to the ...

Read More

Went to Bejing for Postgres Open China and China Open Source, Open Source World

I spent the week of June 25th in Bejing, China with the outstanding Chinese Open Source and Postgres Communities. I was there to speak atboth Postgres Open China and the China Open Source World conferences as well as participate in a Chinese Open Source panel and the International Consultants committee meeting, of which I am the President. This was my first trip to Asia and it was amazing. The Chinese culture, hospitality, and friendliness was unparalleled, as was their drive to be more influential and helpful to the International Open Source and Postgres communities.

The entire week was spent trying to answer the question, “How can China participate more thoroughly in the International Open Source and Postgres communities?” We ...

Read More

The 401 on Silicon Valley Postgres

August 2017

We launched the Silicon Valley Postgres Meetup.

March 6th, 2018

We have reached 401 members in what is proving to be one of the fastest growing Postgres meetups in the United States. We launched the meetup along with Vancouver B.C., Denver, Salt Lake City, and Phoenix.

Between these and other meetups we help organize such as New York, Philly, and Dallas, we are reaching more people than ever in education, advocacy, and applicability of Postgres!

The increase of professional contribution

Why is this important? The majority of potential Postgres contributors are not part of the internal network of PostgreSQL.Org and other international organizations. They are developers, users, consultants, companies, project managers, documentation writers, etc. These professionals ...

Read More

December 2017 Update and News

PostgreSQL V10: An Amplified Version Of PostgreSQL

For more than a decade, the Postgres community has released new major versions almost annually to meet the evolving needs of the Database Industry. The first great release of Postgres was 8.3 in 2008, with a clean and evolutionary release of 8.4 eighteen months later.
The 2017 v10 release of Postgres is the first version that Command Prompt Inc. founder and lead consultant Joshua D. Drake would consider truly, “Enterprise Ready.” Read more


Command Prompt Inc. Joins the AWS Partner Network

With the recent advancements of AWS PostgreSQL instances and their Database Freedom initiative alluded to in Andy Jassy’s AWS re:Invent 2017 Keynote, more and more AWS customers are ...

Read More

Connection Initiation Overhead is Killing Your Web App - Use a Connection Pool

Customers often ask us what is the correct setting for max_connections on their PostgreSQL cluster?  There is a short answer to this question, and there is a very, very long answer. The short answer is: accept the default if that works for you, or try 10 times the number of CPU cores and see if that works ok.

There is another short answer which is: you may be asking the wrong question.

The original implicit assumption is "more connections will get me more throughput". This is often false. A question usually worth pursuing is "How can my existing set of connections be used efficiently?"

If you think that your application wants more connections and you are considering raising max_connections ...

Read More

Speaking and training at PGConf Austin

I leave this Sunday for beautiful and ecclectic Austin, Tx. I will be providing the training Postgres Performance and Maintenance as well as speaking on The Power of Postgres Replication. The training is one that I give several times a year but the Replication talk is new. Although I have spoke on replication before, this new presentation is all about the power of Logical Replication. If you would like to learn more, pick up a ticket and let's have some fun. If you can't make it to Austin, perhaps you can make it to the PGConf Mini: NYC on December 14th. I will be presenting the same Replication presentation at that event. Let's bring about the new ...

Read More

PostgreSQL v10: An Amplified Version of PostgreSQL

For more than a decade, the Postgres community has released new major versions almost annually to meet the evolving needs of the Database Industry. The first great release of Postgres was 8.3 in 2008, with a clean and evolutionary release of 8.4 eighteen months later. The 2017 v10 release of Postgres is the first version that I would consider truly, “Enterprise Ready.”

PostgreSQL has seen great success in the commercial enterprise for years. However, that success has largely been relegated to departmental success; e.g. the installation is solving a specific problem for a specific department. Often it’s the public facing data source for a larger Oracle instance or to manipulate GIS data. In these roles, PostgreSQL ...

Read More

Speaking at PGConf Seattle, are you going?

Jim Mlodgenski in attendence at the 9th Annual PGConf.EU and I am working hard on updating my slides for my presentation at PGConf Seattle. PGConf Seattle is being held at the downtown Seattle Sheraton on November 13th and 14th.  I will be speaking on Postgres version 10. I will also be training on Postgres Performance and Maintenance (you can buy your ticket here). If you are planning on attending my training or any of the others I recommend that you register quickly. There are only half a dozen seats left for mine and only a few more than that for Robert Bernier's.

The Postgres V10 presentation is the same presentation I gave at PGConf Ohio as well as ...

Read More

Postgres is better than MySQL but not because of how long it took to fix a bug

Many argue which is better: PostgreSQL or MySQL. A recent post by MySQL evangelist and community manager Frederic Descamps prompted some criticism of the amount of time that it took for a particular bug to be fixed -- 14.5 years to be exact, from the initial report.

There’s a long list of technical and performance comparisons, but here’s the number one reason to choose Postgres over MySQL.

Community Drives Change

The PostgreSQL community is different than MySQL. First, MySQL is not a project; it is a product. Yes, they are both Open Source but Postgres is vendor neutral, contributor centric, and not controlled by any single entity. Using a product or project defines the culture you are embracing when you ...

Read More

Copy Files Through an SSH Wormhole!

Here is a fun and useful Linux console hack you might like.

If you use ssh A LOT, maybe you encounter situations where you have a shell that is three or more hops removed your local workstation. And maybe you've been in the situation where there is some file that you need to get from "there" to "here" or vice versa. And you really are annoyed by the thought of scp-ing the file over 3+ hops (and not so lucky that all the keys and permissions in the pipeline enable easy piping through ssh).

Lucky you! In a moment of inspiration, I concocted this ultra-unixy hack to copy the file in ONE hop (more or less). Assuming the file ...

Read More

London PostgreSQL Meetup

Devrim Gunduz

One of the fantastic characteristics of Postgres leaders is their willingness to serve the community.

Yesterday I found out that one of our former team members, Devrim Gunduz, has created a new London PostgreSQL user group and they had their inaugural meeting in October. At the time of this writing there were 123 members in the group. This level of response shows a great demand for Postgres content. I spoke with Devrim yesterday, and he shared that he has a mission to provide the London community with new content each month. It is a bold goal as running meetups that frequently can be daunting, but we believe there is enough support in the area to warrant this frequency. Devrim has ...

Read More