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
751 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,138 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
579 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,722 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,380 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,024 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,475 reads
2025-07-30
1,798 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,299 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers