Kiran Sabne — Engineering Notes

Kiran Sabne — Engineering Notes

#sql

Articles tagged with #sql

Create a Semantic Search API with FastAPI, Sentence-BERT, and PostgreSQL pgvector
In this post, I’ll walk you through how I built a semantic similarity search API using FastAPI, Sentence-BERT (SBERT), and PostgreSQL with the pgvector extension.This project began as a proof of concept (POC) to explore how seamlessly we can integrat...
Oct 14, 20254 min read102
Cracking the SQL Interview: Real Questions and PostgreSQL Internals You Should Know
Over the past few months since the start of new year, I’ve been actively interviewing for technical roles, and each conversation proved to be both challenging and rewarding. In this post, I’ll share some of the SQL questions I was asked, along with d...
Jul 12, 20256 min read40
Handling Exceptions in Postgres
In PostgreSQL, exception handling is implemented using the PL/pgSQL procedural language, which extends the capabilities of SQL with additional programming constructs, such as variables, loops, and conditionals. PL/pgSQL provides a comprehensive excep...
Apr 11, 20233 min read2.6K
Traveling Salesman Problem Path Finder in SQL
Finding optimal travel paths between cities and traveling salesman problem working in SQL
Apr 4, 20233 min read626