Browsing Tag
postgres
57 posts
Storing and Querying OpenAI Embeddings in PostgreSQL with pg_vector
In this guide, we’ll explore how to effectively store, index, and query embeddings generated from OpenAI’s text-embedding-3-small model…
Is PostgreSQL Better Than MySQL?
One day, a group of developers engaged in a heated debate—nearly coming to blows—over whether PostgreSQL is superior…
Aurora Limitless – Resharding
Re-sharding to scale out can be operationally complex when using database sharding. However, Aurora Limitless simplifies this process.…
Aurora Limitless – SQL Limitations
It is important to clarify that Aurora Limitless is not a single distributed SQL database. Instead, it functions…
pgSphere and Q3C on Distributed SQL
To explore YugabyteDB’s capabilities in handling spherical and astronomical datasets, I recently tested two PostgreSQL extensions: pgSphere and…
Stop Supabase Projects From Being Paused
Keep Your Supabase Projects Active with Supabase Inactive Fix and Supabase Pause Prevention Supabase is a powerful backend-as-a-service…
All the ways to react to changes in Supabase
This video covers all the ways to capture changes in Supabase. It’s a video deep dive into all…
how to connect the PostgreSQL database with Django
🎉 Click the larger photo to watch YouTube video
Pessimistic locking, Read Committed, and all Isolation Levels
Optimistic Concurrency Control looks attractive in a distributed system because it avoids locks. However, in an SQL database,…
Kickstart Your Serverless Project in a Snap
This is a submission for the Neon Open Source Starter Kit Challenge: Ultimate Starter Kit My Kit The…