Blog

How to get the number of columns in one or more athena tables

Enjoy SELECT table_name, COUNT(*) FROM information_schema.columns AS columns_number GROUP BY table_name ORDER BY 2 desc Other articles for databases geeks Using Athena from the AWS CLI on Linux Getting today in Athena Getting today in PostgreSQL How to get the metadata of AWS Athena tables Get the number of columns in an AWS Athena table Read more...

5 ways to forecast your cloud spend

5 ways to forecast your cloud spend Why do you need to forecast? In every company there is a need to plan for future flows of money, and IT is no exception. Before the Cloud, IT spend was driven by people costs, hardware costs, and maintenance costs, each of which is stable under change management (i.e. you need authorisations to change things). Then, one day cloud is used and the costs are less predictable. Read more...

[FUN] The 80-20 rule for toothpaste

The Pareto principle specifies that 80% of consequences come from 20% of the causes. This is true for toothpaste, I use 80% of of my time to get 20% of the paste. Same for printer ink, I do 80% of the prints with 20% of the ink. :) Read more...

[FUN] IT expertise at 3yo

I live in the UK, I setup the Netfix profile of my 3 yo to be in French, so he gets cartoons in French and if not available in English. That was the plan. So why do I hear Japanese? I mean really Japanese, this is Hacking by a 3yo. brilliant. Read more...

[FUN] Paper vs Phone

Paper wins, obviously lighter, faster (paper speed), faster to get hold off, 0ms to load, a pen recharge last months if not years, ecologic and recyclible no-one tries to get your attention using big red dots with numbers if it falls it does not break useful on both sides can be used for async chat. But that costs some money for stamps Read more...

Paper Speed

Many times, I have an idea and the time it takes to get my phone, fire the text app, a be ready, the idea is gone. The only way to keep track of the idea is to use paper speed, pick a pen a paper and write that single word that will unfold the thought. So here I’m with phones now costing $1000+ using pen and paper. For that use case, it still rules! Read more...