Comparing SQLite, DuckDB and Arrow

This page summarizes the projects mentioned and recommended in the original post on

Our great sponsors
  • OPS - Build and Run Open Source Unikernels
  • Scout APM - Less time debugging, more time building
  • SonarLint - Deliver Cleaner and Safer Code - Right in Your IDE of Choice!
  • GitHub repo db-benchmark

    reproducible benchmark of database-like ops

    this benchmark is more comprehensive for this type of analytical work:

  • GitHub repo sqldf

    Perform SQL Selects on R Data Frames

  • OPS

    OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.

  • GitHub repo duckdb_and_r

    My thoughts and examples on DuckDB and R

    I enjoyed this comparison, thanks! Here is a related generally R-centric comparison that you might enjoy of DuckDB, dplyr, data.table, etc. applied to five data-sciency problems I wrote up a few months ago:

  • GitHub repo parquet-cpp

    Apache Parquet

  • GitHub repo Apache Arrow

    Apache Arrow is a multi-language toolbox for accelerated data interchange and in-memory processing

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts