PgManage 1.0b2 released.
Blog
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
- Half Round Up
- Half Round Down
- Round Towards Zero
- Round Away from Zero
- Round Half To Even
- Round Half To Odd
- Random Round
The built-in method of rounding in PostgreSQL is Half Round Up. Unfortunately, it is not the best approach, …
PostgreSQL and Financial Calculations - Part Three
The third in a series of blogs covering common mistakes in Database and Application designs for financial calculations.
Order of Operations and Storing Aggregate Results:
When working with float data types, order of operations will affect the ending value.
Consider 3:
Python3:
justin@Debian10:~$ python3
Python 3.7.3 (default, Jul 25 2020, 13:03:44)
>>> (1234.567 * 3.333333) + (1.234567 * 3.333333)
4119.338,144,732,812
>>> (1234.567 + 1.234567 ) * 3.333333 …
PostgreSQL and Financial Calculations - Part Two
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 …
Recent blog updates
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
When is it time to fire a client?
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.”
Top 5 Reasons to Move to a Peer Review Focused Business
At Command Prompt, we rely heavily on peer review for the success of our clients. We believe that the best quality work is provided when there is no silo and when team work, no matter how much or how little, is a part of the day-to-day. When a group of individuals is encouraged to work together in an effort to provide high quality work and learn from each other, you’re …