Vector databases in practice
6 articlesStart with vector storage, then explore search and data ingestion.
- Milvus JDBC: Vector Writes and Search
Use the standalone jdbc-milvus driver to connect, create a collection, bind vectors, and filter nearest-neighbor results.
- Milvus Entity Mapping and DAO Design
Map a Milvus collection to Java entities, organize searches with builders and Mapper methods, and update selected fields.
- Milvus Hybrid Search: Vectors and Keywords
Configure BM25 through SQL, retrieve dense-vector and keyword candidates, and return one fused result set using RRF.
- Milvus Ingestion: Choosing a Write Method
Use jdbc-milvus for small writes, iterator-based paged ingestion and server-side Import, with distinct handling for counts, job IDs and failures.
- Milvus with SQL: Queries, ORM and Tools
Express Milvus writes, business filters and vector search in SQL, execute them through JDBC, then extend to dbVisitor object mapping, Mappers, DataGrip and DBeaver.
- pgvector: Mapping and Similarity Search
PostgreSQL's pgvector extension enables vector storage and similarity search, but Java lacked a clean mapping. dbVisitor 6.7.0's PgVectorTypeHandler maps vector columns directly to List with full Fluent API support for CRUD and KNN queries.