Posts in tag

SQL


Today we are announcing the Preview of BigQuery Remote Functions. Remote Functions are user-defined functions (UDF) that let you extend BigQuery SQL with your own custom code, written and hosted in Cloud Functions, Google Cloud’s scalable pay-as-you-go functions as a service.  A remote UDF accepts columns from BigQuery as input, performs actions on that input …

As companies around the world and across industries engage in app modernization initiatives, their developers find it increasingly difficult to match those efforts with a strong data layer. Developers today continue to work with costly monolithic databases like Oracle or DB2 and NoSQL databases that forgo strong data consistency and important relational features. It’s clear that a …

If you want to use your local timezone for your database running on Cloud SQL for SQL Server, then this blog is for you. Cloud SQL is a fully managed relational database service for Microsoft SQL Server, MySQL and PostgreSQL. With Cloud SQL, you can run the same relational databases you know with their rich …

The Google BigQuery Write API offers high-performance batching and streaming in one unified API. The previous post in this series introduced the BigQuery Write API. In this post, we’ll show how to stream JSON data to BigQuery by using the Java client library. The Write API expects binary data in protocol buffer format. This makes …

Game developers often reuse their existing database platform to launch their new games or launch new features to their existing games. This requires the database to scale in terms of new schema (tables, index, etc.), data and traffic. For games built with Cloud Spanner databases, most database operations can be done seamlessly, without affecting production …

code

Thirty five years ago, SQL-86, the first SQL standard, came into our world, published as an ANSI standard in 1986 and adopted by the International Standards Organization (ISO) in 1987. On this Valentine’s Day, we, in BigQuery, reaffirm our love and commitment to user-friendly SQL through a whole slew of new SQL features that we’re …

Peanut Butter and Jelly. Infinity Gems and the Infinity Gauntlet. Server Virtualization and Shared Storage. Holidays and Cookies (ok, maybe that’s just a personal preference). We all love to find a combination of products, foods or technologies that effortlessly fit together to make our lives better. And when it comes to technology, there’s nothing better …

Cloud SQL is Google Cloud’s fully managed relational database service for MySQL, PostgreSQL and SQL Server workloads. Cloud SQL enables customers to implement horizontal scaling of read-only workloads using read replicas. In this blog post, we will demonstrate a single-endpoint read scaling and load balancing solution using Cloud SQL for PostgreSQL and HAProxy, with automatic …

Organizations increasingly turn to AI to transform work processes, but this rapid adoption of models has amplified the need for explainable AI. Explaining AI helps us understand how and why models make predictions. For example, a financial institution might wish to use an AI model to automatically flag credit card transactions for fraudulent activity. While …

If you manage sensitive data in your MySQL database, you might be obligated to record and monitor user database activity, especially if you work in a regulated industry. Although you could set up MySQL’s slow query log or general log to create an audit trail of user activity, these logs significantly impact database performance and …