Nile

Finish the week with a Postgres video All about using JSON in Postgres: - when you should use it - how to use it efficiently - how JSONs actually get stored in postgres. https://lnkd.in/ghpaiQh2

A deep dive into pg_karnak - How Nile performs schema migrations across thousands of virtual tenant databases within one logical Postgres database

New blog post 🖋️ RAG vs. Fine-Tuning: Choosing the Right Approach. In which I explain the differences, the use-cases that fit each method, and the common challenges. https://lnkd.in/g2Hpj2yg And for your convenience, I summarized the main points in a chart

New video! Getting started with pgvector. If you are building an application that requires vectors, pgvector is a great choice. If your application is multi-tenant, Nile provides tenant privacy and pgvector. In this new video tutorial I explain: * Why pgvector is the best choice of vector store for apps * how to use it with and without tenant isolation - typical queries and indexes * and some of my favorite, yet underrated, features. https://lnkd.in/g2NbeEyK

Since its a slow news day, you may want to entertain yourself with a technical blog 😁 Pgvector 0.8.0 was released last week and is now available on Nile. I wrote about the new features and the demonstrated the impact of iterative scans and the cost optimization improvement. https://lnkd.in/gztfEHci TLDR: * Added support for iterative index scans * Added casts for arrays to sparsevec * Improved cost estimation for better index selection when filtering * Improved performance of HNSW index scans * Improved performance of HNSW inserts and on-disk index builds

Nothing is more satisfying than seeing your users saying good things about your product.

We sent our Oct update to our users. Lots more to come in Nov.

New blog post: Building successful multi-tenant RAG applications 🚀 Multi-tenancy, ensuring secure, isolated data handling for multiple orgs in AI-powered applications, is essential for building user trust and optimizing performance. https://lnkd.in/g6y9H_5g Learn: ➡️ Architecture patterns for isolating data and embeddings for each tenant efficiently ➡️ Benefits of using pgvector for RAG - combining vectors and data with SQL and ACID. ➡️ How to implement tenant-aware RAG in 6 different frameworks and 3 languages. Thanks to Vicki Boykis for her wonderful review. The blog wouldn't be half as good without her.

🚀 Nile's full cloud stack is now available as a Docker image for local development ✅ 3 Postgres instances ✅ Packaged with all Nile extensions and services ✅ AI tooling, including pg_vector pre-installed ✅ Everything in the cloud docs works locally! https://lnkd.in/eNfWN4mN

Exploring PostgreSQL's Evolution with Gwen (Chen) Shapira 🚀 In this episode of What’s New in Data, host John Kutay sits down with Gwen (Chen) Shapira, Co-Founder and Chief Product Officer at Nile, to uncover her transition from leading Kafka development at Confluent to becoming a key figure in the PostgreSQL community. Listen to this episode to discover: 🔍 How the Postgres community is evolving with tools like Discord 🔍 The most impactful recent PostgreSQL developments 🔍 The growing necessity of SSL for secure database connections in cloud settings 🔍 PostgreSQL’s integration potential with Apache Arrow and Parquet 🔍 How PostgreSQL’s flexibility supports SaaS applications for a variety of customer needs 🔗 Tune in now: Spotify: https://lnkd.in/evM22-M7 Apple: https://lnkd.in/edhfZpQQ #whatsnewindata