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
4,695 reads
sabyda
- Skills: Java, Spring boot, React, Azure, AWS, Postgres, Oracle, Websphere, Angular, Blockchain, Corda
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)
169 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)
1,801 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,063 reads
2025-07-30
1,743 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,219 reads
Common Table Expression Basics
Learn the basics of how CTEs work with a few examples in this article.
2023-05-31 (first published: 2023-05-19)
5,825 reads
Establishing a Connection to PostgreSQL with GoLang
Learn how to use golang to connect to a PostgreSQL database.
2022-07-22
17,863 reads
Array and Custom Data Types in PostgreSQL
Introduction Just like every other database, PostgreSQL has its own set of basic datatypes, like Boolean, Varchar, Text, Date, Time, etc. We can easily store data like numbers, characters, date, time, etc. using these supported datatypes, but what if we need to store multiple data elements in a single column? Suppose we are storing the […]
2021-09-10
13,337 reads
Conditional DELETE and INSERT in PostgreSQL
Introduction We are comfortable with inserting/deleting record(s) into/from a table. But we sometimes get confused when we need to insert or delete records conditionally from a table. Let us look at an example. Example scenario Suppose we have a table, called ALL_EMPLOYEES, which contains all employees' information who are working or had ever worked for […]
2021-06-18 (first published: 2021-05-12)
10,769 reads
Blogs
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers