Build Text-to-SQL using LLM

Text-to-SQL is a powerful application of large language models (LLMs) like GPT that enables users to interact with a database…

Read More »

PostgreSQL Hibernate 6 JSON Example

1. Introduction Hibernate 6 enhances the Object-Relational Mapping(ORM) framework by supporting JSON Data types. In this example, I will create…

Read More »

NestJs CRUD Operations Example

This article provides a comprehensive example of implementing CRUD operations using NestJS, a powerful Node.js framework. 1. Introduction NestJS is…

Read More »

Storing Date and Time in PostgreSQL Example

1. Introduction Handling date and time values is an essential task, especially when dealing with systems that track events, transactions,…

Read More »

Persisting UUIDs in Postgres with JPA

UUIDs are powerful tools for ensuring unique identification in distributed systems. This article explores how to use Spring JPA with…

Read More »

Window functions in Database

Window functions in PostgreSQL allow us to perform calculations across a set of table rows that are related to the…

Read More »

Database stored proc and triggers

When working with databases, stored procedures, and triggers are powerful tools that allow developers to automate and streamline data operations.…

Read More »

Getting the Insert ID in JDBC

When working with relational databases in Java, it’s common to perform insert operations and then retrieve the ID of the…

Read More »

Resolving PostgreSQL JSON Type Mismatch Errors in JPA

When working with PostgreSQL and Java Persistence API (JPA), you might encounter a common error related to JSON data types.…

Read More »