Frank Contrepois

Category: learning in public

Getting today and yesterday in AWS Athena (2024)

Posted:   |   Categories: learning in public

Interesting links 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 Getting today and yesterday in AWS Athena Dates are always a pain to manage. SQL is no exception with every database doing their way. Today I talk about AWS Athena where the date/time documentation is here, not on the AWS website but the presto one. Read more...

How to split camel or pascal case in bash

Posted:   |   Categories: learning in public

Sometime you get names like “helloMyNameIsFrank” (Camel case) or “HelloMyNameIsFrank” (Pascal case) and you want to make them human readable. In bash you can use sed 's/\([A-Z]\)/ \1/g' Example $ text="helloMyNameIsFrank" $echo $text | sed 's/\([A-Z]\)/ \1/g' hello My Name Is Frank Read more...

Learning in public - Work life balance

Posted:   |   Categories: learning in public

Today in #learninginpublic we think about work life balance. Work life balance would imply that they are in opposition, but there is only life. No matter the amount of yoga, problems at work will not disapear without intervention at work. This is from a Simon Sinek interview with TED. The evergreen article Read more...

Learning in public - when you are late don't rush

Posted:   |   Categories: learning in public

Today in #learninginpublic, something I can be good at. zt - when you are late don’t rush - My second brain When you are running late, it’s important to stay calm and avoid rushing. Being just a few minutes late, whether it’s 5, 10, or 15 minutes, is still considered being late. There’s no need to make the situation worse by panicking and rushing." (My sentence improved by chatGPT) Read more...