AWS has a lot of great services, that is true. But sometimes integrations between them look more like a result of a hackathon project. One of those is the Access logs of the AWS Amplify websites. In this set of posts, I will show you, at first how you can quickly analyze the logs locally with some common tools, and later how you can set up a flow of exporting logs to S3, running SQL queries with Athena, and send automated emails with the daily reports.| www.outcoldman.com
Suppose you want to analyze web traffic properly. A lot of time, you want to know the GEO origin of the requests. It is possible to map IP addresses to Locations. You can use MaxMind GeoIP tables. MaxMind provides a free version of their Lite tables that they update weekly. In this post, we create a Lambda function, which we run on schedule every 7 days (weekly). This function uploads the latest tables (CSV files) to S3 from MaxMind. We use these CSV files as sources for AWS Athena tables to ...| www.outcoldman.com
It is incredible. You can actually play AAA games on your Mac that require DirectX12. Diablo IV is one of them. I am able to play Diablo IV on my maxed-out MacBook Pro 16" 2023 with M2 Max 96Gb of RAM. Don’t want to get credit on that, as I have found an almost working for me solution on r/macgaming. Prerequisites I am running the latest macOS 14 (Sonoma), but some people mentioned that it might work on macOS Ventura as well. You need to have an Apple Silicon Mac, as it will not work on Int...| www.outcoldman.com
I have been using Macbook Pro with M1 since the release of the MBP 13" M1 in 2020. And I am huge fan of the new Apple CPU - M1. Time to time I need to do some work on my 2019 16" MBP with Intel Processor (all maxed out), so I keep experience the difference between using those two. On MBP with M1 I can definitely see that the macOS works way more smooth. No more glitches or frozen screens for a few seconds, less heat, less time I hear the fans work. And a lot of work you can do on just single ...| www.outcoldman.com
I love building developer tools and utilities. And, I believe the reason is simple, because I am a developer, and those tools I make, I create first of all for myself. I worked for Microsoft before on Visual Studio. I worked in Splunk on some work related to the developers (App Platform). I can say that I had some experience building developer tools by learning from large corporations. For the last 3-4 years, I work for myself. Build a successful B2B company, and now I have the flexibility so...| www.outcoldman.com
In the last three and a half months, I kept enjoying my MacBook Pro 13" M1, battery life, performance; everything is on the top level. But I also have an MBP 16 2019 that I have been using for development before. This Mac is a top-loaded MBP that I could buy at that time with the price of close to $5,000. I tried to sell it, but most folks are trying to lowball me to 2,000. The Apple Trade-In program is also willing to give me $1,750 for the laptop I bought a little over a year ago.| www.outcoldman.com
I wrote two parts about how you can analyze the Access Logs from AWS Amplify. And it was a time to write a third part of the series. But after touching AWS QuickSight again (I use it for Outcold Solutions) I realized that I don’t want to go through configuring it. As it is purely drag and drop way of building dashboards, and I am not very happy with that. Another option was to use AWS SES with lambdas to run SQL over Athena and send reports as CSV or nicely formatted emails with AWS SES. Bu...| www.outcoldman.com
I have been using Alfred for a long time. If you have not heard about Alfred, the short description is a Spotlight on steroids. It can do a lot, but you have to write your own Workflows or find if somebody already built it to use some of the really cool features. And I wrote some a long time ago, but to be honest, lately, I noticed that I don’t use it much, except to open applications and a few workflows. And the Spotlight improved significantly with the last few versions of MacOS. So I hav...| www.outcoldman.com
We discussed how to download AWS Amplify access logs and analyze them locally in the first part. In this part, we will configure a constant flow of access logs to S3 storage and create AWS Athena tables to analyze the logs. To constantly upload access logs to S3, we will use a Lambda function that we will call hourly. We will partition the data daily, which will allow us to store data for years and efficiently use AWS Athena (See Partitioning Data). Because we will keep data partitioned, we w...| www.outcoldman.com