Open in app

Sign In

Write

Sign In

Christoph Bussler
Christoph Bussler

127 Followers

Home

About

Published in

Google Cloud - Community

·Aug 28

Vector Databases (are All The Rage)

No kidding — A first attempt of a rationalization — Since everybody else wrote already about AI, I have to do it, too. I went to check out the landscape of vector database systems, a database technology variant that receives a lot of attention right now. Usually you expect a few players in an established technology space, maybe a few…

Vector Database

16 min read

Vector Databases (are All The Rage)
Vector Databases (are All The Rage)
Vector Database

16 min read


Published in

Google Cloud - Community

·Jun 29

Global Yugabyte Database Deployment into Google Cloud (Part 2)

Restartable Yugabyte Nodes on Compute Instances — When a compute instance restarts for any reason, the Yugabyte master and tserver running on the compute instance should automatically restart as well. This blog describes one approach to accomplish the automatic restart of Yugabyte’s components. The previous blog Deployment into Google Cloud (Part 1) followed the Yugabyte instructions that…

Yugabyte

7 min read

Global Yugabyte Database Deployment into Google Cloud (Part 2)
Global Yugabyte Database Deployment into Google Cloud (Part 2)
Yugabyte

7 min read


Published in

Google Cloud - Community

·May 30

Global Yugabyte Database Deployment into Google Cloud (Part 1)

Single database deployment into 37 Google Cloud regions — Goal This is a first step in my journey to a global Yugabyte database deployment as database layer for a global distributed application. The goal is to have a single global database with nodes in all regions of a cloud, here Google Cloud (currently there are 37 regions). The main reasons…

Google Cloud

10 min read

Global Yugabyte Database Deployment into Google Cloud (Part 1)
Global Yugabyte Database Deployment into Google Cloud (Part 1)
Google Cloud

10 min read


Jan 26

Event-Condition-Action Rule Execution for Transactional Queues

Using ECA rules for acting on messages in transactional queueing — This blog discusses an approach to execute ECA (Event-Condition-Action) rules on JSON objects within database transactions in PostgreSQL — specifically on transactional queues. This guarantees exactly once execution and consistency of rule execution in case of failures (independent of the underlying reason). Background ECA rules is an established concept in the…

Eca Rules

8 min read

Eca Rules

8 min read


Published in

Google Cloud - Community

·Jan 3

AlloyDB for PostgreSQL disaster recovery: A complete failover and fallback process

Architecture Solution — Many organization strive to be prepared for cloud region or cloud service outages, as unlikely as they are. Other organizations must have a disaster recovery plan and process in place because of internal policies or external requirements or regulations. This blog presents a disaster recovery process that reestablishes the original…

Alloydb

2 min read

Alloydb

2 min read


Published in

Towards Dev

·Dec 20, 2022

evaluate() PostgreSQL Function for Evaluating Stored Expressions (Part 2)

Reusing existing function for correctness check — Syntactic correctness of stored expressions The evaluate() function is a useful approach for using stored expressions in WHERE clauses of SQL queries, as outlined in Part 1: evaluate() PostgreSQL Function for Evaluating Stored Expressions (Part 1). In Part 1, in section “Improvement”, I highlighted the fact that expressions are stored in a varchar column (since…

Postgresql

3 min read

Postgresql

3 min read


Published in

Towards Dev

·Dec 8, 2022

evaluate() PostgreSQL Function for Evaluating Stored Expressions (Part 1)

Standing on the shoulders of database giants — Query predicates as data I am working on a use case where a SQL query predicate (used in a WHERE clause) is stored in a table column as text. This predicate is used in SQL queries when selecting JSON objects from tables. A good example is customers shopping for cars. For each customer their…

Postgresql

5 min read

Postgresql

5 min read


Published in

Towards Dev

·Oct 23, 2022

JSON in PostgreSQL (Part 2: AlloyDB for PostgreSQL)

Some performance numbers when inserting JSON into AlloyDB for PostgreSQL — As outlined in Part 1 (JSON in PostgreSQL (Part 1: Setup and Measurement)) this blog shows the performance numbers I got with AlloyDB for PostgreSQL. Overview of setup The table and query is exactly the same as in Part 1. …

Alloydb

3 min read

Alloydb

3 min read


Published in

Towards Dev

·Oct 2, 2022

JSON in PostgreSQL (Part 1: Setup and Measurement)

Observations on JSONB insert elasticity — I was wondering about the JSON document insert performance in PostgreSQL and the extent it varies with document size. Overview PostgreSQL supports JSON as a data type and I was curious how insert performance changes with the size of a JSON document being inserted. To get an impression to the extent…

Postgresql

3 min read

Postgresql

3 min read


Sep 3, 2022

Implementing Queues in PostgreSQL (Part 2: AlloyDB for PostgreSQL)

Some performance numbers when deploying into AlloyDB for PostgreSQL — Recently Google Cloud made AlloyDB for PostgreSQL available for preview. This is a great opportunity to run the queue example from Part 1 in AlloyDB for PostgreSQL to get performance numbers from a brand-new production system. AlloyDB for PostgreSQL configuration I decided to use the largest deployment option available in AlloyDB for PostgreSQL currently…

Alloydb For Postgresql

4 min read

Alloydb For Postgresql

4 min read

Christoph Bussler

Christoph Bussler

127 Followers

www.real-programmer.com

Following
  • Yan Cui

    Yan Cui

  • Barack Obama

    Barack Obama

  • James Le

    James Le

  • James Beswick

    James Beswick

  • Jonathan Yue

    Jonathan Yue

See all (31)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams