Links tagged “sql”

markusholtermann.eu

Advanced Django ORM query techniques — aggregation, query optimisation, and picking the top-k rows per group without dropping to raw SQL.

jvns.ca

Why a SELECT query is evaluated as FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT rather than in written order, and what that explains about SQL's rules.

edgedb.com

Home page of EdgeDB, a graph-relational database built on PostgreSQL with its own query language EdgeQL; the project is now called Gel.

cybertec-postgresql.com

Why aggregating first and joining the lookup table afterwards beats joining five million rows then grouping, with the execution plans that explain the gap.

pgdash.io

Tour of ten under-used PostgreSQL features, from LISTEN/NOTIFY and foreign data wrappers to range types, BRIN indexes and full-text search.

metabase.com

Open-source business intelligence tool that lets people query databases, build dashboards and explore data through a visual query builder rather than SQL.

knexjs.org

Knex.js, a SQL query builder for Node.js and the browser, supporting PostgreSQL, MySQL, SQLite and Oracle with callback, promise and stream interfaces.

superset.incubator.apache.org

Open-source data exploration and visualisation platform — charts built by drag and drop or SQL, interactive dashboards, and connectors to most SQL databases.

blog.timescale.com

Argues that NoSQL's fragmented query languages pushed developers back to SQL, which is becoming the universal interface for data analysis — the "narrow waist" of the data stack.

timescale.com

Product site for TimescaleDB, the extension that turns PostgreSQL into a time-series database, keeping full SQL over high-rate metric ingestion.

explain.depesz.com

Paste a PostgreSQL EXPLAIN plan and get it back as a readable annotated tree that highlights the costly nodes; plans can be shared or anonymised.

osquery.io

SQL-powered instrumentation framework that exposes a Linux, macOS or Windows machine as a relational database of processes, ports, users and files.

sqlstyle.guide

Style guide for SQL covering naming conventions, keyword capitalisation, whitespace and indentation for joins and subqueries, and portable CREATE syntax.

prestodb.io

A distributed SQL query engine for interactive analytic queries across data sources of mixed kinds.

dbazine.com

Vadim Tropashko compares nested sets and materialized path for storing trees in SQL, then derives a hybrid encoding that mixes the two.

phpdoctrine.org

Home of the Doctrine project, whose libraries cover database storage and object mapping for PHP — chiefly the Doctrine ORM and the DBAL abstraction layer.