Home » PostgreSQL

Tag Archives: PostgreSQL

CRUD operations in postgres jsonb

Bipartite Graph

Hello. In this tutorial, we will learn how to handle crud operations on a jsonb column in the postgres database. 1. Introduction SQL stands for Structured Query Language and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, etc. A relational database consists of rows and columns that allow fetching specific information from databases ...

Read More »

Expressjs and Knexjs sql query builder

Bipartite Graph

Hello readers. In this tutorial, we will understand the knexjs sql builder library in expressjs application and perform some crud operations. 1. Introduction knex sql builder library for javascript that provides an easy interface to access a database and perform all the related operations. It supports multiple database engines like Mysql, Postgresql, SQLite, Oracle, and many more. It supports features ...

Read More »

Postgres and Graphql

Bipartite Graph

Hello readers. In this tutorial, we will bring in the postgres (running as a Docker container) to integrate with graphql and implement the CRUD operations. The application will expose different endpoints with the help of the apollo server. 1. Introduction GraphQL is an API syntax that defines how to fetch data from one or more databases. It was developed by ...

Read More »

Handling SQL exceptions in a Stored Procedure

Bipartite Graph

Hello. In this tutorial, we will learn how to handle SQL exceptions in the stored procedure via the postgresql database. 1. Introduction SQL stands for Structured Query Language and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, etc. A relational database consists of rows and columns that allow fetching specific information from databases ...

Read More »

SQL Triggers

Bipartite Graph

Hello. In this tutorial, we will learn the SQL triggers and see a practical implementation of them in the postgresql database. You can also check this tutorial in the following video: SQL Triggers Tutorial – Video 1. Introduction SQL stands for Structured Query Language and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, ...

Read More »

SQL Wildcard Operators

Bipartite Graph

Hello. In this tutorial, we will learn the SQL wildcard operators and see a practical implementation of them. 1. Introduction SQL stands for Structured Query Language and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, etc. A relational database consists of rows and columns that allow fetching specific information from databases that can ...

Read More »

SQL Cursor Example

Bipartite Graph

Hello. In this tutorial, we will learn the SQL cursor and see a practical implementation to it. 1. Introduction SQL stands for Structured Query Language and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, etc. A relational database consists of rows and columns that allow fetching specific information from databases that can be ...

Read More »

SQL Cheat Sheet

Bipartite Graph

1. Introduction A sql cheat sheet is a notepaper where you write down some information that you will need sometimes in the feature. Have you ever wondered how useful will be to have a cheat sheet with some information? SQL Cheat Sheet will introduce you from the basic concepts to some advanced concepts with explanations for each concept. 2. What ...

Read More »

DB Integration Tests with Spring Boot and Testcontainers

Hello. In this tutorial, we will explore the Testcontainers to perform integration tests for the jpa repositories in a Spring Boot app. 1. Introduction Testcontainers is a library that provides a clean way for writing the integration and end-to-end tests for the jpa repositories. In this example, we will create a simple rest api application to persist the data in ...

Read More »

SQL Self Join

Bipartite Graph

Hello. In this tutorial, we will learn the SQL SELF JOIN (represented by the inner join keyword). 1. Introduction SQL stands for Structured Query Language and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, etc. A relational database consists of rows and columns that allow fetching specific information from databases that can be ...

Read More »