Is BigQuery a good choice as database for a survey tool?

[MKK1]

Hello There,

We are building a survey tool that involves creating a couple of UI forms to let end-users' rate around 100 movies on a scale of 0-5 against 12 attributes (resulting in around 1200 user enterable fields in UI forms).

Data containing list of movies, their characters and other data points are available in big query. Is it a good choice to use BQ as our database for this survey tool or should we move the relevant data needed for this survey to Cloud SQL (MySQL) and use that as database for our UI forms?

Regards,

MKK

[NorieRam]

Hi @MKK1,

Welcome to Google Cloud Community!

For real-time survey applications that require frequent updates, Cloud SQL (MySQL) is a more suitable option than BigQuery. BigQuery is designed for analytics, not the low-latency transactions that surveys need. To ensure efficient operation, it is recommended that the necessary movie data should be extracted from BigQuery and imported into Cloud SQL. This approach maintains separation between your analytical and transactional data.

The following presents insights on your topic derived from the Stack Overflow forum.:

• Export from Google BigQuery into CloudSQL
• Data Transfer from BQ To CLoud SQL
• Can BigQuery be fast enough for real-time onsite request

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.