Andrei Pall

Linux Software Engineering

JPA Cascade Types Explained with Examples

In Java Persistence API (JPA), cascade types define which operations performed on a parent entity should automatically propagate to its associated child entities.

Read More

Complete Guide to JPQL Query Types in JPA

JPQL (Java Persistence Query Language) is an object-oriented query language used by JPA implementations such as Hibernate to query database entities.

Read More

MySQL Window Functions - Complete Guide

MySQL Window Functions are extremely useful for SQL developers, data analysts, and backend developers. They allow you to perform calculations across multiple rows while keeping each individual row in the result set.

Read More

Doctrine ORM cascade types explained with examples

In Doctrine ORM, cascade operations determine which operations performed on one entity are automatically propagated to its associated entities.

Read More

Complete Guide to Doctrine Query Language (DQL) in Symfony

Doctrine Query Language (DQL) is an object-oriented query language used by Doctrine ORM to retrieve and manipulate data from databases.

Read More

Creating a custom GTK widget from scratch

I'll demonstrate how to create a custom GTK 4 widget in C, using GObject, custom rendering, properties, signals, and mouse interaction.

Read More

Angular directory structure

For a new Angular 22+ project using standalone components, I recommend a feature-based directory structure, rather than organizing the entire application by file type.

Read More

Understanding GObject in C and GTK

GObject is one of the most important concepts in the GLib and GTK ecosystems.

Read More

GTK+ Memory Management Explained

GTK+ uses a memory management system based primarily on reference counting, provided by the GLib Object System (GObject).

Read More

Symfony CRUD Web Application

We'll build a complete server-rendered CRUD web application using Symfony 8, Twig, AssetMapper, jQuery, Doctrine ORM, MySQL, PHPUnit, and Mocks.

Read More