A quick rewind!! In the previous post, we implemented user creation and successfully tested it via API endpoints. In this post, we鈥檙e taking things a step further by adding key features that make our application feel more like a real social network. Here鈥檚 what we鈥檒l 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鈥檚 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鈥攄eeply 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鈥攅ach 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鈥檙e stuck in a loop鈥攅xecuting the same SQL queries day in, day out. It feels a bit like Bill Murray in Groundhog Day, doesn鈥檛 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. ...