Published inGoogle Cloud - CommunityCloud SQL Enterprise Plus vs. AlloyDB: A pgbench Showdown for High-Performance OLTPOne of my customer recently approached me with a challenge. They’re migrating applications from on-premise to Google Cloud and need a…Feb 1119Feb 1119
Published inGoogle Cloud - CommunityAlloyDB: Supercharging your real-time analyticsGoogle Cloud’s AlloyDB for PostgreSQL offers a compelling alternative to traditional relational databases, particularly when it comes to…Dec 11, 202410Dec 11, 202410
Published inGoogle Cloud - CommunityBenchmarking AlloyDB with TPC-H: A Deep DiveGoogle Cloud’s AlloyDB for PostgreSQL offers a compelling combination of performance, scalability, and compatibility. This blog post…Dec 11, 2024Dec 11, 2024
Published inGoogle Cloud - CommunityBuilding a Geospatial Application with AlloyDB, PostGIS, and PythonAlloyDB is a fully managed, PostgreSQL-compatible database service offered by Google Cloud. It’s designed for demanding enterprise…Dec 8, 2024Dec 8, 2024
Published inGoogle Cloud - CommunityDeploying a Streamlit App on Cloud Run with Cloud SQL PostgresStreamlit is an ever growing and popular open-source Python framework to build interactive data apps — in only a few lines of code. It…Dec 3, 20243Dec 3, 20243
Published inGoogle Cloud - CommunityRAG based application with AlloyDB and Vertex AIOne of the tools for improving the quality of responses from large language models (LLMs) is retrieval augmented generation (RAG). RAG is…Nov 18, 2024Nov 18, 2024
Published inGoogle Cloud - CommunityBuilding a RAG application with vector search in FirestoreThe world of information retrieval is rapidly evolving, and Retrieval Augmented Generation (RAG) is at the forefront of this evolution. RAG…Sep 10, 202466Sep 10, 202466
Published inGoogle Cloud - CommunityQuery Google BigQuery with Splunk DB ConnectThis post explains on how to setup BigQuery with Splunk DB Connect, to be able to run queries against BigQuery from within Splunk. This is…Feb 29, 20246Feb 29, 20246
Published inGoogle Cloud - CommunityDeploy PostgreSQL on GKE using Helm and using Robin storageIn this Part-II post, we will deploy a PostgreSQL database on Google Kubernetes Engine (GKE) using Helm and load data in the database…May 27, 2023May 27, 2023
Published inGoogle Cloud - CommunityInstall Robin storage on GKEGoogle Kubernetes Engine (GKE) is a managed Kubernetes service that you can use to deploy and operate containerized applications at scale…May 27, 2023May 27, 2023
Cloud Storage Best PracticesWhen analyzing Cloud Storage use, we consider three needs:Jan 24, 2021Jan 24, 2021
Cloud Dataproc Best PracticesSpecify cluster image versions. Cloud Dataproc uses image versions to bundle operating system and big data components (including core and…Jan 24, 2021Jan 24, 2021
BigQuery query performanceControl projection — Query only the columns that you need. Projection refers to the number of columns that are read by your query…Jan 23, 2021Jan 23, 2021
BigQuery cost optimizationBigQuery operations that are free of charge in any location:Jan 23, 2021Jan 23, 2021
BigQuery REST API call using JWTThis post looks at calling BigQuery from devices through REST API. Devices often have a small footprint and have constraints and may not…Sep 30, 2020Sep 30, 2020
BigQuery to Cloud Storage extract using DataFlowBigQuery provides an excellent CLI — “bq extract” and an API as well as Client Library in many languages for achieving the same. In…Sep 27, 2020Sep 27, 2020