Large language models (LLMs) have evolved beyond generating text responses to interpreting text prompts. Discover how you can use a multimodal LLM to search your AI applications with PostgreSQL pgvector. This blog examines the architecture, database schema, and code required to build an application that searches recipes by both text and image. The post Multimodal Search with PostgreSQL pgvector appeared first on Yugabyte ..read more

Developers can now store, index and query vectors in PostgreSQL using pgvector, eliminating the need for a dedicated vector database. This blog deep dives into pgvector, and explains how to store text embeddings as vectors, execute similarity search, choose between indexes, and scale with distributed SQL. The post PostgreSQL pgvector: Getting Started and Scaling appeared first on Yugabyte ..read more

Database High Availability has traditionally been achieved through enhanced and automated disaster recovery solutions. Although these measures reduce the impact of failures, they still result in complete downtime for the application during the failover process. In this blog, we compare this approach with cloud-native solutions for high availability, focusing on resiliency built directly into the database. The post YugabyteDB Resiliency vs. PostgreSQL High Availability Solutions appeared first on Yugabyte ..read more

Having different names for our YugabyteDB DBaaS deployment options has led to some confusion. To make it clear that these are two deployment options of one core product we’ve unified the product name - YugabyteDB Aeon! In this blog, we share the benefits of YugabyteDB Aeon and detail how to choose the best deployment option for your use case. The post Introducing YugabyteDB Aeon appeared first on Yugabyte ..read more

Developers can now store, index and query vectors in PostgreSQL using pgvector, eliminating the need for a dedicated vector database. This blog deep dives into pgvector, and explains how to store text embeddings as vectors, execute similarity search, choose between indexes, and scale with distributed SQL. The post PostgreSQL pgvector: Eliminating the Need for a Dedicated Vector Database appeared first on Yugabyte ..read more

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. The post How to Harness Kubernetes Operators for Efficient YugabyteDB Deployment appeared first on Yugabyte ..read more

YugabyteDB 2.19.2 introduces full support for Read Committed Isolation with Wait-On-Conflict, essential for PostgreSQL users looking to seamlessly lift-and-shift applications to a distributed environment. This feature ensures parity with PostgreSQL while leveraging the scale and resilience of YugabyteDB, simplifying the transition for users. The post Simplify The Lift and Shift of PostgreSQL Apps With Familiar Read Committed Behavior appeared first on Yugabyte ..read more

YugabyteDB 2.19 introduces a revolutionary built-in Connection Manager, transforming PostgreSQL's well-documented connection challenges into strengths. The enhanced manager boosts connection creation speeds up to 20x and supports up to 5x more connections, all while maintaining consistent throughput. The post Built-in Connection Manager Turns Key  PostgreSQL Weakness into a Strength appeared first on Yugabyte ..read more

Discover why YugabyteDB doesn't support PostgreSQL extensions pg_repack and pg_buffercache. While YugabyteDB leverages the Postgres query layer, its unique approach to the storage layer makes certain extensions unnecessary. The post Does YugabyteDB Support Certain Extensions Like pg_repack and pg_buffercache? appeared first on Yugabyte ..read more

Introducing PgCompute—a client-side extension for PostgreSQL aimed at revitalizing the use of database functions by allowing developers to create and optimize them seamlessly within their preferred IDE and programming language. The post Introducing PgCompute: PostgreSQL Client-Side Extension for Database Functions appeared first on Yugabyte ..read more