Hi, my name is Austin Gil.
I'm a web developer from Portland, Oregon.
Over the last ten years, I’ve built projects for award-winning agencies, innovative start-ups, government organizations, and more.
OK, I figured as much. I wonder if there is a way to do something like DynamoDB where you would pass the ID to start after. So rather than an offset, you tell the DB like "get me the next 10 posts starting after this ID" but the ID is not like an integer.
Hi, my name is Austin Gil.
I'm a web developer from Portland, Oregon.
Over the last ten years, I’ve built projects for award-winning agencies, innovative start-ups, government organizations, and more.
Yeah. Im not sure it's possible with SQL. Part of the reason Dynamo is so fast is due to the way it looks up data, but it also makes it very restricting on how you access that data and plan your primary keys. So far I still prefer SQL, but it's good to know about the strengths and weaknesses
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
OK, I figured as much. I wonder if there is a way to do something like DynamoDB where you would pass the ID to start after. So rather than an offset, you tell the DB like "get me the next 10 posts starting after this ID" but the ID is not like an integer.
That would be pretty interesting! I'll have to look up that feature in Dynamo
Yeah. Im not sure it's possible with SQL. Part of the reason Dynamo is so fast is due to the way it looks up data, but it also makes it very restricting on how you access that data and plan your primary keys. So far I still prefer SQL, but it's good to know about the strengths and weaknesses