A Guide for Solutions Architects. — Athena is a fantastic serverless tool that lets you interactively query data stored on S3. Still, many applications store data on databases, and sometimes, they can’t even put them on S3 buckets for long to respect regulatory reasons. …

Create one, step-by-step! — AWS Glue Crawlers are automated processes that traverse the data source, extract metadata, identify data formats, and create table definitions in the AWS Glue Data Catalogue. Some of the crawler’s main functionalities include: Automated Schema Discovery. Schema Evolution ( detecting data changes ). Central Metadata Repository usable by other services…

This is a quick walk-through to create an RDS connection in Glue. — This is part of an article to connect Athena to an RDS Postgres; subscribe to be notified when article publishes! Creating an RDS connector in Glue is easy: Step 1. Go to AWS Glue and click on Connections menu.

Step-by-step: connect the data source through the AWS console. — Intro. This document assumes that you already have a PostgreSQL RDS instance (SQL and other engines are very similar) and have set up all the required networking capabilities, and have gathered the following connection credentials. If not, please follow this guide to set up your RDS using CDK or this or…

Part 1 of the series of CDK Infrastructure As Code (IAC) — Embarking on a project with AWS CDK to query a PostgreSQL RDS database using Athena? You might find, like I did, that the journey is not as straightforward as it seems, especially with the existing gaps in AWS documentation. But worry not! I’ve simplified the process for you in this…

A Timely Voyage Beyond Uncertainty. — In QM ( Quantum Mechanics ), the Heisenberg Uncertainty Principle is a fundamental concept that states that it is impossible to simultaneously know both the exact position and the exact momentum of a particle; the more precisely one property is known, the less precisely the other can be known. Δx…

A Guide to Solve Error 2 when uploading to ESP32s with new chips on the latest versions of MacOS. — Pretex! Let me cut to the chase, I bought a couple of new ESP32s (because I fried the ones I had) but soon learned that I couldn’t upload to them. Did some research and learned that there is a new driver, so I found it and installed it, but it didn’t help! So…

Yet another theory of how Earth’s moon was created. — TLDR; Earth’s wobble could have played a role in the Moon’s formation through an intense Dzhanibekov effect. This idea, though unconventional, can be tested and explored further. Imagine the early Earth, partially molten, unbalanced, and unstable, experiencing a dramatic Dzhanibekov correction effect. This intense event causes a massive chunk to break off…

Hidden AI Threat Everyone’s Ignoring! — Countless articles explore the potential of artificial intelligence (AI) to replace jobs, disrupt the economy, threaten user privacy, and misuse copyrighted content. While these concerns are valid, they fade in the face of my greatest AI-related fear. …