In this blog post, we examine how you can migrate data and schema from an existing PostgreSQL database using YugabyteDB Voyager. With a focus on data modeling for appropriate data distribution, we explore two different migration approaches: “Lift” and “Lift & Shift.”
Achieve disaster recovery for cloud-native PostgreSQL deployments using YugabyteDB in Microsoft Azure. Discover how you can leverage YugabyteDB’s xCluster disaster recovery (DR) feature to maintain high availability and ensure data integrity. Use the active-active single-master configuration to achieve disaster recovery across two regions.
Postgres is increasingly being used for Gen AI workloads, but users have reported scalability and performance issues, data privacy challenges and high availability concerns. Before you choose a scalable, HA, vector database instead, try running distributed PostgreSQL. Read our new blog to discover when and how to use distributed PostgreSQL for Gen AI workloads.
The enhanced YugabyteDB Kubernetes Operator significantly simplifies the deployment, management, and scaling of YugabyteDB in cloud-native environments. Discover how it automates complex operations to enhance reliability and allows developers and operations teams to focus more on development and less on infrastructure management.
In this blog, we examine how to create a fully autonomous AI travel agent, capable of finding listings and managing bookings using LangChain, OpenAI, PostgreSQL and pgvector, with YugabyteDB as the underlying database. Learn how to build your own AI agent backed by PostgreSQL using components available in today’s ecosystem.
YugabyteDB’s automatic sharding overcomes PostgreSQL’s partition key limitations by allowing date range queries without modifying table partitioning. Thanks to its global secondary indexes, which don’t require a shared sharding key, YugabyteDB enhances performance by distributing rows across multiple servers. Discover the full advantages and see step-by-step instructions in our latest blog post.
Managing large PostgreSQL tables requires partitioning, which can complicate queries. Migrating to YugabyteDB simplifies scaling by automatically sharding and distributing data and minimizing partition reliance. The article includes demos on PostgreSQL’s partitioning limitations and YugabyteDB’s advantages in distributed tables and scalability.
Discover how to scale PostgreSQL for rapid app growth with our infographic that outlines the evolution to a resilient, compliant, globally scalable distributed deployment. Learn about distributed PostgreSQL’s forms, including multi-master asynchronous replication and sharded or shared-nothing setups, along with their advantages and challenges.
We are pleased to announce that YugabyteDB 2.0.7 is live! You can read the official release notes of this and previous versions here. This release is shipping with almost 30 new enhancements and bug fixes.
What’s YugabyteDB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. Yugabyte’s SQL API (YSQL) is PostgreSQL wire compatible
…
Triggers are a basic feature that all monolithic SQL systems like Oracle, SQL Server and PostgreSQL have supported for many years. They are very useful in a variety of scenarios ranging from simple audit logging, to advanced tasks like updating remote databases in a federated cluster. In this blog, we’ll look at examples of INSERT, UPDATE and INSTEAD OF triggers in Yugabyte DB.
What’s Yugabyte DB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner.
…
