Posts in tag

SQL


This guide contains instructions on how to install and do basic configuration of  PostgreSQL on a Ubuntu 22.04 machine. Install via APT package 01. Open a terminal window 02. Update the package repository list $ sudo apt update 03. Install PostgreSQL via APT package manager. Enter y when asked to confirm. $ sudo apt install …

Take a look at a data sharding scenario in which DistSQL’s flexibility allows you to create a distributed database. Distributed databases are common for many reasons. They increase reliability, redundancy, and performance. Apache ShardingSphere is an open source framework that enables you to transform any database into a distributed database. Since the release of ShardingSphere …

Preventing data breaches is an important priority when creating and managing database environments. Ensuring user and application passwords meet high security standards is crucial for reducing risk and helping to achieve compliance with best practices and regulatory standards. To address these concerns, we are thrilled to announce the general availability of Local Users Password Validation …

Do you need an up-to-date copy of the data you’re storing in Cloud SQL for SQL Server? Cloud SQL now supports setting up replication from your Cloud SQL instance to an external subscriber (or to another Cloud SQL instance) using a SQL Server capability called transactional replication. This gives you another way to create an …

We’re very pleased to announce that Firestore in Datastore mode now supports IN, Not IN, and Not Equal To operators. IN Operator Firestore in Datastore Mode now supports the IN operator. With IN, you can query a specific field for multiple values (up to 10). You do this by passing in a list of all the values …

Founded in 2012, SingleStoreDB is a distributed SQL, cloud-native database that offers ultra-fast, low-latency access to large datasets — simplifying the development of modern enterprise applications. And by combining transactional (OLTP) and analytical (OLAP) workloads, SingleStoreDB introduces new efficiencies into data architecture. We are a multicloud database, meaning that our customers can launch SingleStoreDB on …

With Cloud SQL for SQL Server, you can bring your existing SQL Server on-premises workloads to Google Cloud. Cloud SQL takes care of infrastructure, maintenance, and patching so you can focus on your application and users. A great way to take better care of your application is by monitoring the SQL Server error log for …

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 …