Does any AWS service or solution offer sequence functionality similar to SQL Sequences as found in Postgres or Oracle (or any other RDBMS), without having to maintain an entire Postgres instance?
I do have access to RDS if needed, but I'm wondering if it's overkill just for one sequence and whether theres a simpler/cheaper solution.
Ideally the sequence would be 8 digit numbers, and not needed at a particularly high volume (just a few thousand per day).
Edit: Possible duplicate of Distributed sequence number generation?
Edit 2: To clarify, the goal is to have uniqueness, with simple numbers. Number order is not important, as long as they are unique.
If you are okay with simply having unique IDs (without being sequential), AWS Key Management Service (KMS) has a GenerateRandom function. The chance of duplication is very small.
Or, you could go with a traditional GUID/UUID.
However, if you want the IDs to be sequential, then you will need somewhere to store the value:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With