Implementing a Table Create & View Update in Athena using AWS Lambda
01 February 2022
I have a DynamoDB table that is automatically exported as JSON to
compute some reports. I wanted to automate the table creation process
and load steps. Amazon Athena allows querying from raw files stored on
S3, which allows reporting when a full database would be too expensive
to run because it’s reports are only needed a low percentage of the time
or a full database is not required. It’s billed by the amount of data
scanned, which makes it relatively cheap for my use case.
Search Suggestions on My Website
27 July 2021
I previously talked about the search engine I recently added to my
blog, and this is an extension to that previous post. Here I will
discuss how I added a simple search suggestion option. It works for my
website with the limited vocabulary and time to return results, but if I
was working on a larger site I might try to make it smarter. So here’s
how I implemented it.
Adding Search to My Static Blog Using AWS Lambda and SQLite
09 July 2021
I always wanted to have search on my site, but it’s statically hosted,
so I can’t have any dynamic content on it. I recently resolved that by
creating a little tiny lambda function on AWS that queries a SQLite
database hosted on S3. Here I’ll walk you through how I created the
back-end for it, and in some later posts I’ll include details on
calculating the cost.
Adding `pylint` to your Github Actions flow
21 January 2021
Recently, I’ve been doing more CICD work, so I wanted to practice adding
some of that to my personal projects. I’ve also taken a liking to
pylint, so I decided to have Github Actions automatically
check my code quality on push for my log-analysis
repository. This is how I added that linting to my workflow.
PyGame FFT Audio Visualizations
07 January 2021
This tutorial is to write a very simple audio visualizer using
PyGame, PyAudio, and Numpy. The visualization uses the
frequency domain of some input sound, and display a bar graph of the
frequency domain as the audio plays. The audio source is the computer
line-in or microphone.