Database

A quick rewind!! In the previous post, we implemented user creation and successfully tested it via API endpoints. In this post, we’re taking things a step further by adding key features that make our application feel more like a real social network. Here’s what we’ll explore: Enabling users to follow each other Writing expressive queries using Cypher Query Language Allowing users to create posts Adding support for likes and comments on posts Setting up a Vector Database for RAG (Retrieval-Augmented Generation) Integrating Spring AI into the backend Let’s jump in and build out these social features step by step! ...

Graph database what and how? Recently at work, I had the opportunity to dive into a new product that deals with highly complex, hierarchical data schemas—deeply interconnected across multiple levels of business domains. To put it simply: imagine an ETL process pulling structured data from physical documents and presenting that data differently for different teams—each with their own use cases and logic. Now, the fun (and frustration) really began when we start thinking about how to handle these transformations. Some were done using custom functions, others using Java reflection (yes..yes, you read it right, we use java reflection🙃). ...

Tired of Writing the Same SQL Queries Over and Over? Imagine you’re stuck in a loop—executing the same SQL queries day in, day out. It feels a bit like Bill Murray in Groundhog Day, doesn’t it? You find yourself copying and pasting nearly identical code across different parts of your application or repeatedly typing out similar commands during database maintenance. What if you could bundle these repetitive tasks into reusable, maintainable, and efficient code blocks inside your database? Good news: PostgreSQL makes this possible with Functions and Stored Procedures. ...