Querying Parquet Files Directly in DuckDB with Predicate Pushdown and Column Pruning
Learn how DuckDB can query Parquet files directly, pushing down predicates and pruning columns for fast analytics without ETL.
Loading…
ReadMeFeed / Community knowledge
#sql
Real questions. Useful conversations. Find the people who know your stack.
Using Liquibase Preconditions to Safeguard Schema Migrations
Learn how Liquibase preconditions guard against unintended schema changes, see a concrete XML example, weigh trade‑offs, and get step‑by‑step guidance for safe, idempotent deployments.
Using DuckDB's ATTACH to Query Multiple Database Files
Learn how DuckDB's ATTACH command lets you query multiple .duckdb files as if they were schemas, with a step‑by‑step example, limits, and common mistakes to avoid.
duckdbChoosing a Liquibase Changelog Format: Abstraction vs. Native SQL
Deciding between XML, YAML, and SQL in Liquibase impacts your database portability and validation. This guide compares abstraction vs. native SQL for schema migrations.
Using Named Parameterized Queries in DataGrip SQL Console
Learn how to write safe, reusable SQL with named placeholders like :emp_id in DataGrip, set values via the Parameters dialog, and verify that a PreparedStatement is used.
datagripScaling ClickHouse Reads with Distributed Tables: A Practical Guide
Learn how ClickHouse’s Distributed table engine can eliminate read bottlenecks in reporting dashboards. Step‑by‑step setup, a real query example, trade‑offs, and practical next steps to scale your cluster without rewriting code.
clickhouseWhy Knex's Handler-Style Transactions Should Be Your Default for Multi-Statement Writes
Knex's handler-style transactions auto-commit on success and auto-rollback on throw, eliminating the leaked-connection failure mode of manual transactions. Here's why they should be your default, plus the trx-forgetting trap to avoid.
nodejs
knexjsExporting Tables and Query Results to CSV in DBeaver: A Practical Configuration
DBeaver's Export Data wizard turns any table or query result into a CSV. Here's the configuration that round-trips cleanly, how to verify it, and where the client-side export breaks down.
dbeaverDynamic SQL WHERE Clauses with Knex.js: Safe Filtering Without String Concatenation
Build safe, dynamic SQL filters in Knex.js using conditional .where() calls and parameterized values. Avoid string concatenation and SQL injection.