4 ms·
Interesting article and at the bottom he mentions "You can try out Row Zero without signing up (I love when apps let you do that)." You know what, I love that
by cdchn 3y ago
Interesting article and at the bottom he mentions "You can try out Row Zero without signing up (I love when apps let you do that)." You know what, I love that too! Let me try it. Lets see how it does with the AWS EC2 Pricing List for us-east-1. 229Mb and 320k rows. To say it was shocking how fast it loaded might be an understatement. Google Sheets (although it looks like it has _much_ more functionality as far as spreadsheets go) absolutely chugs trying to load a third of this data.
- simonw 3y agoWhere can I get that 229MB file? Sounds like a fun test set.
- cdchn 3y agoIf you install the awscli and configure it to connect to your account then "aws pricing list-price-lists --service-code AmazonEC2 --currency-code USD --effective-date <today>" to get the price-list ARN then "aws pricing get-price-list-file-url <arn> --file-format csv --region us-east-1" to get the URL to download it.
- zote 3y agoalternatively a direct download[1] https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonEC2/current/us-east-2/index.csv https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/Amaz... [1] edit the link[1] was for east-2 prices, here are east-1 ec2 prices[2] https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonEC2/current/us-east-1/index.csv https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/Amaz... [2]