Dev tools · alternatives · 2026

24 alternatives to Data algebra, going back to Codd's relational operators

When working with multiple data tables we often need to know how for a given set of keys, how many instances of rows each table has. I would like to use such an example in Python as yet another introduction to the data algebra (an alternative to direct Pandas or direct SQL notation). First let'

Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Data algebra, going back to Codd's relational operators launched in 2021; newer entries below may have overtaken it.

1
A Python container for dataclasses with multi-indexing and vector opps▲122
A container for dataclasses with multi-indexing and bulk operations. - joshlk/dataclassframe
2020 · github.com · its alternatives →
2AL
A little notebook for learning linear algebra with Python▲190
2025 · little-book-of.github.io · its alternatives →
3
Numeracy 2.0▲422
Write less SQL, faster
2018 · its alternatives →
4
Rows▲511
Import business data and analyze it using plain language.
2021 · rows.com · its alternatives →
5
I wrote a RDBMS (SQLite clone) from scratch in pure Python▲371
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
6IW
I Wrote a Book on Java▲586
https://www.manning.com/books/data-oriented-programming-in-j... This book is a distillation of everything I’ve learned about what effective development looks like in Java (so far!). It's about how to organize programs around data "as plain data" and the surprisingly benefits that emerge when we do. Programs that are built around the data they manage tend to be simpler, smaller, and significantly easier understand. Java has changed radically over the last several years. It has picked up all kinds of new language features which support data oriented programming (records,…
2024 · its alternatives →
7
I implemented a neural network in SQL▲121
Two weeks ago I was on my babymoon in Corfu, Greece. While in transit, I was overseeing a GSoC intern submit an important feature to my array database library, Xarray-SQL. He added `to_dataset()`, which completed the roundtrip between thinking of array data in a tabular model simultaneously as gridded rasters (the premise of the project is that every Nd array can be mapped to 2d, where orthogonal dims of the Nd array are just primary keys of a tabular representation). We discussed in chat, now that this feature existed, what demos could we make that would prove this data model works? With…
Jul 2026 · github.com · its alternatives →
8
Teable – Open-Source No-Code Database Fusion of Postgres and Airtable▲279
Features Spreadsheet-like interface All you want is here • Cell Editing: Directly click and edit content within cells. • Formula Support: Input mathematical and logical formulas to auto-calculate values. • Data Sorting and Filtering: Sort data based on a column or multiple columns; use filters to view specific rows of data. • Aggregation Function: Automatically summarize statistics for each column, providing instant calculations like sum, average, count, max, and min for streamlined data analysis. • Data Formatting: formatting numbers, dates, etc. • Grouping: Organize rows into collapsible…
2024 · github.com · its alternatives →
9
Quadratic▲198
Analyze your data with AI, Python, SQL, and formulas
2023 · quadratichq.com · its alternatives →
10
Simple-graph – a graph database in SQLite▲237
This is a simple graph database in SQLite, inspired by "SQLite as a document database" - dpapathanasiou/simple-graph
2020 · github.com · its alternatives →
11HA
Hashquery, a Python library for defining reusable analysis▲67
Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…
2024 · hashquery.dev · its alternatives →
12
All-pair similarity search on millions of sets in Python and on laptop▲123
All-pair set similarity search on millions of sets in Python and on a laptop - GitHub - ekzhu/SetSimilaritySearch: All-pair set similarity search on millions of sets in Python and on a laptop
2018 · github.com · its alternatives →
13
Dlt – Python library to automate the creation of datasets▲114
Hi HN, We're Anna, Adrian, Marcin and Matt, developers of dlt. dlt is an open source library to automatically create datasets out of messy, unstructured data sources. You can use the library to move data from about anywhere into most of well known SQL and vector stores, data lakes, storage buckets, or local engines like DuckDB. It automates many cumbersome data engineering tasks and can by handled by anyone who knows Python. Here’s our Github: https://github.com/dlt-hub/dlt Here’s our Colab demo:…
2023 · colab.research.google.com · its alternatives →
14
Visualize SQL Queries▲259
My co-worker and I were debugging a SQL issue; having not seen SQL in two years, I embarrassed myself by confusing union vs. join. After this episode, I tried refreshing my SQL memory, but there are few websites that animate SQL for you. Most of them just have a series of images to help you visualize. There are a few tools that are quite good and robust (especially for large/complex use cases) but require installation and are too complex for my simple purpose. So, just created a small tool to help visualise SQL. Most of the animations are just my understanding of how SQL works. Would…
2022 · animatesql.com · its alternatives →
15
Numeracy▲203
A SQL pad that gives you x-ray vision for your data
2017 · its alternatives →
16DD
Data Diff – compare tables of any size across databases▲127
Gleb, Alex, Erez and Simon here – we are building an open-source tool for comparing data within and across databases at any scale. The repo is at https://github.com/datafold/data-diff, and our home page is https://datafold.com/. As a company, Datafold builds tools for data engineers to automate the most tedious and error-prone tasks falling through the cracks of the modern data stack, such as data testing and lineage. We launched two years ago with a tool for regression-testing changes to ETL code…
2022 · its alternatives →
17
An Interpreter for Extended Relational Algebra (Scheme Based)▲52
An Interpreter for Extended Relational Algebra (Scheme based) - scvalencia/Coddie
2016 · github.com · its alternatives →
18
Csql – Python lib for composeable SQL queries▲89
Contribute to akdor1154/python-csql development by creating an account on GitHub.
2020 · github.com · its alternatives →
19
An expression parser supporting multiple types▲33
This C library is part of a main project aimed at providing a reactive key-value (KV) database. The data is typed (numbers, strings, dates, or booleans) and can include formulas with references to other entries. Clients connected to this database receive a real-time data stream with updates to the subscribed keys, allowing them to react to changes and their dependencies. Essentially, it’s like building a distributed Excel, where data and formulas dynamically update across the system. I couldn’t find any libraries that offered the full set of features I needed for evaluating expressions, so I…
2024 · github.com · its alternatives →
20
SQL-tString a t-string SQL builder in Python▲85
SQL-tString is a SQL builder that utilises the recently accepted PEP-750, https://peps.python.org/pep-0750/, t-strings to build SQL queries, for example, from sql_tstring import sql val = 2 query, values = sql(t"SELECT x FROM y WHERE x = {val}") assert query == "SELECT x FROM y WHERE x = ?" assert values == [2] db.execute(query, values) # Most DB engines support this The placeholder ? protects against SQL injection, but cannot be used everywhere. For example, a column name cannot be a placeholder. If you try this SQL-tString will raise an error, col = "x" sql(t"SELECT…
2025 · github.com · its alternatives →
21
I made this tool for navigating pandas datasets▲20
Visualizer for pandas data structures. Contribute to man-group/dtale development by creating an account on GitHub.
2020 · github.com · its alternatives →
22
Trilogy – A Reusable, Composable SQL Experiment▲78
Recipe: Add a semantic layer to SQL; use it drop the requirement for joins/group_by; add in type-checking and a lightweight python-esque import syntax to enable reuse and hierarchical querying. Trilogy is intended to provide an accessible but deep alternative to raw SQL. It offers a new-but-inspired-by-SQL syntax that compiles to various dialects of SQL (with DuckDB as the default). The target audience is people that really like SQL for analytics and data engineering, but want less boilerplate and sharp edges and looser coupling to the DB. Semantic models can be easily shared, composed…
2024 · trilogydata.dev · its alternatives →
23
Python for Data Analysis▲72
Pandas is the most common python library for data analytics
2016 · amazon.com · its alternatives →
24
SQL query for CSV▲85
Analyze CSV records using sql syntax right in your browser
2022 · csv-query.com · its alternatives →

Also compare

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →