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.
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.
A technical guide on configuring NHibernate to log generated SQL statements to ASP.NET Core's built-in logging system using interceptors.
Learn how Django uses models to store user data from forms into a relational database, covering setup and core concepts.
A tutorial on performing table joins and querying database models using the Fluent 4 ORM framework in Vapor for Swift.
