Follow email Print print

Changes in our Database: Migration to BigInt Value Types

What is the BigInt Migration?

We are making a series of updates to our database tables to increase the maximum value that can be stored in these columns:

 

· Task Response ID s (task_responses.id)

· User Place Assignment ID s (user_place_assignments.id)

 

Why is this migration needed?

Over the last nine years, FORM MarketX (GoSpotCheck) users have completed 2.1 billion distinct task responses and we’re scaling our platform to ensure responsive data operations at scale.

 

Because of the activity volume on our platform, we will update our database to accommodate 64-bit integers (known as “BigInts”).

 

What can you expect?

We will have planned maintenance downtime scheduled for November 12, 2022, between 9:00pm EDT and 12:00am EDT, during which time our application will not be available.

 

Outside the scheduled maintenance window, there should be no impact on your ability to use the application or complete mission responses.

 

Will users be able to complete missions during the downtime?

The application will be fully offline during the maintenance window–users will not be able to log in, start, or submit mission responses, or work in offline mode during the downtime.

 

What will happen to any mission responses that are ‘in progress’ during downtime?

When we enter the maintenance window, any mission responses that are in an ‘in progress’ state will be saved on the user’s device. Users will be able to locate the response and submit it once the application is back online.

 

Do users need to prepare anything for this change?

Related to the activities conducted during this scheduled maintenance, some customers who extract data from our system will need to check with their data team to ensure that they can ingest BigInt value types. More information below.

 

Action Required for API, SFTP, and Manual Export Customers by February 2023

Customers who extract data out of FORM MarketX (GoSpotCheck) via API, SFTP, custom ingestions, or manual exports and host data collected in GoSpotCheck within their internal systems will need to ensure that any tables in users’ systems of record hosting Task Response IDs or User Place Assignment IDs are able to support BigInt values (64-bit integers). We recommend that you make any necessary adjustments to support BigInt values no later than February 2023 and discuss any questions with your internal data teams.

 

Helpful Resources: · GoSpotCheck API Documentation

star
Have more questions? Submit a request