toad.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Mastodon server operated by David Troy, a tech pioneer and investigative journalist addressing threats to democracy. Thoughtful participation and discussion welcome.

Administered by:

Server stats:

211
active users

#yugabytedb

0 posts0 participants0 posts today
Franck Pachot<p>Want to deploy a multi-tenant <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> app on a single global resilient infrastructure while ensuring physical isolation? <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> ✅ </p><p><a href="https://dev.to/yugabyte/physically-isolating-tenants-with-tablespaces-and-smart-drivers-in-yugabytedb-22e9" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/yugabyte/physically-iso</span><span class="invisible">lating-tenants-with-tablespaces-and-smart-drivers-in-yugabytedb-22e9</span></a></p>
Franck Pachot<p>Next hour: our Community Open hours to discuss <a href="https://mastodon.social/tags/multitenancy" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>multitenancy</span></a> with <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> and what <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> adds to it (like physical separation) <a href="https://www.youtube.com/watch?v=y03MUjSctyI" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=y03MUjScty</span><span class="invisible">I</span></a></p>
Franck Pachot<p>Due to its high performance and adaptability, <a href="https://mastodon.social/tags/RocksDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RocksDB</span></a> is an excellent choice for modern databases. Let's explore its use in <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> and how it has been customized to serve a Distributed SQL database<br><a href="https://www.linkedin.com/pulse/rocksdb-excellent-choice-modern-sql-databases-lsm-tree-franck-pachot-wze0f" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">linkedin.com/pulse/rocksdb-exc</span><span class="invisible">ellent-choice-modern-sql-databases-lsm-tree-franck-pachot-wze0f</span></a></p>
Franck Pachot<p>It has the same SQL features but different storage. What's the equivalent of <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> pageinspect in <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a>? Let's look at an example to show how MVCC is implemented:<br><a href="https://dev.to/yugabyte/whats-the-equivalent-of-pageinspect-in-yugabytedb-21nh" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/yugabyte/whats-the-equi</span><span class="invisible">valent-of-pageinspect-in-yugabytedb-21nh</span></a></p>
Franck Pachot<p>How does your DB scale with <a href="https://mastodon.social/tags/transactional" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>transactional</span></a> <a href="https://mastodon.social/tags/queues" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>queues</span></a> and <a href="https://mastodon.social/tags/outbox" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>outbox</span></a> <a href="https://mastodon.social/tags/patterns" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>patterns</span></a>? <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> shows no bloat and provides predictable performance and size</p><p><a href="https://dev.to/yugabyte/how-yugabytedb-avoids-bloat-in-outbox-pattern-42lb" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/yugabyte/how-yugabytedb</span><span class="invisible">-avoids-bloat-in-outbox-pattern-42lb</span></a></p>
Franck Pachot<p>The question of co-partitioning or interleaving arises frequently with <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a>. 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:<br><a href="https://dev.to/yugabyte/is-co-partition-or-interleave-necessary-in-distributed-sql-28g7" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/yugabyte/is-co-partitio</span><span class="invisible">n-or-interleave-necessary-in-distributed-sql-28g7</span></a></p>
Franck Pachot<p>A new blog post about <a href="https://mastodon.social/tags/Hibernate" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Hibernate</span></a> @DynamicUpdate with <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> column-level locking</p><p>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</p><p><a href="https://dev.to/yugabyte/dynamicupdate-with-column-level-locking-in-yugabytedb-and-how-to-avoid-write-skew-anomalies-379j" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/yugabyte/dynamicupdate-</span><span class="invisible">with-column-level-locking-in-yugabytedb-and-how-to-avoid-write-skew-anomalies-379j</span></a></p>
Ronald Rood<p><span class="h-card" translate="no"><a href="https://mastodon.world/@fritshoogland" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>fritshoogland</span></a></span> <span class="h-card" translate="no"><a href="https://mastodon.social/@FranckPachot" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>FranckPachot</span></a></span><br>Just to be sure, can we use the <a href="https://fosstodon.org/tags/timescaleDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>timescaleDB</span></a> extension in <a href="https://fosstodon.org/tags/yugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>yugabyteDB</span></a> ?<br>If so, it would be interesting to test that combi with <a href="https://fosstodon.org/tags/zabbix" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>zabbix</span></a></p>
Franck Pachot<p>The beauty of being PostgreSQL-compatible:<br>PL/Python in <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> <a href="https://dev.to/yugabyte/plpython-on-yugabytedb-fok" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/yugabyte/plpython-on-yu</span><span class="invisible">gabytedb-fok</span></a></p>
Franck Pachot<p>Next week Open Hours will rock, with some ideas about replacing <a href="https://mastodon.social/tags/etcd" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>etcd</span></a> with <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> in <a href="https://mastodon.social/tags/kubernetes" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>kubernetes</span></a> <br>⏰ <a href="https://www.youtube.com/watch?v=PVlQB48P2b0&amp;ab_channel=Yugabyte" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=PVlQB48P2b</span><span class="invisible">0&amp;ab_channel=Yugabyte</span></a></p>
Andreas Scherbaum<p>Today is DBA Appreciation Day</p><p>Wish all your DBAs a wonderful day!</p><p><a href="https://dbaday.org/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">dbaday.org/</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a> <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> <a href="https://mastodon.social/tags/Oracle" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Oracle</span></a> <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite</span></a> <a href="https://mastodon.social/tags/Teradata" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Teradata</span></a> <a href="https://mastodon.social/tags/SAPHANA" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SAPHANA</span></a> <a href="https://mastodon.social/tags/Neo4j" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Neo4j</span></a> <a href="https://mastodon.social/tags/Snowflake" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Snowflake</span></a> <a href="https://mastodon.social/tags/Greenplum" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Greenplum</span></a> <a href="https://mastodon.social/tags/Aerospike" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Aerospike</span></a> <a href="https://mastodon.social/tags/Ingres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Ingres</span></a> <a href="https://mastodon.social/tags/CockroachDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CockroachDB</span></a> <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> <a href="https://mastodon.social/tags/NoSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NoSQL</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a></p>
Franck Pachot<p>Approximate COUNT(DISTINCT ...) in <br><a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a> and <a href="https://mastodon.social/tags/yugabytedb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>yugabytedb</span></a> <a href="https://dev.to/yugabyte/approximate-count-distinct-in-yugabytedb-and-postgresql-with-hyperloglog-1i13…" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/yugabyte/approximate-co</span><span class="invisible">unt-distinct-in-yugabytedb-and-postgresql-with-hyperloglog-1i13…</span></a> <a href="https://mastodon.social/tags/hyperloglog" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>hyperloglog</span></a> <a href="https://mastodon.social/tags/skipscan" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>skipscan</span></a> <a href="https://mastodon.social/tags/analyze" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>analyze</span></a></p>
Franck Pachot<p>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?<br>- sharding large tables to small tablets<br>- optimizing the read path <br>---<br>RT @Yugabyte<br>Does <a href="https://mastodon.social/tags/RocksDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RocksDB</span></a> scaling limitation have an impact on <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a>? 🤔</p><p>Find out by reading our new tips &amp; tricks blog!⬇️<br><a href="https://hubs.la/Q01N3vHr0" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="">hubs.la/Q01N3vHr0</span><span class="invisible"></span></a><br><a href="https://twitter.com/Yugabyte/status/1652328401212960769" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">twitter.com/Yugabyte/status/16</span><span class="invisible">52328401212960769</span></a></p>
Franck Pachot<p>On Wednesday. This is live, so join with your questions 🙏 <br>---<br>RT @xgeeksio<br>📢 Calling all cloud and database enthusiasts! 🌩️🗄️<br> <br>Don't miss out on this live stream with <span class="h-card"><a href="https://mastodon.social/@FranckPachot" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>FranckPachot</span></a></span> as he discusses the innovative database architecture of YugabyteDB. </p><p>Join us on Twitter or here: <a href="https://youtu.be/UH575nudjpg" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="">youtu.be/UH575nudjpg</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/xgeeks" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>xgeeks</span></a> <a href="https://mastodon.social/tags/cloudnative" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>cloudnative</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> <br><a href="https://twitter.com/xgeeksio/status/1650547139221630979" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">twitter.com/xgeeksio/status/16</span><span class="invisible">50547139221630979</span></a></p>
Franck Pachot<p>A great reference for COPY FROM command in 🐘🚀 <br>---<br>RT @Yugabyte<br>⏰Next YFTT: LIVE in ONE HOUR!⏰</p><p>Join our @Yugabyte experts as they discuss and compare various bulk data loading options for <a href="https://mastodon.social/tags/YSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YSQL</span></a> in <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> such as using the COPY command or yb-voyager.🚀</p><p>Register: <a href="https://hubs.la/Q01Mdqh90" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="">hubs.la/Q01Mdqh90</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/distributedsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>distributedsql</span></a> <br><a href="https://twitter.com/Yugabyte/status/1649435323976359936" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">twitter.com/Yugabyte/status/16</span><span class="invisible">49435323976359936</span></a></p>
Bob Bryla<p><a href="https://noc.social/tags/OracleDatabase" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OracleDatabase</span></a> 19c bug -- GROUP BY GROUPING SETS -- either triggers ORA-00600, ORA-00979 with our released code. Back in 19.8 (over 2 years ago!) Oracle had a patch to fix the issue -- BUT will not backport (frontport) the patch to 19.18, because "it's too risky". Bug still exists in 21c, 23c. 🤬 Not doable to rewrite 1000s of released queries.<br>Getting so close to wearing the <a href="https://noc.social/tags/YugaByteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugaByteDB</span></a> hat full time. 🤔</p>
Franck Pachot<p>Let's talk scalable sequences next week <br>---<br>RT @Yugabyte<br>Next YFTT: Friday 10th Mar – 9:30am PT🚀</p><p>Join our @Yugabyte experts as they discuss the best practices for scalable sequences and <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> optimizations for it.</p><p>Join us: <a href="https://hubs.la/Q01F5-N50" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="">hubs.la/Q01F5-N50</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/distributedsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>distributedsql</span></a> <br><a href="https://twitter.com/Yugabyte/status/1631722694801596431" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">twitter.com/Yugabyte/status/16</span><span class="invisible">31722694801596431</span></a></p>
Franck Pachot<p><span class="h-card"><a href="https://hachyderm.io/@hazelweakly" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>hazelweakly</span></a></span> For the PostgreSQL part, it can scale on <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a> <br><a href="https://dev.to/yugabyte/mastodon-on-yugabytedb-10o2" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/yugabyte/mastodon-on-yu</span><span class="invisible">gabytedb-10o2</span></a></p>
Franck Pachot<p>🚀knex.js with @Yugabyte​DB because it is postgres compatible <br>---<br>RT @Yugabyte<br>Check out this new blog from @Yugabyte expert Brett Hoyer, which investigates how the <a href="https://mastodon.social/tags/Knex" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Knex</span></a>.js query builder can be used to enhance the development experience with <a href="https://mastodon.social/tags/Node" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Node</span></a>.js and <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>YugabyteDB</span></a>.🚀⬇️<br><a href="https://hubs.la/Q01yzMv_0" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="">hubs.la/Q01yzMv_0</span><span class="invisible"></span></a><br><a href="https://twitter.com/Yugabyte/status/1616104195932782594" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">twitter.com/Yugabyte/status/16</span><span class="invisible">16104195932782594</span></a></p>
Alby Hernández<p><span class="h-card"><a href="https://mastodon.social/@FranckPachot" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>FranckPachot</span></a></span> Hey there! I have an existencial doubt about <a href="https://mastodon.social/tags/yugabytedb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>yugabytedb</span></a> 🙃 how big would you say a company needs to be, to really take the advantage of Yugabyte as DB? WDYT about it?</p>