Tag: AlloyDB

AlloyDB Dec. 16, 2024

Benchmarking AlloyDB with TPC-H: A Deep Dive - This blog post presents a detailed benchmark of Google Cloud's AlloyDB for PostgreSQL using the industry-standard TPC-H benchmark. The setup, data loading process, query execution, and results analysis are covered. The results show that AlloyDB exhibits strong performance for TPC-H queries, making it a strong contender for applications requiring high-throughput data analysis. Further investigation could focus on optimizing specific queries and exploring the impact of the columnar engine on overall performance.

AlloyDB Databases Official Blog Dec. 16, 2024

Unleash a new era of PostgreSQL: AlloyDB redefines what's possible - A brief e-book about AlloyDB, Google's PostgreSQL-compatible database.

AlloyDB Cloud SQL Databases Generative AI Official Blog Partners Dec. 9, 2024

Build agentic RAG on Google Cloud databases with LlamaIndex - LlamaIndex integrates with AlloyDB and Cloud SQL for PostgreSQL, enabling developers to build agentic applications that can connect with Google databases. These integrations empower developers to leverage the data in their operational databases to easily build complex agentic RAG workflows. Key features include streamlined knowledge retrieval, complex document parsing, secure authentication and authorization, fast prototyping, and flow control.

AlloyDB GIS Python Dec. 9, 2024

Building a Geospatial Application with AlloyDB, PostGIS, and Python - This article demonstrates how to build a geospatial application using Google Cloud's AlloyDB for PostgreSQL, the PostGIS extension, and Python. It covers setting up the environment, creating a database and table, generating and inserting sample data, and visualizing the data on a map.

AlloyDB Gemini Vertex AI Dec. 2, 2024

Upgrade your Vector Search Efficiency and Recall with ScaNN Index! - ScaNN, a state-of-the-art approximate nearest neighbor search algorithm, offers a powerful solution for optimizing vector search performance. ScaNN excels at handling large-scale datasets and complex queries, making it particularly well-suited for retail use cases. AlloyDB, a fully managed relational database service, offers seamless integration with ScaNN through the alloydb_scann extension.

AlloyDB Databases Official Blog Nov. 18, 2024

AlloyDB Omni supercharges performance: Faster transactions, analytics, and vector search - AlloyDB Omni version 15.7.0 brings significant enhancements for PostgreSQL workflows. It offers faster performance, an ultra-fast disk cache for improved memory management, an enhanced columnar engine with expanded storage options, and the general availability of ScANN vector indexing for rapid vector queries. Additionally, the new release of the AlloyDB Omni Kubernetes operator provides more configuration options and support for high availability and log rotation.

AlloyDB Databases Official Blog Nov. 11, 2024

Google is a Leader in The Forrester Wave™: Translytical Data Platforms, Q4 2024 - Google Cloud's AlloyDB has been recognized as a Leader in The Forrester Wave™: Translytical Data Platforms, Q4 2024 report. AlloyDB stands out with its differentiated architecture that combines the performance of a traditional relational database with the scalability and flexibility of cloud-first technology.

AlloyDB Databases GCP Experience Official Blog Nov. 4, 2024

How AlloyDB unifies OLTP and OLAP workloads for Tricent - Tricent Security Group A/S, a leader in file-sharing security, faced efficiency and performance challenges with their PostgreSQL database infrastructure. Moving to AlloyDB for PostgreSQL helped transform Tricent’s database operations, resulting in faster query response times and the ability to handle up to 250 million daily transactions.

AlloyDB Vertex AI Oct. 21, 2024

AlloyDB: Effortless Embedding Generation with SQL and a quick App with Streamlit - This article provides a step-by-step guide to setting up an AlloyDB cluster and instance, enabling APIs, and creating a table for storing thought embeddings. It also demonstrates how to build a simple Streamlit app that captures user thoughts, generates embeddings using Google's embedding model, and retrieves similar thoughts from the database.

AlloyDB Cloud Spanner Cloud SQL Databases Official Blog Oct. 14, 2024

Database Center — your AI-powered, unified fleet management solution - Database Center, an AI-powered, unified fleet management solution from Google Cloud, is now available to all customers. It provides a single, intuitive interface to monitor and operate database fleets at scale, including Cloud SQL, AlloyDB, and Spanner. With Database Center, organizations can gain a comprehensive view of their entire database landscape, proactively de-risk their fleet with intelligent performance and security recommendations, and optimize their database fleet with AI-powered assistance.

AlloyDB Databases Official Blog Oct. 7, 2024

AlloyDB supercharges PostgreSQL vector search with accuracy, speed, and 1B+ scale - AlloyDB's ScaNN index is now generally available. With the ScaNN index, AlloyDB combines the performance of a vector-optimized database, delivering accurate results in record time and scaling to support more than a billion vectors, with the query flexibility, enterprise features, and multi-workload capabilities of a relational database.

AlloyDB Databases Official Blog Partners Oct. 7, 2024

Aiven partnership enables multi-cloud, managed PostgreSQL with AlloyDB Omni - Google Cloud and Aiven partner to offer Aiven for AlloyDB Omni, a managed cloud database service that provides a simplified and secure way to deploy, manage, and scale AlloyDB Omni on Google Cloud, AWS, and Azure.

AlloyDB LLM Sept. 23, 2024

AI on your Laptop with AlloyDB Omni and Ollama. - AlloyDB Omni, a fully-managed PostgreSQL-compatible database service, can be integrated with Ollama, an open-source tool for running large language models locally, to generate embeddings from user inputs stored in databases. The process involves setting up Ollama on the local laptop, integrating AlloyDB Omni with Vertex AI, setting up input and output transformation, and loading the local model into AlloyDB Omni.

AlloyDB Generative AI Machine Learning Sept. 16, 2024

A Patent Search Agent with LangChain and Reasoning Engine - This blog post presents a method for building a patent search agent using LangChain, AlloyDB, and Vertex AI Reasoning Engine. The agent leverages the power of large language models (LLMs) to retrieve and analyze relevant patents based on user search criteria.

AlloyDB Databases GCP Experience Official Blog Web3 Sept. 9, 2024

Galxe migrates to Google Cloud AlloyDB for PostgreSQL, cutting costs by 40% - Galxe, a Web3 company, migrated from Amazon Aurora to Google Cloud's AlloyDB for PostgreSQL, cutting costs by 40%.

AlloyDB Sept. 2, 2024

A Practical Guide to using PgCat with AlloyDB - PgCat is a PostgreSQL connection pooler and proxy that scales PostgreSQL databases beyond a single instance. This blog post demonstrates how to configure and use PgCat with AlloyDB.

AlloyDB Vertex AI Aug. 19, 2024

LangChain integration for the smart retail shopping assistant - LangChain integration for AlloyDB enables developers to easily connect their applications to AlloyDB and execute natural language queries directly from their code. This integration simplifies the development of AI-driven applications that interact naturally with users.

AlloyDB Cloud SQL Databases Official Blog Vertex AI Aug. 12, 2024

Announcing LangChain on Vertex AI for AlloyDB and Cloud SQL for PostgreSQL - AlloyDB and Cloud SQL for PostgreSQL now support LangChain on Vertex AI, enabling developers to build, deploy, query, and manage AI agents and reasoning frameworks in a secure, scalable, and reliable way. This integration unlocks new database use cases such as querying databases, knowledge retrieval, chat bots, and tool use. It also provides fast knowledge retrieval, secure authentication and authorization, chat history context, and fast prototyping.

AlloyDB Aug. 5, 2024

AlloyDB Adaptive AutoVacuum and how AlloyDB Cluster Storage Space is Released. - Real World Example of Adaptive AutoVacuum in AlloyDB and AlloyDB Cluster Storage Shrink/Usage in Action.

AlloyDB Databases GCP Experience Official Blog July 22, 2024

Endear seamlessly integrates vast data sources with AlloyDB - Endear, an omnichannel CRM platform, migrated from Cloud SQL to AlloyDB for PostgreSQL to handle increasing demand and provide real-time insights to clients.

AlloyDB Databases GCP Experience Official Blog July 22, 2024

SEEBURGER BIS on AlloyDB: A secure, scalable business-critical integration platform - SEEBURGER BIS Platform, a leading integration platform, has chosen AlloyDB for PostgreSQL as its cloud database of choice. AlloyDB's seamless PostgreSQL compatibility, enhanced scalability, reduced operational overhead, and deployment flexibility make it an ideal fit for SEEBURGER's needs.

AlloyDB Databases Official Blog July 15, 2024

Announcing AlloyDB free trial clusters: your playground for PostgreSQL innovation - AlloyDB free trial clusters provide you with the time and resources you need to perform a full-blown trial of AlloyDB, with a powerful 8 vCPU and 64 GB RAM primary instance and 1 TB of regional storage. sz.

AlloyDB Databases GCP Experience Official Blog July 15, 2024

How AlloyDB transformed Bayer’s data operations - Bayer Crop Science migrated to AlloyDB for PostgreSQL to handle a dramatic increase in traffic to its Field Answers data solution. AlloyDB's architecture significantly reduced the impact of scaling read traffic, improving performance and ensuring low replication delay. The migration allowed Bayer to meet growing demands and focus on innovation without being hindered by database limitations.

AlloyDB Cloud SQL Networking Terraform July 8, 2024

Automate infrastructure with Cloud Networking Config Solutions - Google Cloud Networking Config Solutions automates the creation and management of essential Google Cloud Networking components using Terraform modules and resources, simplifying configuration management and reducing errors compared to manual configuration.

AlloyDB Databases GCP Experience Official Blog July 8, 2024

Harnessing the potential of massive NeuroPace brain data sets with AlloyDB Omni - NeuroPace, a medical device company, collaborated with Google Cloud engineers to explore the potential of AlloyDB Omni, a vector database, for efficient analysis of massive iEEG data sets. By converting iEEG data into vectors and storing them in AlloyDB, they achieved fast and scalable similarity searches, enabling physicians to find similar patient profiles for optimizing stimulation settings.

AlloyDB Cloud Logging Cloud SQL Databases Official Blog July 1, 2024

Create custom metrics for Cloud SQL for PostgreSQL and AlloyDB using Logs Explorer - Custom log-based metrics allow you to monitor specific conditions or errors in your PostgreSQL database running on Cloud SQL or AlloyDB. You can create custom metrics using Logs Explorer by defining a metric name, type, and expression that filters the logs for the desired information. This enables you to track and analyze specific events, such as duplicate key violations, long-running queries, or data access-related metrics. You can also set up alerts based on these custom metrics to receive notifications when certain conditions are met.

AlloyDB Cloud SQL Networking June 24, 2024

Troubleshooting Cloud SQL/AlloyDB Creation Error: “Failed to create a subnetwork” - This article discusses an error that can occur when creating a Cloud SQL or AlloyDB instance due to the exhaustion of the allocated address space for Private Service Access (PSA).

AlloyDB Cloud Firestore Cloud Memorystore Databases Official Blog June 24, 2024

What’s new with Google Cloud databases — June 2024 edition - Google Cloud has released several updates to its database services, including vector search support across AlloyDB, Spanner, Cloud SQL, Memorystore for Redis, and Firestore. Gemini in Databases, an AI assistant, simplifies database management and development.

AlloyDB Generative AI June 10, 2024

Building a Smart Retail Shopping Assistant PART 1 - A Deep Dive into Knowledge-Driven Conversational AI (Part 2 coming.

AlloyDB Machine Learning June 3, 2024

Hugging face and Open AI Models in AlloyDB Omni - In this post, I'll show you how to register AI models hosted by third-party providers, such as OpenAI and Hugging Face, in AlloyDB Omni. We'll cover the process of enabling the Secret Manager API, generating API keys, creating secrets in Google Secret Manager, and registering models using the google_ml extension. Examples of registering the OpenAI gpt-4o model and the Hugging Face Mistral-7B-Instruct-v0.3 model are provided, along with sample queries to test the models.

AlloyDB Cloud SQL Private Service Connect May 20, 2024

Connect to Non-PSC AlloyDB or Non-PSC Cloud SQL from a different VPC - This blog dives into the world of private connectivity for AlloyDB, focusing on the benefits of Private Service Connect.

AlloyDB Gemini May 20, 2024

Gemma and Gemini-Pro AI Models in AlloyDB Omni - This blog post explains how to integrate AlloyDB Omni with Vertex AI and make predictions using Google Gemini.

AlloyDB Cloud SQL Databases Official Blog May 13, 2024

AlloyDB vs. self-managed PostgreSQL: a price-performance comparison

AlloyDB Generative AI Official Blog April 15, 2024

Natural language support in AlloyDB for building gen AI apps with real-time data

AlloyDB Official Blog April 15, 2024

Introducing ScaNN vector indexing in AlloyDB, bringing 12 years of Google research to speed up vector search

AlloyDB Cloud Bigtable Cloud Spanner Cloud SQL Official Blog April 15, 2024

What's new and what's next for Google Cloud databases

AlloyDB Go April 8, 2024

Using AlloyDB Go connector for automatic IAM authentication (service account) - This blog post walks you through the process of configuring your application and AlloyDB Instance to use AlloyDB Go connector so that your application can use a service account to connect to AlloyDB database.

AlloyDB Generative AI Machine Learning April 8, 2024

Making sense of Vector Search and Embeddings across GCP products - An overview of vector search and embedding through the GCP products.

AlloyDB Cloud Spanner Official Blog March 25, 2024

Choosing a suitable database for your startup: An overview of AlloyDB and Spanner

AlloyDB GCP Experience Official Blog March 18, 2024

AlloyDB fuels 50% faster margin calculations for Apex FinTech - Apex FinTech Solutions Inc. ("Apex") enables modern investing and wealth management tools through an ecosystem of frictionless platforms. To transform this traditionally on-premises process, the company migrated to AlloyDB for PostgreSQL to enable real-time decision-making and risk management for clients and investors.

AlloyDB Cloud Bigtable Cloud Memorystore Cloud Spanner Cloud SQL Generative AI Official Blog March 11, 2024

Build supercharged gen AI applications with LangChain and Google Cloud databases

AlloyDB March 4, 2024

Connect AlloyDB to Oracle using Oracle FDW - Using Oracle FDW to query AlloyDB.

AlloyDB BigQuery Official Blog March 4, 2024

BigQuery and AlloyDB hit major milestone with AI-enabled updates - New AI-enabled product innovations for both BigQuery and AlloyDB for PostgreSQL.

AI AlloyDB Cloud Spanner Cloud SQL Data Analytics Machine Learning Official Blog March 4, 2024

Google Cloud databases stand ready to power your gen AI apps with new capabilities - Recent AI improvements for GCP databases.

AlloyDB Cloud Spanner GCP Experience Official Blog Feb. 19, 2024

Scaling Character.AI: How AlloyDB for PostgreSQL and Spanner met their growing needs - Character.AI relies on Google Cloud's portfolio of managed databases, including AlloyDB for PostgreSQL and Spanner, as a solid foundation for its platform, providing reliability, scalability, and price performance for its workloads, from engagement and operations to AI and analytics.

AlloyDB Cloud Bigtable Cloud Firestore Cloud Memorystore Cloud Spanner Cloud SQL Database Migration Service Official Blog Feb. 5, 2024

Google Cloud databases round-up: January 2024 - The latest feature releases and innovations within GCP database offerings.

AlloyDB Official Blog Vertex AI Jan. 22, 2024

AlloyDB AI powers gen AI applications with seamless Vertex AI integration - You can enable AlloyDB access to Vertex AI with AlloyDB AI using the google_ml_integration extension, which allows you to run predictions with your data in AlloyDB using custom models in Vertex AI or models from Model Garden.

AlloyDB LLM Official Blog Translation API Jan. 22, 2024

How to create a multilingual chatbot that queries AlloyDB with Langchain, Streamlit, LLMs, and Google Translate

AlloyDB Cloud SQL Jan. 8, 2024

Replication of Data from Oracle database to Cloud SQL for PostgreSQL or AlloyDB - Replicating data from Oracle to Cloud SQL or AlloyDB.

AlloyDB Nov. 13, 2023

Core RAG Architecture with AlloyDB AI - Retrieval Augmented Generation Architecture and Implementation Example.

AlloyDB Official Blog Oct. 30, 2023

Understanding Alloy DB connectors - AlloyDB connectors provide an automated mTLS connection with Cloud IAM integration for your application and they are available in library and binary form.

AlloyDB Billing Official Blog Oct. 30, 2023

Save up to 52 percent on your database compute costs with AlloyDB committed use discounts - By committing to a consistent amount of compute usage for a one- or three-year period, you can get deep discounts: a 25% discount for a one-year commitment and a 52% discount for a three-year commitment.

AlloyDB Official Blog Oct. 16, 2023

The power of AlloyDB AI in AlloyDB Omni - GenAI capabilities help you expand descriptions, generate code, answer questions or summarize text, inside of your database.

AlloyDB Official Blog Oct. 16, 2023

AlloyDB Omni, the downloadable edition of AlloyDB, is now generally available - AlloyDB Omni, the Downloadable Edition of AlloyDB, is now generally available and includes AlloyDB AI, new pricing, and the Kubernetes operator.

AlloyDB BigQuery Oct. 2, 2023

Compare Analytical Queries Performance of AlloyDB with BigQuery - This experiment focuses on an analytical query performance comparison between AlloyDB and BigQuery.

AlloyDB GCP Experience Official Blog Oct. 2, 2023

FLUIDEFI nets 3X gains in processing speed with AlloyDB to address DeFi industry challenges

AlloyDB Official Blog Sept. 25, 2023

AlloyDB for PostgreSQL under the hood: adaptive autovacuum - Adaptive autovacuum feature that is available with AlloyDB.

AlloyDB Generative AI Sept. 4, 2023

Powering Q&A Chatbots with AlloyDB and GenAI Models - This blog post shows how to use AlloyDB’s pgvector extension to store vector embeddings of a PDF file into AlloyDB for PostgreSQL and also will create a small Q&A chatbot on top of it.

AlloyDB Cloud Spanner Cloud SQL Duet AI Official Blog Sept. 4, 2023

What’s new and what’s next with Google Cloud databases - Announcing a series of new features and capabilities to help organizations innovate faster with Google Cloud databases.

AlloyDB Official Blog Sept. 4, 2023

Announcing AlloyDB AI for building generative AI applications with PostgreSQL - Announcing a series of new features and capabilities to help developers build enterprise generative AI apps with Google Cloud PostgreSQL databases.

AlloyDB Official Blog Sept. 4, 2023

Build new gen AI capabilities with AlloyDB Omni, now in preview - The public preview of AlloyDB Omni includes AlloyDB AI, adds compatibility with PostgreSQL 15, and several management enhancements.

AlloyDB July 24, 2023

Verify Columnar Engine Usage with AlloyDB Operational Views - A closer look at Views associated with Columnar Engine.

AlloyDB Database Migration Service Official Blog July 3, 2023

AlloyDB for PostgreSQL with Database Migration Service is now Generally Available - The Database Migration Service for AlloyDB for PostgreSQL is now GA, and makes it easy to move from on- prem, self-managed and cloud databases.

AlloyDB Migration June 19, 2023

Unlocking the Power of Hybrid Transactional and Analytical Processing with AlloyDB Omni - Step by step tutorial to migrate from Postgres to AlloyDB Omni, an HTAP database.

AlloyDB Official Blog June 19, 2023

AlloyDB for PostgreSQL under the hood: Business continuity - Built on Google Cloud's highly available and reliable infrastructure, AlloyDB makes it easy to recover from database disruptions and outages.

AlloyDB BigQuery Cloud SQL June 12, 2023

Enable Federated Access to AlloyDB Columnar from BigQuery. - This blog post explains how to enable querying columnar store data on AlloyDB from BigQuery.

AlloyDB June 12, 2023

Essential SQL for exploring AlloyDB Columnar Engine. - Sharing the SQL script frequently used in work with AlloyDB, specifically leveraging its Columnar engine.

AlloyDB Official Blog May 29, 2023

Benchmarking for AlloyDB and how to do it - Potential approaches for benchmarking AlloyDB deployments and factors to consider.

AlloyDB Official Blog April 17, 2023

Overview of the AlloyDB Index Advisor feature and how to use it - AlloyDB has built-in, managed database features that recommends Indexes to improve database query performance.

AlloyDB Cloud Functions April 10, 2023

Connect to AlloyDB for PostgreSQL using Cloud Functions - This blog post explains how to connect to AlloyDB using Cloud Functions.

AlloyDB Official Blog April 3, 2023

Accelerate database modernization with Google Cloud Ready - AlloyDB validated partners - Google Cloud announces the public launch of Google Cloud Ready - AlloyDB, to help customers discover trusted partner products that work well with AlloyDB.

AlloyDB Official Blog April 3, 2023

How do I start using AlloyDB Omni? - How and why should you care about our new run-anywhere product, AlloyDB Omni and how it’s different from Cloud AlloyDB.

AlloyDB Official Blog April 3, 2023

Run AlloyDB anywhere - in your data center, your laptop, or in any cloud - Today, we’re excited to announce the technology preview of AlloyDB Omni, a downloadable edition of AlloyDB designed to run on premises, at the edge, across clouds, or even on developer laptops.

AlloyDB Cloud SQL Official Blog April 3, 2023

Process to drop partitions concurrently within PostgreSQL (Cloud SQL or AlloyDB) - Automating partition management and maintenance, for efficient data management within PostgreSQL in Cloud SQL and AlloyDB.

AlloyDB March 20, 2023

AlloyDB’s Columnar Store : How to Preserve it During Failovers and Restarts. - Adopting Columnar Store involves identifying columns to be added, refreshing them and preserving them during restarts, failover or promote.

AlloyDB Official Blog March 6, 2023

AlloyDB for PostgreSQL goes global with sixteen new regions - AlloyDB for PostgreSQL is now available in 16 new regions across the globe, bringing the total to 22.

AlloyDB Dec. 19, 2022

Migration from Oracle to AlloyDB made easy - This article explains the process, challenges, and benefits of migrating an Oracle database to AlloyDB with minimal to near-zero downtime.

AlloyDB Data Analytics Infrastructure Official Blog Dec. 19, 2022

Announcing the General Availability of AlloyDB for PostgreSQL - Migrate and modernize legacy databases with AlloyDB for PostgreSQL, a PostgreSQL-compatible database for demanding enterprise database workloads.

AlloyDB Nov. 7, 2022

Index Recommender Extension on AlloyDB for PostgreSQL - Using google_db_advisor extension in AlloyDB to get recommendation on creating indexes.

AlloyDB Cloud Bigtable Cloud Firestore Cloud Spanner Cloud SQL Official Blog Oct. 17, 2022

What's new in Google Cloud databases: More unified. More open. More intelligent. - Google Cloud databases deliver an integrated experience, support legacy migrations, leverage AI and ML and provide developers world class tools.

AlloyDB Cloud Spanner Cloud SQL Sept. 19, 2022

PostgreSQL on Google Cloud — AlloyDB, Cloud SQL, or Cloud Spanner - AlloyDB, Cloud SQL, or Cloud Spanner — what would meet your needs?

AlloyDB Official Blog Sept. 19, 2022

Latest database innovations for transforming the customer experience - Google Cloud adds Spanner free trial instances and fine-grained access control, Datastream for BigQuery and PostgreSQL, database migrations to AlloyDB.

AlloyDB Database Migration Service Official Blog Sept. 19, 2022

Migrate your most demanding enterprise PostgreSQL databases to AlloyDB for PostgreSQL with Database Migration Service - Database migration service now supports easy-to-use, secure, and serverless migration to AlloyDB for PostgreSQL.

AlloyDB July 25, 2022

Access Google’s AlloyDB with pgAmdin, psql, and pgbench from a private IP - A walk through the steps to set up an AlloyDB cluster and access the Postgres database from a GCE instance with a private IP.

AlloyDB June 6, 2022

Connecting to AlloyDB from your Local - Using alloydb-auth-proxy to connect from the local computer to AlloyDB.

AlloyDB Official Blog May 30, 2022

AlloyDB for PostgreSQL under the hood: Columnar engine - In this technical deep dive, we take a look at the columnar engine that delivers industry leading query performance for AlloyDB for PostgreSQL.

AlloyDB Official Blog May 16, 2022

Introducing AlloyDB for PostgreSQL: Free yourself from expensive, legacy databases - AlloyDB for PostgreSQL combines the best of Google with full PostgreSQL compatibility to achieve superior performance, availability, and scale.

AlloyDB Official Blog May 16, 2022

AlloyDB for PostgreSQL under the hood: Intelligent, database-aware storage - In this technical deep dive, we take a look at the intelligent, scalable storage system that powers AlloyDB for PostgreSQL.

AlloyDB May 16, 2022

First Look at AlloyDB for PostgresSQL - An overview of the most important things regarding AlloyDB.