SQL Comparisons

Microsoft's commercial database, with free Express and Developer editions, against the open source PostgreSQL.

Microsoft's SQL Server against Oracle AI Database: editions, licensing, options and SQL dialect.

Two widely used open source relational databases: licensing, JSON, HA and SQL dialect compared.

Oracle's GPL licensed MySQL against Microsoft's SQL Server and its free and paid editions.

Open source PostgreSQL against commercially licensed Oracle AI Database, and what a migration involves.

A document database against a relational database with strong JSON support.

An embedded, serverless database against a client-server one.

The MySQL fork against the original, and how they diverged.

A document database against a relational database with a native JSON type.

A document database against Microsoft's relational platform.

Oracle's two databases: open source MySQL against Oracle Database.

An embedded file database against a full client-server database.

Two open source relational databases with different licences and feature sets.

Two embedded databases: one built for analytics, one for transactions.

An in-process analytical engine against a general purpose database server.

A columnar analytics database against a row-store relational database.

An in-memory data structure store against a document database.

A wide-column store built for write-heavy scale against a document database.

AWS's serverless key-value and document service against MongoDB and Atlas.

A distributed SQL database with PostgreSQL compatibility against PostgreSQL itself.

A columnar analytics database against a transactional row store, and how to keep them in sync.

AWS's serverless key-value store against a relational database.

An in-memory data store against a relational database, and how they work together.

A columnar analytics database against a document database, and how to analyse MongoDB data in ClickHouse.

AWS's serverless key-value store against MySQL, and scaling MySQL with Aurora or Vitess instead.

A distributed SQL database against MySQL and its scaling options.

Quest's commercial Oracle toolset against Oracle's free tool and its VS Code extension.

Oracle's free tool against a JetBrains multi-database IDE.

Oracle's free tool against a free universal client.

MongoDB's free official GUI against a commercial MongoDB IDE with SQL queries, data compare and scheduling.

A paid multi-platform client against a free GPL one.

A multi-database client against the rebuilt official MySQL tool.

Two modern, focused SQL clients with different licence models.

A commercial management suite against a free, lean client.

Two cross-platform JDBC clients with different editors and licences.

Quest's paid Toad products, mostly Windows-first, against a free cross-platform universal client.

Azure Data Studio is retired: where to move, SSMS or VS Code with the MSSQL extension.

After Azure Data Studio: SSMS or VS Code with the MSSQL extension, with a feature-by-feature migration map.

Free universal client versus JetBrains paid database IDE.

A broad open source client against a lightweight native one.

Open source universal client against a long-established commercial suite.

Two free open source clients: a universal all-rounder and a focused MariaDB and MySQL tool.

A multi-database client against the official MySQL tool, now rebuilt as Workbench 26.

A multi-database client against the official PostgreSQL admin tool.

A full JetBrains IDE against a fast, minimal native client.

A paid commercial suite against the free official MySQL tool.

A free multi-engine client against Oracle's free MySQL-only tool.

A cross-platform multi-database client against Microsoft's SQL Server tool.

A JetBrains database IDE, free only for non-commercial use, against Microsoft's free SQL Server tool.

Two commercial multi-database tools with different strengths and licence models.

Two long-running cross-platform JDBC clients with free and paid editions.

A focused modern SQL editor against a broad universal client.

A minimal multi-database client against a full commercial management suite.

A dedicated database IDE against a code editor with database extensions.

A multi-database JetBrains IDE against the official MySQL tool.

A multi-database JetBrains IDE against the free, open source PostgreSQL admin tool.

Managed relational databases on AWS and Azure, compared.

Managed MySQL, PostgreSQL and SQL Server on AWS and Google Cloud, plus RDS-only MariaDB, Oracle and Db2.

Microsoft's SQL Server-based cloud family against Google's managed databases.

Standard managed engines against AWS's cloud-native MySQL and PostgreSQL.

AWS's MySQL-compatible service against running MySQL yourself or on RDS.

Microsoft's two PaaS SQL options and the compatibility trade-off between them.

Google's managed PostgreSQL options: standard Cloud SQL or AlloyDB.

Serverless, branchable Postgres (now part of Databricks) against provisioned RDS for PostgreSQL.

A PostgreSQL-based backend platform against Google's NoSQL-based one.

A PostgreSQL backend platform against Databricks-owned serverless Postgres with branching and scale to zero.

A PostgreSQL backend platform against a database-only service offering MySQL (Vitess) and PostgreSQL.

Serverless, branchable PostgreSQL against PlanetScale's provisioned Vitess MySQL and Postgres clusters.

Microsoft's managed cloud database against self-managed SQL Server.

A Postgres backend platform against managed Postgres on AWS.

SQLite-based edge databases against a Postgres backend platform.

SQLite-compatible databases against serverless Postgres.

Two SQLite-based serverless databases for edge applications.

A backend-as-a-service with a NoSQL database against a relational database you run or rent.

AWS's two managed PostgreSQL options, compared for PostgreSQL users.

Choosing an engine on Amazon RDS: features, versions and operations.

A managed Vitess and Postgres platform against AWS's managed databases.

A cloud data warehouse against a lakehouse platform, and where they now overlap.

Multi-cloud credits-based warehousing against Google's serverless warehouse.

Snowflake against AWS's own data warehouse, provisioned or Serverless, for teams on AWS.

A lakehouse platform against Google's serverless warehouse.

A lakehouse platform against AWS's data warehouse.

Google's and AWS's native data warehouses: per-TiB and slot pricing against node-hours and Serverless RPUs.

Snowflake against Azure Synapse dedicated SQL pools, and Microsoft's guidance to start new warehouses on Fabric.

Two lakehouse-based analytics platforms with different pricing and scope.

When analytics outgrows PostgreSQL, and when it does not.

A cloud warehouse against SQL Server for reporting and analytics workloads.

A warehouse with PostgreSQL roots against PostgreSQL itself.

A serverless analytics warehouse against a general purpose database.

An open source columnar database against a managed cloud warehouse.

Open source real-time analytics against Google's serverless warehouse.

A columnar analytics database against a lakehouse platform.

Local in-process analytics against a cloud data warehouse.

Local in-process analytics against Google's serverless warehouse.

Two distributed SQL query engines that share an origin.

An interactive SQL query engine against a general-purpose processing engine.

Self-hostable data integration against a fully managed connector service.

Self-hostable integration against Stitch, which Qlik now steers new customers away from.

A UI-led ingestion platform against a code-first CLI built on Singer taps.

Self-hostable integration against a no-code, managed-only pipeline service.

A self-hostable ingestion tool against Matillion's transformation-centred platform.

Source-available ELT against Qlik Talend Cloud and Talend Studio, after Talend Open Studio was discontinued.

Managed ELT against Stitch, now part of Qlik and being folded into Qlik Talend Cloud.

Two managed pipeline services compared on connectors and pricing.

Managed ingestion against a pipeline and transformation platform.

Managed ELT against an enterprise data integration suite.

Two enterprise data integration suites, both now owned by larger vendors.

Matillion's Maia Foundation pushdown ELT against Qlik's Talend integration suite.

An orchestrator against an ingestion tool, and why teams use both.

Writing your own pipelines against buying managed connectors.

Two Python workflow orchestrators with different models.

Task-based orchestration against an asset-based one.

Two modern Python orchestrators compared.

Two database schema migration tools with different change formats.

A database-agnostic changelog tool against SQLAlchemy's migration tool.

SQL-first versioned migrations against Python-scripted ones.

Two TypeScript ORMs with different approaches to schema and SQL.

A schema-first, generated-client TypeScript ORM against a class-based one with Active Record and Data Mapper.

Two long-standing SQL Server monitoring tools compared.

Estate monitoring against wait-time-based performance analysis.

SolarWinds' SQL Server specialist against its multi-engine wait-time analyser, and the licence they share.

A cloud observability platform against a dedicated database performance tool.

Observability-platform database monitoring against a DBA-focused monitor.

Two observability platforms compared on database monitoring and pricing.

Self-run open source metrics against a managed observability service.

A PostgreSQL admin GUI with dashboards against a log analyser.

Microsoft's and Salesforce's BI tools compared on licensing, data connections and fit.

Microsoft's BI tool against Google's semantic-model-first platform.

An enterprise BI suite against an open source, SQL-friendly one.

Visual analytics against a modelling-layer-first BI platform.

Two open source BI tools for SQL users, compared.

Google's enterprise LookML platform against its free report builder, renamed Data Studio in April 2026.

When spreadsheet reporting stops scaling, and when Excel is still the right tool.

Visual analytics against spreadsheets, and when to switch.

Qlik's associative engine against Microsoft's BI platform.

Two enterprise analytics platforms with different data models.

An enterprise visual analytics suite against an open source BI tool.

Microsoft's licensed BI suite against the Apache-licensed Superset.

Commercial visual analytics against open source, SQL-first dashboards.

A governed LookML semantic layer against lightweight open source BI.

Business questions on SQL data against operational dashboards.

Observability dashboards against business intelligence.

What the free edition covers, and what the paid editions add.

Free Express (50 GB per database in SQL Server 2025) against paid Standard.

Which paid edition you actually need, and what Enterprise adds.

The free editions: production-licensed Express against the new Standard and Enterprise Developer editions.

How the two data models shape schema design, queries and change.

A BI tool and a query language: what each does and why analysts need both.

What each covers, where they overlap, and why teams use both.

Transform before loading, or after, and what changed with cloud warehouses.

How ETL relates to the broader idea of a data pipeline.

What separates analytical warehouses from operational databases.

SQL against DataFrames for analysing data in Python.

Relational databases versus document, key-value and other NoSQL stores.