Next.js with Prisma and SQLite
A tutorial on setting up a Next.js application with Prisma ORM and SQLite database, covering initial setup and migrations.
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.
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.
A tutorial on connecting a PostgreSQL database to an Express.js application using the Sequelize ORM.