Experts in Postgres and Open Source Infrastructure

24x7, 365 Enterprise services since 1997

Blog

The Importance of Language

After a short walk in the late afternoon sunshine, I found myself praising my noble steeds who come with me almost everywhere; aka my frenchtons. Moose, I’d argue the most sweet and stubborn frenchton, has Intervertebral Disk Disease (IVDD). This means most of what he does has to be monitored carefully as it takes more out of him and can lead to serious injury. It also means he and I …

How to Set Yourself Up for a Successful Meeting

There are a lot of mugs out there that say “I survived another meeting that should have been an email.” We’ve all been there, and more likely than not we have also facilitated meetings that others may throw in the “should have been an email” bucket. We’re busy and it happens. Meetings are constant, burdensome, and necessary. As a fellow survivor and bucket avoider, I’ve put together a few simple …

Embracing Wellness: Our Journey Begins

Introducing the Command Prompt Health & Mental Wellness campaign, a holistic approach to life.

An act of kindness for the PostgreSQL community

Since at least 2021 there has been a disagreement between Postgres related non-profit organizations. On one side are two affiliate non-profits for Postgresql.org; on the other is a relatively unknown non-profit out of Spain. Lines have been drawn, feet have dug in, and a lot of unproductive discourse has occurred. This has culminated in legal action, bad blood, and some poor decisions.

An update on the hunt for 195

On July 6th, I published, “A Transparency Moment”. There are a lot of us who would never publish such an article. ‘Your health is private,’ ‘won’t you be embarrassed,’ and ‘what if you fail?’ These are nagging thoughts and they are constant. ‘Should I publish another update?’ ‘What if I don’t make progress?’

Your health is private

While I accept the premise that sharing your ‘weakness’ with family …

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 …

Your work-life balance is killing you

To be truly successful in life, we must have an equilibrium. We must balance desire, learning from success and failure, fear, exhaustion, passion, employer satisfaction, relationships, children, personal ambition and growth, tee-ball games, disappointment, ballet classes, illness, client management, and unexpected events. How can we manage all of these tasks when we try to put everything into two separate boxes? We can’t and that is why people get burned out.

The issue of convenience

Life is about people

PostgreSQL and Financial Calculations - Part Five

The fifth and last in a series of blogs covering common mistakes in Database and Application designs for financial calculations.

Method of Rounding:

There are many methods of rounding

  1. Half Round Up
  2. Half Round Down
  3. Round Towards Zero
  4. Round Away from Zero
  5. Round Half To Even
  6. Round Half To Odd
  7. Random Round

The built-in method of rounding in PostgreSQL is Half Round Up. Unfortunately, it is not the best approach, …