#yugabyte — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #yugabyte, aggregated by home.social.
-
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.
-
Container 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 #postgresql, #yugabyte, and others). We explain them - just for you!
-
Container 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 #postgresql, #yugabyte, and others). We explain them - just for you!
-
Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!
The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.
🎥👉 https://youtu.be/1EAKqwcP2SY
#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql
-
Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!
The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.
🎥👉 https://youtu.be/1EAKqwcP2SY
#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql
-
Using #PostgreSQL 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 #YugabyteDB)
https://dev.to/yugabyte/postgresql-row-level-security-with-an-array-of-tenants-2136 -
Using #PostgreSQL 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 #YugabyteDB)
https://dev.to/yugabyte/postgresql-row-level-security-with-an-array-of-tenants-2136 -
Batching remote reads/writes is how #YugabyteDB can provide elasticity with high performance. An example of Foreign Key checking:
https://dev.to/yugabyte/foreign-keys-on-distributed-sql-dont-worry-it-scales-2g0g -
Batching remote reads/writes is how #YugabyteDB can provide elasticity with high performance. An example of Foreign Key checking:
https://dev.to/yugabyte/foreign-keys-on-distributed-sql-dont-worry-it-scales-2g0g -
An example of read restart, which is how Oracle Database or #YugabyteDB avoids serialization errors in Read Committed, without inconsistent read time:
-
An example of read restart, which is how Oracle Database or #YugabyteDB avoids serialization errors in Read Committed, without inconsistent read time:
-
What? There's no Inverted Join in #YugabyteDB?
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:
https://dev.to/yugabyte/inner-inverted-join-in-yugabytedb-postgresql-g22 -
What? There's no Inverted Join in #YugabyteDB?
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:
https://dev.to/yugabyte/inner-inverted-join-in-yugabytedb-postgresql-g22 -
If you want to be sure that your SELECT COUNT(*) is optimal in #YugabyteDB, check the execution plan. There are many optimisations where it uses PostgreSQL with additional pushdowns to reduce the latency
https://dev.to/yugabyte/fast-select-count-in-yugabytedb-464h -
If you want to be sure that your SELECT COUNT(*) is optimal in #YugabyteDB, check the execution plan. There are many optimisations where it uses PostgreSQL with additional pushdowns to reduce the latency
https://dev.to/yugabyte/fast-select-count-in-yugabytedb-464h -
The benefits of hash-sharding (to avoid hotspots) and range-sharding (to reduce reads) can be combined in #YugabyteDB, thanks to LSM-Tree scan optimization and PostgreSQL features: https://dev.to/yugabyte/scalable-range-sharding-with-yugabytedb-1o51
-
The benefits of hash-sharding (to avoid hotspots) and range-sharding (to reduce reads) can be combined in #YugabyteDB, thanks to LSM-Tree scan optimization and PostgreSQL features: https://dev.to/yugabyte/scalable-range-sharding-with-yugabytedb-1o51
-
#YugabyteDB uses #PostgreSQL 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...) https://www.yugabyte.com/blog/improve-postgresql/
-
#YugabyteDB uses #PostgreSQL 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...) https://www.yugabyte.com/blog/improve-postgresql/
-
🔥Curious if @Citusdata is Distributed SQL like #YugabyteDB?💡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 https://dev.to/yugabyte/citus-is-not-acid-but-eventually-consistent-3711
-
🔥Curious if @Citusdata is Distributed SQL like #YugabyteDB?💡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 https://dev.to/yugabyte/citus-is-not-acid-but-eventually-consistent-3711
-
Counters in SQL 🤓 I tested #YugabyteDB compaction with this use-case
👉 no vacuum, no bloat 🎶https://dev.to/yugabyte/in-memory-counters-with-yugabytedb-2p54
-
Counters in SQL 🤓 I tested #YugabyteDB compaction with this use-case
👉 no vacuum, no bloat 🎶https://dev.to/yugabyte/in-memory-counters-with-yugabytedb-2p54
-
You can easily build and install many PostgreSQL extensions on #YugabyteDB - here is an example with pg-hostname:
https://dev.to/yugabyte/pg-hostname-on-yugabytedb-compiled-and-installed-directly-on-the-server-15id -
You can easily build and install many PostgreSQL extensions on #YugabyteDB - here is an example with pg-hostname:
https://dev.to/yugabyte/pg-hostname-on-yugabytedb-compiled-and-installed-directly-on-the-server-15id -
New blog post: #SQLPage. If you💗SQL you can build your web app presentation layer with SQL declarations. What if the DB is unavailable? Just use #YugabyteDB: It is Distributed PostgreSQL, with no downtime during failures or upgrades 🚀https://dev.to/yugabyte/sql-for-low-code-applications-sqlpage-lmk
-
New blog post: #SQLPage. If you💗SQL you can build your web app presentation layer with SQL declarations. What if the DB is unavailable? Just use #YugabyteDB: It is Distributed PostgreSQL, with no downtime during failures or upgrades 🚀https://dev.to/yugabyte/sql-for-low-code-applications-sqlpage-lmk
-
Because I've seen some silly benchmarks comparing 🍏to 🍊, I had a look at #hammerdb on #YugabyteDB. With #PostgreSQL-compatible databases, you can know what you run
-
Because I've seen some silly benchmarks comparing 🍏to 🍊, I had a look at #hammerdb on #YugabyteDB. With #PostgreSQL-compatible databases, you can know what you run
-
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!
#Java #JVM #database #datyabases #YugaByte #PostgreSQL #programming #meetup #Tampa #TampaBay
-
"LSM-tree and block storage" by @fritshoogland #DEVCommunity https://dev.to/yugabyte/lsm-tree-and-block-storage-29ek #yugabyte #yugabyteDB
-
"LSM-tree and block storage" by @fritshoogland #DEVCommunity https://dev.to/yugabyte/lsm-tree-and-block-storage-29ek #yugabyte #yugabyteDB
-
@fritshoogland that is very cool, the fact that you are reusing codebase here. That alone tells me a lot!
I am very interested on this, yet I have no applicable use. Hope you don't mind if I ask you a bunch of questions.
Or... if you want to direct me to read something in particular, that's good too 👍
I basically want to know "what are we giving up" when using #Yugabyte instead of #PostgreSQL. (cons on single server and/or low count of servers)
-
@fritshoogland that is very cool, the fact that you are reusing codebase here. That alone tells me a lot!
I am very interested on this, yet I have no applicable use. Hope you don't mind if I ask you a bunch of questions.
Or... if you want to direct me to read something in particular, that's good too 👍
I basically want to know "what are we giving up" when using #Yugabyte instead of #PostgreSQL. (cons on single server and/or low count of servers)
-
@fritshoogland I wonder, how close is #Yugabyte to #PostgreSQL? Is the query planning as good? does it support the same level of SQL? How well it performs in single-cluster vs postgreSQL?
I would be interested on seeing benchmarks of complex queries with >10GiB databases to see how much performance would be lost compared to #PostgreSQL
If it's not much, Yugabyte might be interesting for DBs that you might to run in cloud, even for regular data sizes, just in case it becomes too big later on.
-
@fritshoogland I wonder, how close is #Yugabyte to #PostgreSQL? Is the query planning as good? does it support the same level of SQL? How well it performs in single-cluster vs postgreSQL?
I would be interested on seeing benchmarks of complex queries with >10GiB databases to see how much performance would be lost compared to #PostgreSQL
If it's not much, Yugabyte might be interesting for DBs that you might to run in cloud, even for regular data sizes, just in case it becomes too big later on.
-
After having a look at #cockroachdb and #yugabyte database licenses, I find surprised that CockroachDB backtracked and it's now closed software.
But anyway, these two seem both oriented at selling it as a service, not really #foss. Or at least my impression.
There is market for a totally distributed cloud alike #PostgreSQL. And it is doable because at least there are two products out there. #citus seems to be lacking multimaster, and not sure if integrates with #BDR