#yugabytedb — Public Fediverse posts

Hier noch der Architektur-Überblick der #YugabyteDB (Quelle: Wikipedia)

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

Выбираю Open Source БД для себя

Задача такая: искал Open Source БД для своего пет-проекта. Решил посмотреть в интернете новые решения в рамках БД. После чтения статей и отбора из 6-7 БД остались три (3), которые понравились лично мне. Больше ничего путного не нашел. Почему именно эти? Во-первых, они Open Source, а во-вторых, у них есть ответы на два главных моих вопроса «Для чего это нужно?» и «Работает ли из коробки?» Давайте покажу на примерах.

https://habr.com/ru/companies/alfa/articles/854400/

#bd #dolt #postgresql #yugabytedb #mailsearch

I’ll be stepping way out of my comfort zone and presenting at the #DistributedSQL Summit on November 12 on behalf of my employer - #ComplyAdvantage, organised by our key partner, #YugabyteDB.

Data is central to our solutions at ComplyAdvantage and in the session I’ll share some of the lessons we’ve learned while harnessing distributed database technology to address the critical challenges of anti-money laundering and fraud detection.

Register: https://events.ringcentral.com/events/distributed-sql-summit-2024/registration

#FraudDetection #WorkPost

I had a lot of fun showcasing and explaining #Pongo with @FranckPachot on the #YugabyteDB stream.

We went together to discuss why #Pongo uses #PostgreSQL. Seeing live how that plays with #nodejs and #typescript

We also saw some SQL and explained how JSONB storage works, among many other things.

Check it out here: https://www.youtube.com/watch?v=p-6fpV_GDEs

Leave the feedback afterwards.

Boosting is also appreciated!

Want to deploy a multi-tenant #PostgreSQL app on a single global resilient infrastructure while ensuring physical isolation? #YugabyteDB ✅

https://dev.to/yugabyte/physically-isolating-tenants-with-tablespaces-and-smart-drivers-in-yugabytedb-22e9

Next hour: our Community Open hours to discuss #multitenancy with #PostgreSQL and what #YugabyteDB adds to it (like physical separation) https://www.youtube.com/watch?v=y03MUjSctyI

Due to its high performance and adaptability, #RocksDB is an excellent choice for modern databases. Let's explore its use in #YugabyteDB and how it has been customized to serve a Distributed SQL database
https://www.linkedin.com/pulse/rocksdb-excellent-choice-modern-sql-databases-lsm-tree-franck-pachot-wze0f

It has the same SQL features but different storage. What's the equivalent of #PostgreSQL pageinspect in #YugabyteDB? Let's look at an example to show how MVCC is implemented:
https://dev.to/yugabyte/whats-the-equivalent-of-pageinspect-in-yugabytedb-21nh

How does your DB scale with #transactional #queues and #outbox #patterns? #YugabyteDB shows no bloat and provides predictable performance and size

https://dev.to/yugabyte/how-yugabytedb-avoids-bloat-in-outbox-pattern-42lb

The question of co-partitioning or interleaving arises frequently with #YugabyteDB. Often it comes from a premature optimization idea without a real need. Distributed joins are not as bad as you may think. Look at an EXPLAIN ANALYZE of it if you doubt:
https://dev.to/yugabyte/is-co-partition-or-interleave-necessary-in-distributed-sql-28g7

A new blog post about #Hibernate @DynamicUpdate with #YugabyteDB column-level locking

TL;DR: as always, a read-then-write transaction needs either explicit locking SELECT FOR SHARE or isolation level SERIALIZABLE to prevent write skew anomalies

https://dev.to/yugabyte/dynamicupdate-with-column-level-locking-in-yugabytedb-and-how-to-avoid-write-skew-anomalies-379j

@mirabilos #Oracle, #MariaDB und #YugabyteDB runden das ebenfalls auf, wie #PostgreSQL.

#SQLite und #SQLServer runden es ab.

An der Stelle würde ich mich auf gar nichts verlassen und einfach ceil() oder floor() einbauen.

I've been looking at distributed #sql #databases for a while, like #cockroachdb and #yugabytedb. Does anyone have any experience running these on prod? What are the foot guns one might encounter while running these databases ?

The beauty of being PostgreSQL-compatible:
PL/Python in #YugabyteDB https://dev.to/yugabyte/plpython-on-yugabytedb-fok

Next week Open Hours will rock, with some ideas about replacing #etcd with #YugabyteDB in #kubernetes
⏰ https://www.youtube.com/watch?v=PVlQB48P2b0&ab_channel=Yugabyte

Today is DBA Appreciation Day

Wish all your DBAs a wonderful day!

https://dbaday.org/

#PostgreSQL #SQLServer #MySQL #MariaDB #Oracle #DB2 #SQLite #Teradata #SAPHANA #Neo4j #Snowflake #Greenplum #Aerospike #Ingres #CockroachDB #YugabyteDB #NoSQL #Database

Approximate COUNT(DISTINCT ...) in
#postgresql and #yugabytedb https://dev.to/yugabyte/approximate-count-distinct-in-yugabytedb-and-postgresql-with-hyperloglog-1i13… #hyperloglog #skipscan #analyze

For all #yugabytedb users out there: the new #vagrant boxes for YugabyteDB version 2.17.3 are out: https://app.vagrantup.com/FritsHoogland (alma 8.7 and alma 9.1).

Yes @Yugabyte stores shards as RocksDB, which is popular for small, embedded, write intensive, databases. Then what's the magic using it for large Distributed SQL?
- sharding large tables to small tablets
- optimizing the read path
---
RT @Yugabyte
Does #RocksDB scaling limitation have an impact on #YugabyteDB? 🤔

Find out by reading our new tips & tricks blog!⬇️
https://hubs.la/Q01N3vHr0
https://twitter.com/Yugabyte/status/1652328401212960769

On Wednesday. This is live, so join with your questions 🙏
---
RT @xgeeksio
📢 Calling all cloud and database enthusiasts! 🌩️🗄️

Don't miss out on this live stream with @FranckPachot as he discusses the innovative database architecture of YugabyteDB.

Join us on Twitter or here: https://youtu.be/UH575nudjpg

#xgeeks #cloudnative #sql #database #YugabyteDB
https://twitter.com/xgeeksio/status/1650547139221630979

A great reference for COPY FROM command in 🐘🚀
---
RT @Yugabyte
⏰Next YFTT: LIVE in ONE HOUR!⏰

Join our @Yugabyte experts as they discuss and compare various bulk data loading options for #YSQL in #YugabyteDB such as using the COPY command or yb-voyager.🚀

Register: https://hubs.la/Q01Mdqh90

#distributedsql
https://twitter.com/Yugabyte/status/1649435323976359936

"How to sniff PostgreSQL traffic" by @fritshoogland #DEVCommunity https://dev.to/yugabyte/how-to-sniff-postgresql-traffic-3idm #yugabytedb

"Simple port scanning without a port scanner" by @fritshoogland #DEVCommunity https://dev.to/yugabyte/simple-port-scanning-without-a-port-scanner-3mj7 #yugabytedb

"The anatomy of XFS fsync()" by @fritshoogland #DEVCommunity https://dev.to/yugabyte/the-anatomy-of-xfs-fsync-4ael #YugabyteDB

"YugabyteDB: fs_data_dirs" by @fritshoogland #DEVCommunity https://dev.to/yugabyte/yugabytedb-fsdatadirs-fno #yugabytedb

"YugabyteDB yb_stats: table and tablet detail" by @fritshoogland #DEVCommunity https://dev.to/yugabyte/yugabytedb-ybstats-table-and-tablet-detail-56kj #yugabyteDB

We’ve created a set of simple, usable examples to use #rust to connect to #yugabytedb YCQL (Cassandra compatible API), to use the database cluster at low latency. Any comments, corrections, additions are welcomed! https://github.com/YugabyteDB-Samples/yugabytedb-rust-examples