Database generated columns⁽¹⁾: Django & SQLite
Explores Django 5.0's new GeneratedField feature for database-calculated columns, with a focus on implementation using SQLite.
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.
A talk from DjangoCon Europe 2021 on leveraging PostgreSQL's advanced features within Django projects for enhanced database capabilities.
A detailed overview of new features in Django 3.2, focusing on ORM improvements like covering indexes, JSON object building, and new admin decorators.
An explanation of the MVC (Model-View-Controller) architectural pattern, covering its components and their roles in web application development.