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.
A tutorial on Konjection, a helper library built on Knex and Objection.js to simplify database operations and model creation in Node.js.
A tutorial on setting up and implementing many-to-many relationships in Ruby on Rails using a practical example with Investors and Companies.
A concise reference guide for Ruby on Rails developers covering CLI commands, Bundler, Active Record types, and model/route macros.
A guide to designing a data model for a Django survey application, covering models for Survey, Question, Option, and Submission.
A live coding session pairing with a new developer to work on a Ruby on Rails issue, covering fundamentals like Active Record and MVC.
A guide to translating NHibernate LINQ queries to SQL without executing them, using a custom ToSql() extension method for debugging.
