d
Topic
Alex B Shopify Employee
Posts:
34
8 months ago
g
1
upvotes

Shop IDs now exceed 32-bit integer max value This post is outdated

Hey Developers!

Back in 2013, Shopify started to transition its ID columns from 32-bit to 64-bit in order to handle the sheer amount of data we process. This post is a reminder of all the great advice from that thread, as recently generated shop IDs have exceeded the 32-bit threshold. We're excited to have reached this milestone, and wanted to give everyone a heads up.

What this means for you
If your app processes the shop ID from an API call, you will need to ensure that your data type can handle 64-bit integers.

If you have any questions about this news, feel free to shout out below in the thread.

i
Replies
Wayne Member rehash.com
Posts:
4
8 months ago
g
2
upvotes

If using Ruby on Rails this link has some helpful info about migrating to 64-bit integer.

Rails 5.1: Default Primary Keys Are Now BIGINT