Urgent.News

What's breaking now, across thousands of outlets.

Tech

RAG Without a Second Database

Almost every RAG tutorial I read starts the same way. Take your documents, split them into chunks, embed them, and load the vectors into a vector database. Then keep your original data where it was, and write something that keeps the two in sync. I was an Oracle DBA for a long time before I moved into architecture work, and that second step always makes me a little uneasy. Not because vector…

This account details the author's experiment with building a RAG (Retrieval-Augmented Generation) system without using a second database. The setup uses PostgreSQL 16.15 and pgvector 0.8.0, with a sandbox Linux container running on the same machine as the client. The system's performance was evaluated by generating synthetic vectors, computing exact top 10 results in NumPy, and loading the vectors using binary COPY.

The measurements were taken for both exact scans and HNSW at different ef_search values, with the results revealing a significant gap in latency between the exact scan and the HNSW index. The author emphasizes that these findings should be validated with the user's own queries before drawing conclusions about pgvector's performance.

Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.

Read the original at dev.to →

More in Tech

Shipping an iPhone App Without a Mac: Kotlin Multiplatform, a Cloud Mac and TestFlight

I develop on Windows and I do not own a Mac, but I wanted my small Android game 2048 on the App Store. It turns out you do not need a Mac on your desk, only one in the cloud for a few minutes per…

  • Windows developer can ship iOS app via cloud-based solution
  • Kotlin Multiplatform, cloud Mac, and TestFlight used for development
  • Android and iOS shells are thin wrappers around shared Kotlin code

Rewriting for Kotlin Multiplatform Without Changing Behavior: Old Code as a Test Oracle

I moved two small RSS reader apps and a space app to Kotlin Multiplatform so they could also run on iOS. That meant rewriting code that leaned on Android and Java classes.

  • Migrated RSS reader apps and space app to Kotlin Multiplatform for iOS compatibility
  • Preserved old implementations in test sources as a test oracle for comparison
  • Developed custom Random algorithm to maintain space app's daily card consistency

More from Monday 16 November →