Fosstodon

0 posts0 participants0 posts today

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 noreferrer" 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 noreferrer" target="_blank">#Yugabyte</a> <a href="https://hachyderm.io/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> <a href="https://hachyderm.io/tags/DistributedSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DistributedSQL</a> <a href="https://hachyderm.io/tags/ComplyAdvantage" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ComplyAdvantage</a>

HabrВыбираю Open Source БД для себяЗадача такая: искал Open Source БД для своего пет-проекта. Решил посмотреть в интернете новые решения в рамках БД. После чтения статей и отбора из 6-7 БД остались три (3), которые понравились лично мне. Больше ничего путного не нашел. Почему именно эти? Во-первых, они Open Source, а во-вторых, у них есть ответы на два главных моих вопроса «Для чего это нужно?» и «Работает ли из коробки?» Давайте покажу на примерах.<a href="https://habr.com/ru/companies/alfa/articles/854400/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://habr.com/ru/companies/alfa/articles/854400/</a><a href="https://zhub.link/tags/bd" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#bd</a> <a href="https://zhub.link/tags/dolt" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dolt</a> <a href="https://zhub.link/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://zhub.link/tags/yugabytedb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#yugabytedb</a> <a href="https://zhub.link/tags/mailsearch" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mailsearch</a>

Mark AllansonI’ll be stepping way out of my comfort zone and presenting at the <a href="https://hachyderm.io/tags/DistributedSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DistributedSQL</a> Summit on November 12 on behalf of my employer - <a href="https://hachyderm.io/tags/ComplyAdvantage" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ComplyAdvantage</a>, organised by our key partner, <a href="https://hachyderm.io/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a>.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: <a href="https://events.ringcentral.com/events/distributed-sql-summit-2024/registration" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://events.ringcentral.com/events/distributed-sql-summit-2024/registration</a><a href="https://hachyderm.io/tags/FraudDetection" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#FraudDetection</a> <a href="https://hachyderm.io/tags/WorkPost" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WorkPost</a>

Oskar Dudycz 🇺🇦✊I had a lot of fun showcasing and explaining <a href="https://hachyderm.io/tags/Pongo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Pongo</a> with <a href="https://mastodon.social/@FranckPachot" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@FranckPachot</a> on the <a href="https://hachyderm.io/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> stream.We went together to discuss why <a href="https://hachyderm.io/tags/Pongo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Pongo</a> uses <a href="https://hachyderm.io/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a>. Seeing live how that plays with <a href="https://hachyderm.io/tags/nodejs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#nodejs</a> and <a href="https://hachyderm.io/tags/typescript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#typescript</a> We also saw some SQL and explained how JSONB storage works, among many other things.Check it out here: <a href="https://www.youtube.com/watch?v=p-6fpV_GDEs" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.youtube.com/watch?v=p-6fpV_GDEs</a>Leave the feedback afterwards.Boosting is also appreciated!

Franck PachotWant to deploy a multi-tenant <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</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 noreferrer" target="_blank">#YugabyteDB</a> ✅ <a href="https://dev.to/yugabyte/physically-isolating-tenants-with-tablespaces-and-smart-drivers-in-yugabytedb-22e9" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dev.to/yugabyte/physically-isolating-tenants-with-tablespaces-and-smart-drivers-in-yugabytedb-22e9</a>

Franck PachotNext hour: our Community Open hours to discuss <a href="https://mastodon.social/tags/multitenancy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#multitenancy</a> with <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> and what <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> adds to it (like physical separation) <a href="https://www.youtube.com/watch?v=y03MUjSctyI" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.youtube.com/watch?v=y03MUjSctyI</a>

Franck PachotDue to its high performance and adaptability, <a href="https://mastodon.social/tags/RocksDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RocksDB</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 noreferrer" target="_blank">#YugabyteDB</a> and how it has been customized to serve a Distributed SQL database <a href="https://www.linkedin.com/pulse/rocksdb-excellent-choice-modern-sql-databases-lsm-tree-franck-pachot-wze0f" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.linkedin.com/pulse/rocksdb-excellent-choice-modern-sql-databases-lsm-tree-franck-pachot-wze0f</a>

Franck PachotIt 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 noreferrer" target="_blank">#PostgreSQL</a> pageinspect in <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a>? Let's look at an example to show how MVCC is implemented: <a href="https://dev.to/yugabyte/whats-the-equivalent-of-pageinspect-in-yugabytedb-21nh" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dev.to/yugabyte/whats-the-equivalent-of-pageinspect-in-yugabytedb-21nh</a>

Franck PachotHow does your DB scale with <a href="https://mastodon.social/tags/transactional" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#transactional</a> <a href="https://mastodon.social/tags/queues" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#queues</a> and <a href="https://mastodon.social/tags/outbox" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#outbox</a> <a href="https://mastodon.social/tags/patterns" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#patterns</a>? <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> shows no bloat and provides predictable performance and size<a href="https://dev.to/yugabyte/how-yugabytedb-avoids-bloat-in-outbox-pattern-42lb" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dev.to/yugabyte/how-yugabytedb-avoids-bloat-in-outbox-pattern-42lb</a>

Franck PachotThe question of co-partitioning or interleaving arises frequently with <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</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: <a href="https://dev.to/yugabyte/is-co-partition-or-interleave-necessary-in-distributed-sql-28g7" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dev.to/yugabyte/is-co-partition-or-interleave-necessary-in-distributed-sql-28g7</a>

Franck PachotA new blog post about <a href="https://mastodon.social/tags/Hibernate" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Hibernate</a> @DynamicUpdate with <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> column-level lockingTL;DR: as always, a read-then-write transaction needs either explicit locking SELECT FOR SHARE or isolation level SERIALIZABLE to prevent write skew anomalies<a href="https://dev.to/yugabyte/dynamicupdate-with-column-level-locking-in-yugabytedb-and-how-to-avoid-write-skew-anomalies-379j" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dev.to/yugabyte/dynamicupdate-with-column-level-locking-in-yugabytedb-and-how-to-avoid-write-skew-anomalies-379j</a>

Andreas Scherbaum<a href="https://toot.mirbsd.org/@mirabilos" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@mirabilos</a> <a href="https://mastodon.social/tags/Oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Oracle</a>, <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MariaDB</a> und <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> runden das ebenfalls auf, wie <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a>.<a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> und <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a> runden es ab.An der Stelle würde ich mich auf gar nichts verlassen und einfach ceil() oder floor() einbauen.

Mr.MenonI've been looking at distributed <a href="https://hachyderm.io/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://hachyderm.io/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databases</a> for a while, like <a href="https://hachyderm.io/tags/cockroachdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#cockroachdb</a> and <a href="https://hachyderm.io/tags/yugabytedb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#yugabytedb</a>. Does anyone have any experience running these on prod? What are the foot guns one might encounter while running these databases ?

Franck PachotThe beauty of being PostgreSQL-compatible: PL/Python in <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> <a href="https://dev.to/yugabyte/plpython-on-yugabytedb-fok" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dev.to/yugabyte/plpython-on-yugabytedb-fok</a>

Franck PachotNext week Open Hours will rock, with some ideas about replacing <a href="https://mastodon.social/tags/etcd" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#etcd</a> with <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> in <a href="https://mastodon.social/tags/kubernetes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#kubernetes</a> ⏰ <a href="https://www.youtube.com/watch?v=PVlQB48P2b0&ab_channel=Yugabyte" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.youtube.com/watch?v=PVlQB48P2b0&ab_channel=Yugabyte</a>

Andreas ScherbaumToday is DBA Appreciation DayWish all your DBAs a wonderful day!<a href="https://dbaday.org/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dbaday.org/</a><a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a> <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MySQL</a> <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MariaDB</a> <a href="https://mastodon.social/tags/Oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Oracle</a> <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DB2</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/Teradata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Teradata</a> <a href="https://mastodon.social/tags/SAPHANA" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SAPHANA</a> <a href="https://mastodon.social/tags/Neo4j" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Neo4j</a> <a href="https://mastodon.social/tags/Snowflake" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Snowflake</a> <a href="https://mastodon.social/tags/Greenplum" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Greenplum</a> <a href="https://mastodon.social/tags/Aerospike" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Aerospike</a> <a href="https://mastodon.social/tags/Ingres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Ingres</a> <a href="https://mastodon.social/tags/CockroachDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CockroachDB</a> <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> <a href="https://mastodon.social/tags/NoSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#NoSQL</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Database</a>

Franck PachotApproximate COUNT(DISTINCT ...) in <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> and <a href="https://mastodon.social/tags/yugabytedb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#yugabytedb</a> <a href="https://dev.to/yugabyte/approximate-count-distinct-in-yugabytedb-and-postgresql-with-hyperloglog-1i13…" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dev.to/yugabyte/approximate-count-distinct-in-yugabytedb-and-postgresql-with-hyperloglog-1i13…</a> <a href="https://mastodon.social/tags/hyperloglog" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#hyperloglog</a> <a href="https://mastodon.social/tags/skipscan" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#skipscan</a> <a href="https://mastodon.social/tags/analyze" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#analyze</a>

Frits HooglandFor all <a href="https://mastodon.world/tags/yugabytedb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#yugabytedb</a> users out there: the new <a href="https://mastodon.world/tags/vagrant" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#vagrant</a> boxes for YugabyteDB version 2.17.3 are out: <a href="https://app.vagrantup.com/FritsHoogland" rel="nofollow noopener noreferrer" target="_blank">https://app.vagrantup.com/FritsHoogland</a> (alma 8.7 and alma 9.1).

Franck PachotYes @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 <a href="https://mastodon.social/tags/RocksDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RocksDB</a> scaling limitation have an impact on <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a>? 🤔Find out by reading our new tips & tricks blog!⬇️ <a href="https://hubs.la/Q01N3vHr0" rel="nofollow noopener noreferrer" target="_blank">https://hubs.la/Q01N3vHr0</a> <a href="https://twitter.com/Yugabyte/status/1652328401212960769" rel="nofollow noopener noreferrer" target="_blank">https://twitter.com/Yugabyte/status/1652328401212960769</a>

Franck PachotOn 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 <a href="https://mastodon.social/@FranckPachot" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@FranckPachot</a> as he discusses the innovative database architecture of YugabyteDB. Join us on Twitter or here: <a href="https://youtu.be/UH575nudjpg" rel="nofollow noopener noreferrer" target="_blank">https://youtu.be/UH575nudjpg</a><a href="https://mastodon.social/tags/xgeeks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#xgeeks</a> <a href="https://mastodon.social/tags/cloudnative" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#cloudnative</a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#database</a> <a href="https://mastodon.social/tags/YugabyteDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#YugabyteDB</a> <a href="https://twitter.com/xgeeksio/status/1650547139221630979" rel="nofollow noopener noreferrer" target="_blank">https://twitter.com/xgeeksio/status/1650547139221630979</a>

Recent searches

Search options

Administered by:

Server stats:

#yugabytedb