Introduces fastmigrate, a simple Python tool for managing SQLite database migrations without requiring a specific ORM.
Explores the concept of 'Design Pressure' in software architecture, examining invisible forces that shape code and discussing coupling, types, and ORMs.
A guide to implementing lazy loading for navigation properties in EF Core using the Proxies package, with a focus on MongoDB integration.
A developer shares a complex solution for dynamic column selection in Entity Framework using expressions, highlighting a self-admitted overengineered approach.
Explains a performance issue with ToListAsync/ToArrayAsync in EF Core when querying large data columns and recommends using synchronous versions.
A guide on managing Entity Framework Core migrations during development within .NET Aspire distributed applications.
Discusses the pros and cons of soft deleting database records, including implementation, performance, and alternatives.
A developer shares the design process and challenges of implementing improved lazy loading in their custom ORM, focusing on static analysis and reducing configuration.
The article argues that most programming tasks, from ORMs to routing, fundamentally involve text processing and data mapping.
Introduction to Jakarta Data specification and its stateless repositories for Java developers, using Hibernate as an implementation.
Explains how Entity Framework protects against SQL injection in LINQ queries but warns of risks when using raw SQL, highlighting safer alternatives.
Author discusses writing a technical article on using Alembic for database migrations in Python, published on TestDriven.io.
A tutorial on setting up a Next.js application with Prisma ORM and SQLite database, covering initial setup and migrations.
Learn how to use Entity Framework Core 8's SqlQuery<T> to map SQL results to any C# object, similar to Dapper, while keeping EF Core's strengths.
Explores using Complex Types in Entity Framework Core 8 to reduce database tables, simplify data models, and improve performance.
jOOQ 3.19 introduces new explicit and implicit to-many path joins, simplifying SQL query syntax and improving readability and correctness.
jOOQ 3.19.0 release adds support for DuckDB, Trino, Oracle 23c, introduces join path improvements, an official Gradle plugin, and commercial Maven repositories.
Explains how to store complex objects and lists as JSON in databases using Entity Framework 8 and 7, including configuration and benefits.
Discusses the pros and cons of using jOOQ's DAO API versus writing explicit SQL, highlighting the risk of N+1 problems.
Explores Django 5.0's new GeneratedField feature for database-calculated columns, with a focus on PostgreSQL implementation and examples.
