bjorn248/graphql_aws_pricing_api

AWS Pricing API. Used to power terraform-cashier.

graphql_aws_pricing_api's Issues

Update to the latest express-graphql

Maybe it's faster/better

Migrate to CockroachDB

Tested a working POC and it seemed to work wonderfully. I've committed to migrating to cockroach as my primary database.

Support OR queries

Need some way to do more than just AND...

Investigate CockroachDB as a backend

Trying to get away from RDS if possible, just to save on cost.

This seems to be entirely broken at the moment for EC2 pricing

Investigate

Fix Resolve function mapping for IngestionServiceSnowball

The resolve function for IngestionServiceSnowball is not mapping back to existing table/field names. This is because of the temporary fix implemented to get EC2 pricing back up.

Don't run things as root inside the local dev containers

Because we want to be the change we want to see in the world

Pull in Import script from other git repo

So I don't have duplicate code.

Migrate to node 16

Node 12 is reaching EOL, need to upgrade

Generate Schema Documentation

So that people know what the queryable fields are...need an easy way to generate Markdown documentation from the GraphQL schema. Might add an environment variable to do that for me.

Set up github action to deploy to lambda, trigger assertible

Update README

With usage information. Public endpoint as well as how to use aliases to get multiple data points at once (how cashier actually uses it)

Investigate GCP SQL to save cost

https://cloud.google.com/sql

Investigate Athena as a backend

AWS Athena seems like a good fit for querying this type of data, instead of having to have an RDS instance always running.

Troubleshoot lambda cold-start behavior

After upgrading a few of the modules and redeploying to lambda, it seems that the lamba function experiences cold-start behavior during every invocation. In the past, only the first request would take 14+ seconds, and then subsequent requests would take 1-4 seconds.

Remove importer script from repo

Instead, dockerfile should grab the raw script from the other github repo that has the latest import script. Github repo found here: https://github.com/Bjorn248/aws_pricing_data_ingestor/

Investigate why incorrect price is returned for r4.large

The importer script has been running, and directly connecting to the DB confirms that the correct value is present. Also, running the API locally seems to work. However, the live lambda returns 0.1482 instead of 0.133

Switch from RDS to Heroku ClearDB MySQL to save cost

RDS costs money, Heroku ClearDB MySQL has a more generous free tier. Investigate, and possibly switch.

Implement serverless framework

Use serverless framework (https://serverless.com/) for this project. It will make development and deployment to lambda much easier.

Make docker-compose use user-defined networks instead of links

See https://docs.docker.com/compose/networking/#specify-custom-networks

Wouldn't want to use things that are on the chopping block of deprecation