A Deep Dive into Apache Doris Indexes

Developers in the big data field know that quickly retrieving data from a vast amount of information is like searching for a specific star in the constellations — extremely challenging. But don’t worry! Database indexes are our “positioning magic tools,”...

April 15, 2025

Get the Records after and before the Searched One — From SQL to SPL #18

News

Get the Records after and before the Searched One — From SQL to SPL #18

Problem description & analysis: The ProductionLine_Number in a certain table of the Mariadb database is a grouping field, and there are duplicate values in the Cardboard_Number field within the group. Task: Group by ProductionLine_Number, sort by date_Time within the group,...

April 14, 2025

How To Prevent WordPress SQL Injection Attacks — Smashing Magazine

News

How To Prevent WordPress SQL Injection Attacks — Smashing Magazine

What makes WordPress websites such a prime target for hackers? Anders Johansson delves into how WordPress SQL injection attacks work and shares strategies for removing and preventing them. Did you know that your WordPress site could be a target for...

March 13, 2025

A Developer’s Guide to Handling Sensitive Data With DuckDB

News

A Developer’s Guide to Handling Sensitive Data With DuckDB

Understanding DuckDB for Data Privacy and Security Data privacy and security have become critical for all organizations across the globe. Organizations often need to identify, mask, or remove sensitive information from their datasets while maintaining data utility. This article explores...

December 23, 2024

News

Joins in SQL

Joins in SQL are operations that allow you to combine rows from two or more tables based on a related column between them. They enable you to retrieve data from multiple tables in a single query, which is essential for...

October 22, 2024

How to Use Self Join and With Clause in Oracle – DZone

News

How to Use Self Join and With Clause in Oracle – DZone

The Oracle WITH clause is one of the most commonly used techniques to simplify the SQL source code and improve performance. In Oracle SQL, the ‘WITH’ clause also known as a Common Table Expression (CTE) is a powerful tool which...

October 18, 2024

Convert CSV Data into Multilevel JSON #eg56

News

Convert CSV Data into Multilevel JSON #eg56

Problem description & analysis Below is data in CSV file csv.csv: metric,value,date temp_a,622.0,1477895624866 temp_a,-3.0,1477916224866 temp_a,365.0,1477917224866 temp_b,861.0,1477895624866 temp_b,767.0,1477917224866 We are trying to convert the categorized CSV data into multilevel data, as shown below: [ { “metric”:”temp_a”, “datapoints”:[ [622, 1477895624866], [-3, 1477916224866], ...

October 12, 2024

Understanding SQL Joins in DBMS: A Comprehensive Guide to Inner, Outer, Left, Right, and Full Joins.

News

Understanding SQL Joins in DBMS: A Comprehensive Guide to Inner, Outer, Left, Right, and Full Joins.

In relational databases, data is often stored across multiple tables, requiring efficient ways to retrieve and merge this information. SQL joins are fundamental in Database Management Systems (DBMS) for combining data from different tables based on common columns. This blog...

October 9, 2024

News

Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

Introduction This article is based on real problems I had in a production environment in Oracle 11g. Oracle Database provides powerful networking capabilities, allowing PL/SQL programs to interact with external systems over the network. To enhance security, Oracle introduced Access...

September 26, 2024

Concurrency Issues in SQL and Distributed Systems – DZone

News

Concurrency Issues in SQL and Distributed Systems – DZone

An SQL database must handle multiple incoming connections simultaneously to maintain optimal system performance. The expectation is that the database can accept and process numerous requests in parallel. It’s straightforward when different requests target separate data, such as one request...

September 26, 2024

1 2 … 6 7