Use DynamoDB

[saifahn]

Overview

In the future, it would be great to go serverless and not have to run a database on a server. I think DynamoDB would be a good option, and pretty good as a stepping stone in moving off of AWS.

[saifahn]

2021-12-15

I think I should actually address this as the most pressing issue so I don't have to write the implementation for Redis for all of the new things I'm planning on implementing.

Tasks

• [x] Set up a local DynamoDB instance for development
• [x] Play around with the AWS SDK for Go and the DynamoDB package
• [ ] Implement the existing store functions for DynamoDB
• [ ] Link it up with the real DynamoDB
• [ ] Run on EC2 and see if it works

[saifahn]

2021-12-19

• [ ] Tests for dynamodb implementation
  • [ ] Create Table struct with DynamoDB, Name, keys as properties
  • [ ] see if there is something like dynamodbiface for mocking/testing in SDK v2
  • Although, now I am thinking I should just use this package
• [ ] Implement the Users table
• [ ] the Transactions table

Resources

• AWS Go SDK v2 DynamoDB examples

[saifahn]

2022-01-12

• [ ] setting up the client with some variables for local DynamoDB but also for real dynamodb
  • [ ] adding the various functions onto the DynamoDB struct
  • [ ] how will I get all users for example?
    • needs a bit more reading into how dynamodb works

[saifahn]

• GetExpense
  • GetItem in the transactions table
• GetExpensesByUsername
  • GetItem in the users table to get the userid
  • Query in the transactions table to get the items
• GetAllExpenses
  • I don't think we actually need this, but I can do it via Scan
• CreateExpense
  • PutItem into users table
• CreateUser
  • PutItem into users table
• GetUser
  • GetItem from users table from the id
• GetAllUsers
  • Scan the users table