24x7, 365 Enterprise services since 1997
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.
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?’
While I accept the premise that sharing your ‘weakness’ with family …
PgManage 1.0b2 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.
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.
Life is about people
The fifth and last in a series of blogs covering common mistakes in Database and Application designs for financial calculations.
There are many methods of rounding
The built-in method of rounding in PostgreSQL is Half Round Up. Unfortunately, it is not the best approach, …
The third in a series of blogs covering common mistakes in Database and Application designs for financial calculations.
When working with float data types, order of operations will affect the ending value.
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 …
The second in a series of blogs covering common mistakes in Database and Application designs for financial calculations.
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.