Tag: Database
-
SQL Triggers: Automating Database Actions
Welcome back, data adventurers! In our previous post, we delved deep into SQL Functions, discovering how these powerful tools help us summarize, manipulate, and extract insights from our data. We explored everything from COUNT() and SUM() to UPPER(), TRIM(), and essential date functions like GETDATE() and DATEDIFF(). Today, we’re taking another significant leap forward. We’ll…
-
Mastering SQL Basics: Part 2 – Going Deep with JOINS
In our previous blog, Mastering SQL Basics: Part 1, we built a solid foundation—learning how to create databases, define and manage tables, insert and retrieve data, and apply essential SQL commands. Now, equipped with those basics, it’s time to move beyond single-table queries to one of the most critical topics in relational databases: SQL JOINS. In…
-
Unpacking Database Persistence for Large Text Fields in Hybris: A Multi-DB Approach
As developers working with the Hybris platform, we often encounter scenarios where we need to store significant amounts of text-based data, such as custom configurations, product descriptions, or structured data like JSON for integrations or SEO. While a simple String attribute might suffice for shorter texts, what happens when the data can grow to several…