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.
#yugabytedb
Even though I am not attending AWS reInvent this year, I am still following the product announcements. This one is pretty cool. I have been ramping up on my distributed SQL skills over the past year with both CockroachDB and YugabyteDB. I will need to free up some time to try this one out. #AWS #AWSreInvent #Aurora #CockroachDB #YugabyteDB #DistributedSQL #DSQL
https://aws.amazon.com/blogs/database/introducing-amazon-aurora-dsql/
Выбираю 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
Next-Generation Databases: NewSQL, Distributed SQL, and Beyond
#Database #DevOps #NewSQL #DistributedSQL #NoSQL #GoogleSpanner #CockroachDB #VoltDB #YugaByteDB #Citus #InfluxDB #Neo4j #ArangoDB
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 ?
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!
#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).
Client Info
Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst