GORM vs. Native SQL: Selecting a Persistence Strategy in Grails
Learn when to use GORM versus Native SQL in Grails. This guide compares performance, maintainability, and implementation for data-intensive operations.
Loading…
ReadMeFeed / Community knowledge
#sql
Real questions. Useful conversations. Find the people who know your stack.
hibernateGuarding Liquibase Migrations with Preconditions to Prevent Duplicate Schema Changes
Learn how Liquibase preconditions guard migrations against duplicate changes, with a real example, trade‑offs, and best practices to keep your database in the expected state.
Using MariaDB SYSTEM VERSIONED Tables for Built‑In Audit Trails
Learn how to enable MariaDB SYSTEM VERSIONED tables for automatic audit trails, query historical data with FOR SYSTEM_TIME, and manage storage overhead.
Seeing the SQL Behind Your EF Core Pagination in Rider
Rider can show the SQL your EF Core Take/Skip pagination generates before you run it. Here's how to use that preview to catch full-table scans, N+1 queries, and deep-offset problems early.
Stop Alt-Tabbing to a SQL Client: PhpStorm's Database Tool Window Does More Than You Think
PhpStorm's built-in Database tool window is a full SQL client with schema-aware completion and refactoring. Here's what it does well, where it falls short, and how to validate it in ten minutes.
jetbrainsOpening a 200-Million-Row Table in DataGrip Without Regretting It
DataGrip's automatic result-set paging appends LIMIT/OFFSET to your queries so opening a huge table doesn't freeze your IDE. Here's how it works, how to verify it, and where it bites.
datagripDataGrip Paging: Why the Grid's Row Count Isn't the Table's Size
DataGrip's result grid fetches rows in pages, so the count you see reflects what's been fetched — not the table's size. Here's how to page deliberately and when to push the work to SQL.
Boosting SQL Productivity in DataGrip: How Code Completion and Syntax Highlighting Cut Development Time
DataGrip’s database console uses code completion and syntax highlighting to reduce SQL errors and speed up query writing. Learn how to use these features, avoid stale schema pitfalls, and boost your development workflow.
PostgreSQL Generated Columns: Automate Computed Data Without Triggers
PostgreSQL generated columns automatically compute and store values within the same transaction as source data, eliminating trigger complexity for full-text search, denormalized metrics, and other derived data.