what is a serverless database ?

benefits of using a serverless database ?

When to use serverless database ?

based on https://university.cockroachlabs.com/courses/course-v1:crl+fundamentals-of-crdb-for-java-devs+self-paced/about

Talk https://www.youtube.com/watch?v=VovUiQJJvKk

PostgreSQL Services: some limitations

Scale

• vertical scale via machien types
• horizontal scale via complex manuel sharding

Resilience

• active/passive complexities
• RTOP/RPO and event remediation difficulties

Multi-Region

• synchronization creates integrity issues
• complex and costly to manage/maintain

start cluster with minikube

set port forwarding

https://stackoverflow.com/questions/57427797/how-do-i-connect-to-my-local-kubernetes-cockroachdb-with-dbeaver

open dbeaver and add connection string jdbc:postgresql://localhost:26257/defaultdb

use user root with no password

add some easy tasks to get familier with the db

how to set up a cockroach db cluster with the command line?

Summarize the following topics:

• THE DUAL-WRITE DILEMMA
  Frequently microservices need to update two separate systems. Eg. Database + Message Queue

This is known as the Dual-Write problem. It is a potential source of inconsistency.

Avoid the Dual-Write problem using a Transactional Outbox.

• See how CockroachDB's Change Data Capture can simplify your implementation

https://www.cockroachlabs.com/docs/stable/architecture/glossary.html

see the introduction course and its provided information