Posts Tagged “programming”
Things that are related to programming or development.
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.
Exporting the AWS ReInvent Calendar to iCal
23 November 2021
I went to AWS Reinvent this year, and I wanted my registered events to
show up on my personal calendar. I’m honestly surprised they didn’t
implement an iCal export for your registered events. So I took these
steps to get them.
Programming Practice Sites I Like
15 November 2021
I’m not a huge fan of hacker rank and it’s use in our industry. I find
the problems to be boring and repetitive, so I’m listing out some of my
preferred practice sites as a couple of alternatives with more fun and
more interesting problems. I will concede that hacker rank does have
excellent SQL practice though. They are the only ones I found with some
really good problems and a variety in engines. Enough of that though,
let’s jump into some of the ones I like better.
TIL my site is a JAMStack site.
10 September 2021
Today I learned that my site which has been basically the same since
2016 is a JAMStack site. Although it was coined in 2015 by
Netlify, it seems to have become really popular in the past 2 years as a
term. I’m told it’s more of a theoretical framework than anything else.
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.
The Problem with Regex Search and Replace in Java
15 July 2021
I had an issue where I needed to support
search and replace of certain quoted strings in various scripts which take the
form of $(VARNAME). There’s a minor issue with Java where if the replaced by
string contains certain characters where it will quit with an unhelpful message
like “IndexNotFound: Match group 5 not found” or something similar. This is how to
resolve that error, and the importance of escaping things.
Using a Bash Script to Generate Random Fake Data To Insert Into DynamoDB
30 March 2021
I’ve been studying for my developer associate certification on Amazon
Web Services. I’ve been practicing with the various streaming solutions
like SQS and Kinesis lately. I’ve wanted to branch into using DynamoDB
and capturing changes. To do that I needed to generate a lot of take
15 March 2021
be converted to numbers. It’s a very cool feature but can cause a lot of
pain because adding 1 doesn’t always do what you think it should due to
type-juggling. So you might think there’s an easy and relatively
foot-gun free to convert an array of strings to numbers. You would be
wrong, well maybe not at least if you don’t use the functional language
that’s besides the point.
Interactive Breadth First Search in a Grid
20 December 2020
Breadth first search(BFS) is a very powerful and useful algorithm for
exploring graph like structures. A BFS searches it’s nearest neighbors first
before moving on. It’s main use is to find a path using
the fewest hops. Here we use it to explore a grid that can be modified
by a user. In this grid, we have verticies (the grid boxes), and edges
(the box north, south, east and west).
Lights Out Game
29 July 2020
Shown below is a lights out kind of game. Scores are not tracked or anything
it’s just something meant for fun. The goal is to get the board either completely
lit up or completely black. It inverts the color of whatever you click on and those directly adjacent squares. Those squares directly to the north, south, east and west.
My Relative Credit Card Spend
03 January 2019
I’ve had a credit card now for about 2 years, so I thought I would make
a cool visualization that shows my relative spend through out the year
on a daily basis. I think this plot came out to be relatively cool.
Reimplementing the Tree Command
30 September 2018
I decided I’m going to try to reimplement the tree utility from
scratch in a very limited version. Mine will only work from the current
directory and will support no arguments. This article will take you
through my implementation of the problem.
A Brief Introduction to AWK
30 December 2017
This will be brief introduction to awk and it’s many uses. I will show a
few brief segments about various uses of awk and when it comes in handy
for certain tasks. For more detail one should read the
Awk User’s Manual.
CyberSeed 2017 - Application Security
21 October 2017
I recently competed at the 4th Cyberseed event at UConn in the
application development competition. The challenge was to build a secure
application according to specific specifications before the competition. Then
the individual teams would attack each others apps in order to collect various
flags placed in our apps. This year was the first for this particular event,
and the challenge was to build a secure medical repository. The teams were
then given the source for each others apps a couple of days before the event.
This event was a lot of fun and lead to a lot of lessons about secure app
development for me.
Finding the Largest File Stored in Your Git Repository
30 January 2017
This command will find the largest file from the output of git ls-files
which outputs the path to each of the files stored in git below your
Calculating the Size of Your Video Library
07 December 2016
This command will calculate the size of your movie and video library in
days. You can modify the awk command as you see fit to calculate the time
07 November 2016
I was counting some coins and was wondering if some coins should be
produced more frequently because they would be used more often so I wrote
an minimized change count algorithm to decide if certain coins should be
produced more often.
Sine-Cosine Demo App
06 September 2016
I had to create a sine-cosine demonstrator for a class, this is that demo.
A SQLite Tutorial
24 May 2015
This is my in-depth SQLite tutorial for C++. This is the first
tutorial I am doing on this website. It is really difficult to find a good
tutorial for prepared statements with SQLite, and that is what this tutorial