Start Now

Category: How To

Client-Side vs Server-Side Latencies Demystified in PostgreSQL and YugabyteDB

Client-Side vs Server-Side Latencies Demystified in PostgreSQL and YugabyteDB

Every SQL execution in PostgreSQL and therefore in YugabyteDB YSQL takes time to process. A common way to identify how much is time spent on processing is to use the pg_stat_statements view in the database. However, the time visible in pg_stat_statements might differ from the time a database client registers for the execution. Where does this difference come from? Let’s take a look.

Read more

How to Build a Scalable Streaming App with Django, Celery and YugabyteDB

How to Build a Scalable Streaming App with Django, Celery and YugabyteDB

As you look to build a streaming application that scales, there are many database options to choose from. If you’re looking for a high-performance database that can handle large-scale data, YugabyteDB,
is a great option. In this blog, we will build an application with YugabyteDB and Django, using the PubNub market order data stream. You will see how you can use YugabyteDB and Django to make an application that subscribes to the PubNub Market Orders Stream, stores these trades in YugabyteDB, and displays them in real-time.

Read more

How to Capture Table Size Metrics on YugabyteDB Anywhere

How to Capture Table Size Metrics on YugabyteDB Anywhere

It’s good to keep a record about the growing size of databases and tables to make reporting easier and to quickly determine why there was a sudden drop or increase in table size or infer table create and drop dates. YugabyteDB Anywhere provides an API to capture table-level size metrics on a daily basis in a permanent table. This blog will provide the instructions to capture those table size metrics.

Read more

Learn More to Accelerate Your Retail Business

Ready to dive deeper into distributed SQL, YugabyteDB, and Yugabyte Cloud?
Learn at Yugabyte University
Learn More
Browse Yugabyte Docs
Read More
Join the Yugabyte Community
Join Now