24x7, 365 Enterprise services since 1997
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.
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.”
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 …
Command Prompt has been providing infrastructure support to enterprises for over 20 years. As we are the only Postgres company still operating since the 90s, how is it that we’ve stayed standing? The answer is simple; we as a company and as a community firmly believe in the power of professional development. We frequently encourage everyone in our team, from interns to owners, to continue to learn and grow, both …
Now that it’s been over a year, we thought it would be good to revisit the How to Achieve Success When Working From Home blog from March 2020. The idea of the original post was to help those who were challenged by the new work-from-home environment by sharing the knowledge that we’ve gathered over 15 years of working from home ourselves. Much has changed since that post was published, and …