#sql on the community blog
Community posts tagged sql.
- Tools
DuckDB: fast SQL analytics on Parquet, CSV and DataFrames without a server
DuckDB is an in-process analytical database: no server, just a library. Here is how to query files and DataFrames directly, and where it fits next to pandas, Postgres and Spark.
- Tech articles
Composite indexes in SQL: why column order decides everything
How a multi-column B-tree index is actually used, the leftmost-prefix rule, and a simple way to choose column order for filters, ranges and sorting, with EXPLAIN examples.
Write for RecallRun
Start writingShare a tech article or a tool you built. Every post is checked and reviewed before it goes live.