πŸ‘ˆπŸΌ πŸ•ΈπŸ’ πŸ‘‰πŸΌ
Skip to main content

April 11, 2018

 

TIL @Delta has a policy that you can't switch seats w/ your partner if you've been upgraded. When I travel w/ my wife I like to let her take the seat for a part of the flight. Invariably, the kids want us to switch back later. Silly policy.

 
 

I now travel with a mechanical keyboard, making me the worst person. I totally blame @slashclee.

 

Been thinking a lot lately about my website's data storage. Currently, its in MySQL on RDS, but its a bit of a mismatch. In the future, I'd prefer to just be storing JSON documents that are easily indexed and searched.

 

I've considered using DynamoDB, but its designed for massive scale, and requires a fair amount of tweaking and fiddling. Overkill. I could just store everything in S3, and build indexes manually, but that seems inefficient.

 

I'm coming around to sticking with RDS, but maybe switching to PostgreSQL with its native JSON functionality. Still, I wish there was a simple JSON document database for AWS, which was backed by S3 storage, available as a service.

 

Interestingly, the "Object Tagging" features added to S3 in 2017 make it very close to what I am looking for as a simple JSON DB. That said, afaict you can't yet query for objects in a bucket that have a certain key/value tag. /cc @awscloud