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.
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.
In this blog, we will explore how YugabyteDB Change Data Capture (CDC) and open table formats like Apache Iceberg can be used to build data lakes in Amazon S3 using a single copy of the data and achieve low data ingestion latency while avoiding costly rewrites to support updates/deletes and schema evolution.
We are committed to delivering new YugabyteDB distributed database capabilities that enhance the Microsoft Intelligent Data Platform experience for our joint customers by dramatically simplifying the process to connect YugabyteDB with Microsoft Azure Synapse Analytics.
At the recent Distributed SQL Summit, Nathaniel Drehmel, Principal Engineer, Database Strategy and Innovation at Wells Fargo discussed the company’s path to distributed SQL, including their top data requirements and why they chose a distributed SQL database. This blog provides chat highlights with links to watch the entire conversation.
As we scale Yugabyte for growth, we know that our entire company needs to be firmly anchored to a strong set of principles. These principles should act as a guiding light for every decision we make and should also define our company culture. After many discussions and analysis, a core theme appeared—transparency.
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.
At the recent Distributed SQL Summit, David Loomis, Managing Director of Infrastructure, Operations, and Cloud Platforms at Charles Schwab shared his experience with directing the company’s application and database modernization strategy. This blog provides highlights of that chat with links to watch the entire conversation.
Learn how to best use Query Planner hints in the YugabyteDB database to optimize business queries based on how applications expose them. Walk through a use case that utilizes data sets from two popular TV shows to find total viewership per season, episode, etc.
DSS 2022 was the biggest and best distributed SQL event to date, with so many people engaged and enthused by distributed SQL and YugabyteDB. There were over 25 world-class keynotes, insightful fireside chats with industry-leading enterprises, and technical presentations by YugabyteDB and industry experts.
In case you missed the event or have not yet watched the replays, here are our top five takeaways!
