Power of SQL for JSON and String Arrays (2/2)In our previous post, we explored basic SQL functions for handling JSON and string arrays. Now, let’s dive into little complex scenarios…Mar 1Mar 1
Power of SQL for JSON and String Arrays (1/2)Modern applications often deal with semi-structured data like JSON and arrays of strings. While traditional SQL databases were initially…Feb 151Feb 151
KSQL — Getting Started (Part 3/3)KSQL (KSQLDB) is a streaming SQL engine built on top of Apache Kafka, designed to perform real-time data processing and analysis using…Aug 9, 2024Aug 9, 2024
KSQL — Getting Started (Part 2)In the ever-evolving landscape of data processing, stream processing has emerged as a critical component for real-time analytics and…Feb 25, 20241Feb 25, 20241
Kafka — What you should know ?Apache Kafka is a distributed event streaming platform that has become a fundamental building block for real-time data architectures. It…Dec 29, 20232Dec 29, 20232
Unveiling the Secrets of SQL’s Most Misused Statement — “Select * from”SQL, the versatile language that fuels the world of relational databases, is a double-edged sword. On one side, it offers us remarkable…Oct 15, 2023Oct 15, 2023
Published inTowards DevExploring Lesser Known SQL Functions for Data Analysis — Part VExploring SQL’s lesser-known functions and techniques can uncover hidden gems in the world of data manipulation. These often-overlooked…Sep 26, 20231Sep 26, 20231
Published inTowards DevExploring Lesser Known SQL Functions for Data Analysis — Part IVWith Example QueriesSep 22, 2023Sep 22, 2023