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.
Explores Django 5.0's new GeneratedField feature for database-calculated columns, with a focus on implementation using SQLite.
A developer shares lesser-known Entity Framework features like AutoInclude and HasQueryFilter to improve code efficiency and avoid common pitfalls.
A technical case study on debugging a Django performance issue, detailing the investigation process and tools used.
A developer's notes on Cory Zue's Django livecoding session, comparing Django's ORM, migrations, and admin UI to Flask development.
Entity Framework Core 8 introduces raw SQL queries that can return unmapped types, a highly anticipated feature for .NET developers.
A developer discusses moving away from ORMs in server-side Swift, preferring direct Postgres integration and type safety with SchemaSwift.
A tutorial on integrating Entity Framework Core 7 into an ASP.NET Core web application, covering project setup and database configuration.
Entity Framework 8 introduces raw SQL queries for unmapped types, reducing boilerplate code for developers.
A guide for developers on when to use the jOOQ API versus writing native SQL, comparing pros and cons for each approach.
Explains how to use EF Core Query Splitting to solve performance issues like Cartesian Explosion in database queries.
Explores jOOQ 3.17's new client-side computed columns feature, which allows creating dynamic, view-like columns in Java without SQL limitations.
Benchmark comparing performance of jOOQ's MULTISET emulation vs. other approaches for nesting to-many relationships in SQL queries.
Explores whether setting JDBC Statement.setFetchSize(1) for single-row queries improves performance, with benchmark results across databases.
Strategies for database initialization in EF Core, covering automatic setup, early dev recreation, and late dev migrations.
A tutorial on connecting a PostgreSQL database to an Express.js application using the Sequelize ORM.
A tutorial on implementing a one-to-many database relationship with user authentication using the Masonite framework in Python.
A tutorial on connecting a Ruby Sinatra application to a PostgreSQL database using the Sequel ORM for basic data operations.
