Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

The Freedom to Choose: Why Vendor-Neutral Consulting Matters

Background

On a recent call, a potential client shared their frustrations with the high costs and limitations of their managed services cloud platform. While reaching out to potential support providers, they often encountered companies that only supported PostgreSQL's community edition or pushed their closed-source editions. This experience highlighted the need for a consulting partner who takes a vendor-neutral approach.

Command Prompt prides itself on integrity, discipline, and excellence. We’re straight …

Navigating Compliance in Regulated Industries

Command Prompt: Your U.S.-Based Partner for Navigating Compliance in Regulated Industries

The PostgreSQL Roadmap: Understanding Milestones in Versioning, Features, and Upgrades

PostgreSQL Roadmap

PostgreSQL is an open-source, feature-rich, and highly extensible relational database system used globally across countless sectors. Over the years, it has grown significantly with each release, becoming one of the most reliable databases for developers and enterprises. Let’s explore the PostgreSQL roadmap, focusing on its major version changes, key features introduced in newer releases, use cases, and why upgrading is essential for better stability and performance.

PostgreSQL's Naming Convention Shift: …

PgManage 1.2 Released

PgManage 1.2 Dashboard

The latest version of PgManage has been released! PgManage 1.2 Release introduces new features and improvements, and addresses several bugs reported since the last release. Please update to the latest version at your earliest convenience.

New features:

  • Implemented support for adding/changing table indexes in Schema Editor
  • Implemented Postgres role editor
  • Added SQL error annotations in the query editor
  • Significant code completion improvements: added context-aware schema, table, view, column and function …

Pinpointing, Planning, and Roadmapping Future Software Updates: Why It Matters

Planning and road-mapping updates not only address immediate issues but also contribute to long-term stability and security, helping your organization avoid major headaches down the road.

Upgrade Your PostgreSQL Version to Ensure Stability and Security

The PostgreSQL Global Development Group recently released important updates for several supported PostgreSQL versions, including 16.4, 15.8, 14.13, 13.16, 12.20, as well as the 17 Beta 3. One security vulnerability and over 55 bugs were addressed, many of which affect PostgreSQL 16 and other supported versions.

11 Essential Tips to Maximize The Summer Slowdown for a Productive Fall

As the summer winds down, many of us have experienced a professional lull with school breaks and summer vacations.

This transition offers a golden opportunity to prepare for a successful fall. Our team of System Admins and DBAs has compiled top strategies to make the most of this period:

  1. Plan and roadmap future updates.
  2. Determine which OS updates you’ve been putting off and do them
    1. Execute pending OS and database …

PgManage 1.1 Released

PgManage 1.1, a usable Open Source Postgres manager, has been released

PgManage 1.0 Released

PgManage 1.0 released, grab it today!

Less is More

Sometimes, after using a tool for many years, you will discover a feature that totally changes how you do things. When it is a fundamental tool like “less”, it changes how you interact with many command line programs in Linux*.

Did you know that less can do far more than just press space to advance to the next page? I sure didn’t. Then one day I went down the rabbit …