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