#DOAG2025 hat nur noch wenige Aussteller :-( Lichtblick: #Yugabyte
Find me tomorrow - same time, same place. I put some of the #documentdb stickers at the #Yugabyte booth or find me wandering halls #kubecon
If you like to learn more about #documentdb I am speaking at two #kubecon events Monday: #AzureDay at the Microsoft office and after lunch at the #DistributedSQLDay put on by #Yugabyte - hope to see you.

The best time to start blogging is to not stop blogging in the first place. The next best time is today.

Here's a syndication of a post from the ComplyAdvantage Technology Blog to kicks things off.

https://mark.allanson.org/blog/dss-2024-ca-lessons/

#Yugabyte #YugabyteDB #DistributedSQL #ComplyAdvantage

Lessons from building AML and Fraud Detection with Distributed SQL - DSS 2024

The personal website of Mark Allanson

Container Attached Storage (CAS) and Container Storage Interface (CSI) are the most important terms when it comes to Kubernetes and stateful workloads like databases (such as #postgresql, #yugabyte, and others). We explain them - just for you!

https://www.simplyblock.io/post/container-attached-storage-and-container-storage-interface-the-building-blocks-of-kubernetes-storage

Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!

The πŸŽ™οΈ is available on Spotify, iTunes, Pandora, Amazon Music, and more.

πŸŽ₯πŸ‘‰ https://youtu.be/1EAKqwcP2SY

#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql

EP 02: Franck Pachot from Yugabyte - Cloud Commute by simplyblock

YouTube
Using #PostgreSQL RLS for multi-tenancy SaaS is quite common, but some users want to access a list of tenants. Here's how to do it efficiently (and leveraging loose index scan in #Yugabyte​DB)
https://dev.to/yugabyte/postgresql-row-level-security-with-an-array-of-tenants-2136
Row Level Security with an ARRAY of tenants set in session parameter

One way to effectively implement multitenancy for SaaS while optimizing resources and maintenance is...

DEV Community
Batching remote reads/writes is how #Yugabyte​DB can provide elasticity with high performance. An example of Foreign Key checking:
https://dev.to/yugabyte/foreign-keys-on-distributed-sql-dont-worry-it-scales-2g0g
Foreign Keys on Distributed SQL: don't worry, it scales

In a previous post I demonstrated that joins across nodes can add some latency but are still scalable...

DEV Community

An example of read restart, which is how Oracle Database or #Yugabyte​DB avoids serialization errors in Read Committed, without inconsistent read time:

https://dev.to/yugabyte/dirty-writes-insert-on-conflict-do-update-read-committed-isolation-level-and-lost-update-13hk

Dirty Writes, INSERT ... ON CONFLICT DO UPDATE, Read Committed Isolation Level and Lost Update

SQL isolation levels mainly affect reads, not writes. However, it's important to consider the...

DEV Community
What? There's no Inverted Join in #Yugabyte​DB?
Of course not. That's not how SQL works.
If you want a Nested Loop to an Inverted Index, do like in PostgreSQL: declare a GIN index and let the DB choose the join method:
https://dev.to/yugabyte/inner-inverted-join-in-yugabytedb-postgresql-g22
Inner Inverted Join in YugabyteDB & PostgreSQL

In YugabyteDB, we have the same Join Methods as PostgreSQL, that are found in all SQL databases:...

DEV Community