A tutorial on migrating an on-premise MySQL database to Google Cloud SQL using Google's Database Migration Service for minimal downtime.
Explains how jOOQ 3.19's implicit joins can automatically eliminate unnecessary table joins from SQL queries, improving performance.
jOOQ 3.19 introduces new explicit and implicit to-many path joins, simplifying SQL query syntax and improving readability and correctness.
Explains a common MySQL UPDATE error and provides a workaround using a derived table or jOOQ to bypass the restriction.
jOOQ 3.19.0 release adds support for DuckDB, Trino, Oracle 23c, introduces join path improvements, an official Gradle plugin, and commercial Maven repositories.
Learn how Amazon CodeWhisperer uses generative AI to convert natural language into SQL code, accelerating database development.
Announcing the official paper and electronic version of the 'Practical MongoDB Aggregations' book, published by Packt with new content.
An introduction to analytical data warehouses, explaining their purpose, differences from transactional databases, and their role in team-based analytics.
A guide to using the EntityFramework.Exceptions library to handle specific database errors like constraint violations in Entity Framework.
A developer shares lesser-known Entity Framework features like AutoInclude and HasQueryFilter to improve code efficiency and avoid common pitfalls.
Explains how to filter on JSON array columns in Entity Framework Core 7 using SQL workarounds when LINQ translation fails.
A guide to creating, connecting to, and deleting Google Cloud Platform's managed Redis service, Memorystore, via UI and CLI.
A guide to creating, connecting to, and deleting MySQL Cloud SQL instances on Google Cloud Platform using both the Console UI and gcloud CLI.
A critical opinion piece arguing that AWS Amplify is harmful for production use, especially its GraphQL data layer, and promotes simpler alternatives like Postgres.
Entity Framework Core 8 introduces raw SQL queries that can return unmapped types, a highly anticipated feature for .NET developers.
Explores efficient database methods for reordering items, inspired by Trello/Jira drag-and-drop functionality.
A tutorial on integrating Entity Framework Core 7 into an ASP.NET Core web application, covering project setup and database configuration.
A guide to emulating window functions in MySQL 5.7 using local variables, highlighting the limitations and risks of this approach.
Explains the benefits of executing database queries with jOOQ's API instead of extracting SQL for use with other tools like JdbcTemplate.
jOOQ introduces a LoggingConnection for R2DBC to log all reactive SQL statements, useful for debugging in reactive applications.
