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
data.
I actually created a sqlite database to track exactly how long I worked at
various jobs. I created this database, because I don’t trust the payroll
system we use at work. I will share the schema and views in this post. If
you don’t want to read through this post you can get it here.