Fosstodon

Mark AllansonThe 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.<a href="https://mark.allanson.org/blog/dss-2024-ca-lessons/" rel="nofollow noopener" translate="no" target="_blank">https://mark.allanson.org/blog/dss-2024-ca-lessons/</a><a href="https://hachyderm.io/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a> <a href="https://hachyderm.io/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#YugabyteDB</a> <a href="https://hachyderm.io/tags/DistributedSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#DistributedSQL</a> <a href="https://hachyderm.io/tags/ComplyAdvantage" class="mention hashtag" rel="nofollow noopener" target="_blank">#ComplyAdvantage</a>

simplyblockContainer 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 <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a>, <a href="https://mastodon.social/tags/yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#yugabyte</a>, and others). We explain them - just for you!<a href="https://www.simplyblock.io/post/container-attached-storage-and-container-storage-interface-the-building-blocks-of-kubernetes-storage" rel="nofollow noopener" translate="no" target="_blank">https://www.simplyblock.io/post/container-attached-storage-and-container-storage-interface-the-building-blocks-of-kubernetes-storage</a>

simplyblockGuest <a href="https://mastodon.social/@FranckPachot" class="u-url mention" rel="nofollow noopener" target="_blank">@FranckPachot</a> from <a href="https://mastodon.social/tags/yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#yugabyte</a> joins our very own @noctarius2k in this episode of the weekly, 20 min <a href="https://mastodon.social/tags/CloudCommute" class="mention hashtag" rel="nofollow noopener" target="_blank">#CloudCommute</a> <a href="https://mastodon.social/tags/podcast" class="mention hashtag" rel="nofollow noopener" target="_blank">#podcast</a>, talking about <a href="https://mastodon.social/tags/distributedsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#distributedsql</a>, <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a> , <a href="https://mastodon.social/tags/vectordatabases" class="mention hashtag" rel="nofollow noopener" target="_blank">#vectordatabases</a>, and more. Tune in!The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.🎥👉 <a href="https://youtu.be/1EAKqwcP2SY" rel="nofollow noopener" translate="no" target="_blank">https://youtu.be/1EAKqwcP2SY</a><a href="https://mastodon.social/tags/vectordatabase" class="mention hashtag" rel="nofollow noopener" target="_blank">#vectordatabase</a> <a href="https://mastodon.social/tags/vectorsearch" class="mention hashtag" rel="nofollow noopener" target="_blank">#vectorsearch</a> <a href="https://mastodon.social/tags/vectordb" class="mention hashtag" rel="nofollow noopener" target="_blank">#vectordb</a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://mastodon.social/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a> <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://mastodon.social/tags/postgressql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgressql</a>

Franck PachotUsing <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> 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 <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB) <a href="https://dev.to/yugabyte/postgresql-row-level-security-with-an-array-of-tenants-2136" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/postgresql-row-level-security-with-an-array-of-tenants-2136</a>

Franck PachotBatching remote reads/writes is how <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB can provide elasticity with high performance. An example of Foreign Key checking: <a href="https://dev.to/yugabyte/foreign-keys-on-distributed-sql-dont-worry-it-scales-2g0g" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/foreign-keys-on-distributed-sql-dont-worry-it-scales-2g0g</a>

Franck PachotAn example of read restart, which is how Oracle Database or <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB avoids serialization errors in Read Committed, without inconsistent read time:<a href="https://dev.to/yugabyte/dirty-writes-insert-on-conflict-do-update-read-committed-isolation-level-and-lost-update-13hk" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/dirty-writes-insert-on-conflict-do-update-read-committed-isolation-level-and-lost-update-13hk</a>

Franck PachotWhat? There's no Inverted Join in <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>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: <a href="https://dev.to/yugabyte/inner-inverted-join-in-yugabytedb-postgresql-g22" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/inner-inverted-join-in-yugabytedb-postgresql-g22</a>

Franck PachotIf you want to be sure that your SELECT COUNT(*) is optimal in <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB, check the execution plan. There are many optimisations where it uses PostgreSQL with additional pushdowns to reduce the latency <a href="https://dev.to/yugabyte/fast-select-count-in-yugabytedb-464h" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/fast-select-count-in-yugabytedb-464h</a>

Franck PachotThe benefits of hash-sharding (to avoid hotspots) and range-sharding (to reduce reads) can be combined in <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB, thanks to LSM-Tree scan optimization and PostgreSQL features: <a href="https://dev.to/yugabyte/scalable-range-sharding-with-yugabytedb-1o51" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/scalable-range-sharding-with-yugabytedb-1o51</a>

Franck Pachot<a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB uses <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> query layer plugged on top of a cloud-native transactional distributed store. In addition to scaling out, it's the occasion to address some PostgreSQL problems (bloat, vacuum, connection processes, HA, upgrades...) <a href="https://www.yugabyte.com/blog/improve-postgresql/" rel="nofollow noopener" translate="no" target="_blank">https://www.yugabyte.com/blog/improve-postgresql/</a>

Franck Pachot🔥Curious if @Citusdata is Distributed SQL like <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB?💡Nope! Citus rocks sharding over PostgreSQL databases, but it's not a SQL database on its own. Remember, cross-shard reads through Citus coordinator aren't ACID but eventually consistent <a href="https://dev.to/yugabyte/citus-is-not-acid-but-eventually-consistent-3711" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/citus-is-not-acid-but-eventually-consistent-3711</a>

Franck PachotCounters in SQL 🤓 I tested <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB compaction with this use-case 👉 no vacuum, no bloat 🎶<a href="https://dev.to/yugabyte/in-memory-counters-with-yugabytedb-2p54" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/in-memory-counters-with-yugabytedb-2p54</a>

Franck PachotYou can easily build and install many PostgreSQL extensions on <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB - here is an example with pg-hostname: <a href="https://dev.to/yugabyte/pg-hostname-on-yugabytedb-compiled-and-installed-directly-on-the-server-15id" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/pg-hostname-on-yugabytedb-compiled-and-installed-directly-on-the-server-15id</a>

Franck PachotNew blog post: <a href="https://mastodon.social/tags/SQLPage" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLPage</a>. If you💗SQL you can build your web app presentation layer with SQL declarations. What if the DB is unavailable? Just use <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB: It is Distributed PostgreSQL, with no downtime during failures or upgrades 🚀<a href="https://dev.to/yugabyte/sql-for-low-code-applications-sqlpage-lmk" rel="nofollow noopener" translate="no" target="_blank">https://dev.to/yugabyte/sql-for-low-code-applications-sqlpage-lmk</a>

Franck PachotBecause I've seen some silly benchmarks comparing 🍏to 🍊, I had a look at <a href="https://mastodon.social/tags/hammerdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#hammerdb</a> on <a href="https://mastodon.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>DB. With <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a>-compatible databases, you can know what you run

Foojay.ioContinuing the series, <a href="https://mastodon.world/@fritshoogland" class="u-url mention" rel="nofollow noopener" target="_blank">@fritshoogland</a> of <a href="https://foojay.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a> looks look into batching and how <a href="https://foojay.social/tags/Java" class="mention hashtag" rel="nofollow noopener" target="_blank">#Java</a> <a href="https://foojay.social/tags/JDBC" class="mention hashtag" rel="nofollow noopener" target="_blank">#JDBC</a> connections to <a href="https://foojay.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> work, so as to understand how to optimally implement them. <a href="https://foojay.io/today/a-dissection-of-java-jdbc-to-postgresql-connections-part-2-batching" rel="nofollow noopener" target="_blank">https://foojay.io/today/a-dissection-of-java-jdbc-to-postgresql-connections-part-2-batching</a> <a href="https://foojay.social/tags/foojaytip" class="mention hashtag" rel="nofollow noopener" target="_blank">#foojaytip</a>

Frits Hoogland<a href="https://dev.to/yugabyte/setup-ssl-for-ysql-in-yugabyte-manually-7hd" rel="nofollow noopener" target="_blank">https://dev.to/yugabyte/setup-ssl-for-ysql-in-yugabyte-manually-7hd</a> <a href="https://mastodon.world/tags/yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#yugabyte</a>

Foojay.ioThe periodic Foojay :foojay: big overview, analysis, upcoming features and more, announcing the participation of <a href="https://bird.makeup/users/sonatype" class="u-url mention" rel="nofollow noopener" target="_blank">@sonatype</a>, <a href="https://foojay.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a>, <a href="https://foojay.social/tags/ChronicleSoftware" class="mention hashtag" rel="nofollow noopener" target="_blank">#ChronicleSoftware</a>, <a href="https://foojay.social/tags/OmniFishEE" class="mention hashtag" rel="nofollow noopener" target="_blank">#OmniFishEE</a>, and <a href="https://mastodon.social/@Gradle" class="u-url mention" rel="nofollow noopener" target="_blank">@Gradle</a>! Check it out here: <a href="https://foojay.io/today/foojay-status-report-july-2023/" rel="nofollow noopener" target="_blank">https://foojay.io/today/foojay-status-report-july-2023/</a><a href="https://foojay.social/tags/foojaytip" class="mention hashtag" rel="nofollow noopener" target="_blank">#foojaytip</a>

Joey de Villa 🪗It’s garbage day in many parts of Tampa, and it’s garbage night at Tampa Java User Group, where YugaByte’s Denis Magda’s talk is about apps leaving trash outside the heap and even outside the Java runtime. Be there and clean up your act!<a href="https://mastodon.cloud/tags/Java" class="mention hashtag" rel="nofollow noopener" target="_blank">#Java</a> <a href="https://mastodon.cloud/tags/JVM" class="mention hashtag" rel="nofollow noopener" target="_blank">#JVM</a> <a href="https://mastodon.cloud/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://mastodon.cloud/tags/datyabases" class="mention hashtag" rel="nofollow noopener" target="_blank">#datyabases</a> <a href="https://mastodon.cloud/tags/YugaByte" class="mention hashtag" rel="nofollow noopener" target="_blank">#YugaByte</a> <a href="https://mastodon.cloud/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://mastodon.cloud/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#programming</a> <a href="https://mastodon.cloud/tags/meetup" class="mention hashtag" rel="nofollow noopener" target="_blank">#meetup</a> <a href="https://mastodon.cloud/tags/Tampa" class="mention hashtag" rel="nofollow noopener" target="_blank">#Tampa</a> <a href="https://mastodon.cloud/tags/TampaBay" class="mention hashtag" rel="nofollow noopener" target="_blank">#TampaBay</a><a href="https://www.meetup.com/tampa-jug/events/292756241/" rel="nofollow noopener" target="_blank">https://www.meetup.com/tampa-jug/events/292756241/</a>

Foojay.ioWhen using <a href="https://foojay.social/tags/Java" class="mention hashtag" rel="nofollow noopener" target="_blank">#Java</a> <a href="https://foojay.social/tags/JDBC" class="mention hashtag" rel="nofollow noopener" target="_blank">#JDBC</a> with <a href="https://foojay.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a>, know the difference between simple and extended protocols, how to recognize protocol implementations, and more, with <a href="https://mastodon.world/@fritshoogland" class="u-url mention" rel="nofollow noopener" target="_blank">@fritshoogland</a> of <a href="https://foojay.social/tags/Yugabyte" class="mention hashtag" rel="nofollow noopener" target="_blank">#Yugabyte</a> on Foojay :foojay: Today!<a href="https://foojay.io/today/a-dissection-of-java-jdbc-to-postgresql-connections/" rel="nofollow noopener" target="_blank">https://foojay.io/today/a-dissection-of-java-jdbc-to-postgresql-connections/</a><a href="https://foojay.social/tags/foojaytip" class="mention hashtag" rel="nofollow noopener" target="_blank">#foojaytip</a>

Recent searches

Search options

Administered by:

Server stats:

#yugabyte