Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

PostgreSQL 18: Revolutionary Performance Boost Now Available

The PostgreSQL Global Development Group has released PostgreSQL 18, delivering the most significant performance improvements in recent years. This latest version transforms database I/O operations and streamlines the upgrade experience for organizations worldwide.

PgManage 1.3.1: Enterprise Edition Released

PgManage 1.3.1 is now available with fixes across PostgreSQL, Oracle, MariaDB, and SQLite3, plus updated dependencies and UI refinements. Learn what’s new and explore PgManage Enterprise Edition with remote access, multi-user support, and OAuth2 integration.

Upgrading PostgreSQL and Citus for Enhanced Database Functionality

Discover how a client successfully upgraded PostgreSQL 11 to 15.5 and Citus 8.3 to 12.1 while simplifying extensions, improving scalability, and enhancing performance. This real-world case study highlights the planning, testing, and expertise required to achieve seamless upgrades in distributed environments.

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.

PgManage 1.0 Released

PgManage 1.0 released, grab it today!

PgManage 1.0b2 released

PgManage 1.0b2 released.

PgManage 1.0b released

Command Prompt is pleased to announce PgManage version 1.0b. This release adds two major features, 3 major bug fixes and over a dozen changes and improvements. PgManage is a Postgres centered multi-database management Open Source project.

New features:

  • Added backup/restore support for PostgreSQL
  • First version of PgManage Handbook was published to https://pgmanage.readthedocs.io/en/latest

Major Bugs fixed:

  • Fixed .AppImage compatibility issues for newer Linux distributions which do not have libcrypt installed
  • Added …

Announcing PgManage 1.0a

PgManage is a Postgres centered multi-database management Open Source project. It is a fork of the previously well received project OmniDB that had been abandoned. Command Prompt has taken the helm of this project to ensure a quality project focused on the Management of PostgreSQL and related technologies.

Major Changes from OmniDB

New features:

  • new connection management UI
  • added …

PostgreSQL and Financial Calculations - Part One

A series on the use of data types to insure accurate financial calculations with your application.

Over my multi-decade career, I have often noticed the problematic use of real, floating, double, and fixed precision types to store and calculate financials. Most believe the application only needs two digits to the right of the decimal point for financial data. The use of only two digits assumes that many financial calculations do …

PostgresConf Silicon Valley 2022, anticipated talks

On Thursday and Friday of this week we will be enjoying 90 degree weather and sunshine in San Jose, California. It will be quite the change from the dark and damp of NW Washington. This is also the first time I will have been on an airplane in almost 3 years. Yes, it really has been that long since the world decided to begin a pandemic. That said, I am …