Automating Database Cleanup for PostgreSQL Using Python
This article shows a technique for cleaning out older data from PostgreSQL tables using Python to follow a set of rules you create.
2026-01-30
807 reads
sabyda
- Skills: Java, Spring boot, React, Azure, AWS, Postgres, Oracle, Websphere, Angular, Blockchain, Corda
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
We have a script that can be used to help tune ind...
2026-01-21
1,274 reads
Working with JSON/JSONB Data in PostgreSQL using Python
This article discusses how to work with JSON data in PostgreSQL using Python.
2025-12-12
609 reads
Implementing PostgreSQL with Python for Real-Time Logging and Monitoring
Learn how you can create a logging module in Python that can be used to insert real-time records in a PostgreSQL database and display them on a dashboard.
2025-11-12
1,764 reads
Building a RESTful API with FastAPI and PostgreSQL
This article shows how to use Python to create a REST API for your application that developers can use to access the database.
2025-10-17
5,607 reads
MongoDB and NodeJS in action
Overview MongoDB is a popular NoSQL database used for building modern, scalable applications. In this article, we’ll cover how to set up MongoDB on Windows and connect to it using Node.js. We will also perform some basic Create, Read, Update, and Delete (CRUD) operations to ensure we understand fully on how Node.js can be made […]
2025-09-02 (first published: 2025-08-08)
181 reads
Using psycopg2 to Connect Python to PostgreSQL
Learn how to connect to a PostgreSQL database from Python with this popular library.
2025-09-02 (first published: 2025-08-25)
2,080 reads
Working with Indexes on SSMS
Overview In SQL Server, indexing is a technique used to improve the performance of queries by reducing the amount of data that SQL Server needs to scan. You can think of it like a table of contents in a book—it helps SQL Server find data more quickly. In this article, we will cover the following […]
2025-09-02 (first published: 2025-08-07)
4,594 reads
2025-07-30
1,806 reads
Connecting to PostgreSQL with Node.js
Overview In this article, we will understand how we can connect to PostgreSQL using Node.js application. We will start with setting up PostgreSQL in our local system and perform basic CRUD operations to interact with the PostgreSQL database. Prerequisites To start with this, we need the following conditions to be met: Windows machine (or any […]
2025-07-24
1,309 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers