QuestionQ43

VerifiedPlanning and implementing a cloud solution

Your company has an internal application for managing transactional orders. The application is used exclusively by employees in a single physical location. The application requires strong consistency, fast queries, and ACID guarantees for multi-table transactional updates. The first version of the application is implemented in PostgreSQL, and you want to deploy it to the cloud with minimal code changes. Which database is most appropriate for this application?

Explanation

Cloud SQL is a fully managed database service that natively supports PostgreSQL. It provides strong consistency, ACID guarantees, and fast queries with minimal code changes since the application was originally built for PostgreSQL. Bigtable is a wide-column NoSQL store without multi-table SQL transactions, BigQuery is an analytics warehouse rather than a transactional (OLTP) database, and Firestore is a document database that would require rewriting the data model and queries.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!