Blog

Validating a domain with Proton and Cloudflare

When setting up a personal domain in Proton mail you need to do quite a bit of DNS configurations: MX records, SPF records, DKIM records and DMARC records. When all is correct it looks like this And since moving my DNS to CloudFlare, mine was not OK, and I was getting email from proton telling me how my DNS config was incorrect! the solution Make sure that all DNS records in CloudFlare are not proxied (i. Read more...

Using stress to get more ideas fast

In her TED talk, Kelly McGonigal presents the case that stress is your friend (not too much). I have experienced how stress can be a valuable friend for ideation, the fancy term to describe having ideas. I found, that to have lots of ideas, a pre-requisite to have good ideas, you need a brainstorming session. I also found, that having a two minutes brainstorming session gets me roughly the same number of ideas than a two hours session. Read more...

Getting today and yesterday in AWS Athena (2024)

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...

AI and Education: Partnering for Creative Learning Adventures

AI is perfect for discovering kids’ (and adults’) talents and leveraging their amazing creativity. It works like this: We, as parents or teachers, pick a topic. We ask ChatGPT to write an essay on the topic, as a kid of that age would. Yes, you can ask ChatGPT to write as a 6-year-old or a 12-year-old. Print and share the content from ChatGPT with the kids and say, “Your task is to add value to this. Read more...

An AWS pricing website

In 2023 I created aws.frankcontrepois.com a website that generate graphs from AWS pricing data. The data is automatically updated every month. It was also my first time using ChatGPT to create CloudFormation scripts. note: the site is not encrypted because all the data is public and is a little greener by not requiring CPU cycles for useless encryption. Read more...

An AWS pricing investigation

In the last two years I have been playing with AWS pricing data, trying to answer questions like: What is the price of the Windows License on AWS? link What is the price of SQL server licenses on AWS? link Are there better price performance configurations to buy SQL server Licenses? link Don’t use 1 vcpu instance What is the price of RedHat licenses on AWS? link Are there better price performance configurations to buy RHEL ? Read more...

How to exclude running Google Analytics when running Hugo server

From: How to Exclude Google Analytics When Running Under Hugo Local Server from 2018 with love :) If you are not using a theme that already excludes Google Analytics, then you should use the following piece of hugo code. In my case, I added this code into layouts/partials/custom-header.html {{- if not .Site.IsServer -}} {{ template "_internal/google_analytics.html" . }} {{- end -}} Read more...

How to get a random number in bash

Use the $RANDOM. $RANDOM returns a number between 0 and 32767. To get a random number between 0 and 50 you can use $ echo $[RANDOM%50] $ # or $ echo $((RANDOM%50)) To get a random number between 1 and 50 you can use $ echo $[RANDOM%50+1] $ # or $ echo $((RANDOM%50+1)) Read more...

How to solve Outlook cannot parse the property 'TRIGGER'

This errors is due to what seems to be an incompatibility between Google calendar reminders and Outlook. I guess that Google uses some proprietary content in the iCal that Outlook does not manage. Result: I do not have reminders in Outlook :( but the otherwise the calendar works well. Read more...