I feel that if the goal was to achieve flow we would all be a lot happier.  As long as there are hard (but artificial) deadlines on which people's performance...

When using an AWS RDS instance the file option of the COPY statement is not supported, however you can use STDIN.

cat my_file.csv|psql -c "copy my_schema.my_table(id,name,description) from STDIN...

Cashflow is a killer for a startup too.  I know of one large company that insists on 9o day terms from their suppliers.  That automatically precludes most startups.  Some companies...

Much of public perception comes from press coverage.  The press tend to sensationalise stuff in order to sell their content.

Other perceptions come from 3rd party conversations.  I can't recall anyone...

Amen

In the old days my hearing aids had an on off switch.  These days they...

I write for my future self and colleagues and see documentation as being part of my duties as a principal engineer.  That said I do make it easier for myself...

For me there are two definite use cases for document DBs.

• Prototype apps
• Anything where you would use an entity-attribute-value model.

I've mentioned before that when I first started looking at...

With sabbaticals is it unpaid leave?  For much of my career I would not have been in a position to take such an option.

If it is written in GO then that language has a nice balance of ease of use, speed of compilation, speed of execution, and testability.

If anyone was wondering what to...

Calendar and Clock tables make life a lot easier when used as part of a Dimensional model.  Especially if it is implemented in a column store.

If you've seen the queries...

It takes time for people to understand a new feature, what benefits it will bring and at what cost.  It is not always easy for a technical person and a...

Interesting reading this in 2023.  I've seen a few cases where PostGres has quietly recaptured ground previously taken by NOSQL solutions.

I've seen people champion certain NOSQL solutions and then implement...

I find that a major challenge is getting fast running local tests in place.  In AWS there is the moto library that mocks may of the objects covered by the...

Good article.

Perhaps expanding on it with more details of IAM users, roles, policies and groups?

There is also the security group and network ACLs coupled with VPCs and subnets.

Losing staff is like suffering an organisational brain injury.  In most cases the effect is minor akin to a memory lapse and the knowledge is still there, just not residing...