SQL
-
Python
Python vs SQL for Data Transformation: When ETL Meets DataFrame Magic
In the data engineering world, two titans compete for dominance in data transformation: SQL, the venerable language that has powered…
Read More » -
Core Java
H2 Stored Procedures in Java
Stored procedures are a common way to encapsulate reusable logic within a database. While H2 is an in-memory Java SQL…
Read More » -
Core Java
Using UNION Logic in Hibernate Applications
Hibernate is a Java ORM tool that allows interaction with relational databases using entity objects. However, it lacks native support…
Read More » -
Python
Build Text-to-SQL using LLM
Text-to-SQL is a powerful application of large language models (LLMs) like GPT that enables users to interact with a database…
Read More » -
Core Java
Working with Sequences in H2 Database
When developing Java applications with databases, auto-generating primary keys is a common requirement. Sequences are a reliable way to generate…
Read More » -
Software Development
Introduction to Apache Kylin
In the era of big data analytics, fast query performance over massive datasets has become an essential requirement. Traditional relational…
Read More » -
Core Java
How to Reuse PreparedStatement in Java
Java Database Connectivity (JDBC) remains the standard foundation for interacting with relational databases in Java applications. One of its key…
Read More » -
Core Java
jOOQ: SQL Made More Functional in Java
When working with databases in Java, developers typically use JDBC or ORM frameworks like Hibernate to interact with SQL databases.…
Read More » -
Enterprise Java
Tear Down HSQLDB Database After Tests
Testing is a critical aspect of software development, and maintaining a clean test environment ensures accurate and reliable results. This…
Read More »
