17
Dec
2025
IVFFlat Indexing in pgvector
#database•#vectordatabase•#ai•#postgres
Vector databases and AI-powered applications continue to grow rapidly, and PostgreSQL has joined the...
My Blog
Thoughts, ideas, and experiences about software development, programming, and technology.
Latest Articles
13
Aug
2025
Hardening SSH on Ubuntu: Custom Admin User and Locking Down Access
#ubuntu•#devops•#aws•#cloud
When you first launch an Ubuntu server, cloud providers often give you a default Ubuntu user with SSH...
04
Aug
2025
Django Caching Strategies: QuerySet vs ID List
#webdev•#python•#django•#redis
Balancing Performance and Flexibility As Django developers, we're constantly looking for...
28
Jul
2025
PostgreSQL Database Tuning Guide
#postgres•#database•#webdev•#devops
PostgreSQL is a powerful, open-source relational database management system renowned for its...
23
Jul
2025
Beyond Cosine Similarity: Multi-Faceted Scoring for Smarter Recommendations
#ai•#machinelearning•#vectordatabase•#nlp
Cosine similarity is a widely adopted metric for measuring the similarity between two vectors in...
09
Jul
2025
Optimize Static Delivery: Host Static Assets on AWS EC2 with Nginx & Cloudflare
#cloud•#nginx•#devops•#webdev
In modern web architecture, speed and scalability are non-negotiable. A CDN (Content Delivery...
23
Jun
2025
Automating PostgreSQL Backups with a Shell Script
#bash•#postgres•#devops•#database
Backups serve as a safety net for any application that stores critical data. If you’re running a...
16
Jun
2025
NLP: Tokenization to Vectorization
#nlp•#ai
Natural Language Processing (NLP) is a domain that bridges human languages and computer intelligence....
23
Apr
2025
Upgrading Django with "python -W always manage.py test"
#python•#django•#development•#webdev
Upgrading Django to a newer version is a crucial step in keeping your project secure, performant, and...
27
Mar
2025
Numerology Decoded: A Spiritual Algorithm Behind Your Life Path
#startup•#watercooler•#entrepreneur•#algorithms
When Numbers Speak Louder Than Words In the world of data and code, every variable has...
04
Mar
2025
When and Why | Terminating PostgreSQL Connections Using pg_terminate_backend
#database•#postgres•#programming•#productivity
Managing active connections in PostgreSQL can be challenging, especially when you need exclusive...
07
Jan
2025
Django: Find Nearby Users with Coordinates and Radius
#django•#programming•#python•#webdev
In today's world, location-based features are increasingly essential in web applications. Integrating...
06
Jan
2025
From Code to Cloud: Builds Next.js on GitHub Actions, straight to production
#nextjs•#githubactions•#devops•#cicd
By maintaining, the CI/CD pipelines for build, test, and deployment processes, teams can ensure...
02
Jan
2025
Common Django ORM Mistakes to fix
#python•#django•#programming•#webdev
Django ORM is one of the most powerful features of django. It abstracts away much of the complexity...
01
Jan
2025
Increase Swap Memory in Ubuntu
#ubuntu•#devops•#linux
Swap memory serves as a backup for your system's RAM, utilizing the hard disk to provide additional...
25
Nov
2024
Cosine Similarity Search on Vectors in Postgres with pgvector
#vectordatabase•#postgres•#nlp•#django
In the realm of modern data processing, vector embeddings have become increasingly popular for...
24
Nov
2024
Understanding DNS Records
#webdev
The Domain Name System (DNS) is a decentralized and hierarchical system that resolves domain names to...
25
Oct
2024
Increase the Size of a Virtual Machine on VMware ESXi
#ubuntu•#vmware•#devops
Expanding the storage capacity of a virtual machine (VM) can often be necessary as your data...
19
Jul
2024
Deploying Next.js App in AWS EC2 with Nginx and PM2
#aws•#devops•#nextjs•#react
Deploying a Next.js application on an AWS EC2 instance involves several steps. This guide will walk...
18
Jul
2024
Python Try-Except: When to Avoid It
#python•#django•#programming•#fastapi
Python’s try-except block is a powerful tool for handling exceptions and preventing a program from...
19
May
2024
Understanding Django's prefetch_related and Prefetch
#django•#python•#programming•#webdev
In Django, managing database queries efficiently is crucial for building performant web applications....
18
May
2024
Using Django-Q to Schedule and Automate Tasks in Django
#python•#django
Scheduling tasks to run at specific times or intervals is an essential feature of many web...
18
May
2024
Optimize your Django Application with Asynchronous tasks and Django-Q
#django•#python
Django, a high-level Python web framework, simplifies the creation of complex, database-driven...
15
May
2024
Deploying Nuxt 3 App in AWS EC2 with Nginx and PM2
#nuxt•#aws•#devops•#vue
Deploying a Nuxt 3 application on an AWS EC2 instance involves several steps. This guide will walk...
14
May
2024
Custom Ordering in Django: Prioritize Your Data
#django•#python•#coding•#backend
While Developing an application, there's often a need to prioritize items based on specific criteria....
14
May
2024
Extend Django Templates with Custom Tags and Filters
#django•#python•#webdev•#beginners
Django's templating system is a powerful tool for rendering HTML with dynamic data. While Django...
14
May
2024
Working with JSON and JSONB Data Types in Django with PostgreSQL
#django•#postgres•#coding•#backend
PostgreSQL is great at handling JSON data, it supports two JSON data types, JSON and JSONB (Binary...
14
May
2024
A Developer's Guide to Deploying Django Application Efficiently on Ubuntu with Nginx
#django•#ubuntu•#nginx•#devops
Hosting a Django application involves multiple components to ensure it runs efficiently and securely....
13
May
2024
Optimizing the Performance of Django SearchVector with GIN Indexing
#django•#postgres•#performance•#coding
For a detailed exploration of Full Text Search using SearchVector. Django developers mostly use...
13
May
2024
A Guide to Full Text Search in Django Using SearchVector
#django•#postgres•#webdev•#python
When building web applications with Django, adding efficient search functionality can greatly improve...
12
May
2024
Deploy Sendy on AWS EC2 with Apache in Ubuntu
#php•#aws•#ubuntu•#apache
To begin, you'll need an AWS account and lunch EC2 instance with your specific requirement. I have...
11
May
2024
PostgreSQL specific trigram_similar lookups in Django
#django•#postgres•#ubuntu
For a detailed exploration of Trigram Similarity, check out my previous blog. Enhance Your Searches...
11
May
2024
Enhance Your Searches with PostgreSQL Trigram Similarity in Django
#django•#postgres•#performance•#coding
Searching through textual data efficiently remains a significant challenge for many web applications....
10
May
2024
A Guide to Accessing a Remote PostgreSQL Database in Ubuntu Server
#postgres•#ubuntu•#database•#devops
In the interconnected world of today, accessing databases remotely has become a fundamental skill for...