A tutorial on integrating Entity Framework Core 7 into an ASP.NET Core web application, covering project setup and database configuration.
A guide to emulating window functions in MySQL 5.7 using local variables, highlighting the limitations and risks of this approach.
Explains the benefits of executing database queries with jOOQ's API instead of extracting SQL for use with other tools like JdbcTemplate.
jOOQ introduces a LoggingConnection for R2DBC to log all reactive SQL statements, useful for debugging in reactive applications.
A guide to integrating the Neo4J graph database with Spring Boot, including entity definition, data creation, and querying nodes and relations.
Entity Framework 8 introduces raw SQL queries for unmapped types, reducing boilerplate code for developers.
A tutorial on implementing a simple, reusable pagination solution for Entity Framework using a PagedList class and extension method.
Explains how to delete a database record in Entity Framework without loading it first, covering both classic and .NET 7+ methods.
A guide for developers on when to use the jOOQ API versus writing native SQL, comparing pros and cons for each approach.
Learn how to access and manage your WordPress database directly from the dashboard using the Adminer plugin as an alternative to phpMyAdmin.
A tutorial on building a basic embedded SQL database in Zig using RocksDB, covering lexing, parsing, storage, and execution.
Explains how to use the SQL LATERAL keyword to create local column variables and simplify complex queries, improving readability.
An introduction to LiteDB, a lightweight, serverless NoSQL document database for .NET, exploring its features, use cases, and differences from SQL databases.
Explains pagination concepts, formulas, and implementation in C#/SQL, comparing it to infinite scrolling for efficient data loading.
Explains how to use EF Core Query Splitting to solve performance issues like Cartesian Explosion in database queries.
Explores a powerful jOOQ feature: using implicit JOINs within explicit JOIN ON clauses for complex PostgreSQL metadata queries.
A tutorial on implementing full-text search in Django applications using PostgreSQL's built-in search capabilities.
jOOQ 3.17 extends implicit join support to UPDATE and DELETE statements, simplifying DML queries with path expressions.
A guide on using jOOQ and Testcontainers to write integration tests for database stored procedures in Java, replacing manual JDBC calls.
Explains why offset-based pagination is inefficient for large datasets and introduces faster cursor/keyset pagination techniques for server-side APIs.
