Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am developing a freelancing platform for certain professionals. I was thinking of utilizing the AWS DynamoDB for logging user activity (like posting a job, editing a job etc).

Fields would be

user_id | ip_address | timestamp | data

I would be querying DynamoDB for the following information:

  1. Log of certain user's activity.
  2. Log of all the user activity performed on a certain day.

And the information will have to be saved and accessible for a long time (forever?).

How good would DynamoDB be, for this kind of use case?

share|improve this question

1 Answer 1

DynamoDB is meant for high-performance retrieval. It internally uses SSD drive so that the storage price of DynamoDB might be a bit expensive for a "forever" data storage when coming to high volumes.

This said, your use case appears to fit perfectly DynamoDB. If you only need what you said, I would recommend this schema:

  • hash_key = <user_id>:YYYY-MM-DD
  • range_key = full_ISO_8601_timestamp
  • ip_address
  • data

ISO_8601 is always a good idea if you need to sort the dates.

I suggest to append the date to the user_id to make queries easier and keep things logically grouped but it will complexify more advanced queries. This may be avoided by using BETWEEN filter of ``Query

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.