Experts in Postgres and Open Source Infrastructure

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.

• Source: https://github.com/commandprompt/pgmanage
• Website and Binaries: https://commandprompt.com/products/pgmanage/
• Full Documentation: https://pgmanage.readthedocs.io/en/latest/
• Community: https://discord.gg/FvweAhhUeu
  
  

Major Changes from OmniDB

New features:

• new connection management UI
• added …

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, …

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

Database Driver, or Application Framework Created Error:

The database driver or application framework created errors are probably the hardest to find, as we are the consumer not the writer of the tool, with many assuming the casting is correct. However, we must review the documentation or the library’s code to know how …

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

Inconsistent precision scaling:

This is probably the most common mistake in database design that I observe. It is understood to use exact data types (such as numeric) and the precision must be fixed, but for whatever reason the decision is made that it’s OK for one table to use numeric(12,4),a second table …

When you have been around as long as Command Prompt, you are bound to forget blogs you wrote as well as the fact that those blogs are likely exceedingly outdated. I was recently doing a review of the Command Prompt Dead Sea Scrolls and have come across two that we have updated to be accurate for the modern times of PostgreSQL.

The blogs

• The Write Ahead Log: Essentials
• PostgreSQL Minimum …

In the 2017 article we referenced to /r/postgresql which at the time had 5,100 members. It now has 25.5k. In the same time period as pgsql-general, it generated 175 messages among community members (20 posts, 155 responses). Similarly, we mentioned the Slack channel which at the time had 1100+ members. It now hosts 18.3k subscribers with similar activity of the subreddit. The People, Postgres, Data Discord, which did not exist in 2017, has 3,579 members and is quite active over its 28 channels. The listed collaboration venues don’t take into account the thousands of members among the international or associated (Brazil, Russia, TimescaleDB, Yugabyte, NeonDB, etc…) Postgres communities.

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 …

Over the last 25 years we have interviewed hundreds of people to be a part of our team. As with any good interview, you allow candidates to ask questions about the business, how you operate, what your philosophy looks like, and hopefully what your plan for the future is. My favorite is, “What is something you tell every employee?” Our answer is always the same, “We are never afraid to fire a client” and the response is almost universally “that’s refreshing.”

I had an opportunity to sit down with Mark Porter, the CTO of MongoDB to discuss PostgreSQL, Aurora PostgreSQL and MongoDB. Mark is one of the creators of Aurora PostgreSQL and now enjoys a leadership role at MongoDB. There are two episodes:

• Engineering Culture
• The aha moment

It is important to reach out to leaders in communities to understand how they succeed. Mark has over 30 years of experience in …

As North America starts to reopen, the PostgresWorld webinar series continues to provide exceptional free content to the community. See below for the August webinars.