Dev tools · alternatives · 2026
24 alternatives to SQLFrame – I ran PySpark without Spark on a SQL database
Recently I open-sourced SQLFrame, a DataFrame library that implements the PySpark DataFrame API but removes Spark as a dependency. It does this by generating the corresponding SQL for the DataFrame operations using SQLGlot. Since the output is SQL this also means that the PySpark DataFrame API can now be used directly against other databases without the Spark middleman. I built this because of two common problems I have faced in my career: 1. I prefer to write complex pipelines in PySpark but they can be hard to read for SQL-proficient co-workers. Therefore I find myself in a tradeoff…
SQLFrame is a DataFrame library that lets developers use the PySpark API without requiring Spark as a dependency. It converts DataFrame operations into SQL queries using SQLGlot, enabling the PySpark syntax to work… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. SQLFrame – I ran PySpark without Spark on a SQL database launched in 2024; newer entries below may have overtaken it.
- 1
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
- 2
Hey, guys. I've just made a plugin which turns your pandas dataframe into a tableau-style component. It allows you to explore the dataframe with easy drag-and-drop UI. You can use PyGWalker in Jupyter, Google Colab, or even Kaggle Notebook to easily explore your data and generate interactive visualizations. PyGWalker (pronounced like "Pig Walker", just for fun) is named as an abbreviation of "Python binding of Graphic Walker". Here are some links to check it out: The Github Repo: https://github.com/Kanaries/pygwalker Use PyGWalker in Kaggle:…
2023 · github.com · its alternatives →
- 3
Directus 9▲367Instant no-code app and dynamic API for any SQL database
2021 · directus.com · its alternatives →
- 4
- 5
ålenkå files. Full list of files for ålenkå
2012 · sourceforge.net · its alternatives →
- 6
This is a repo documenting the best practices in PySpark. - ericxiao251/spark-syntax
2019 · github.com · its alternatives →
- 7
We have been using graph DBs more and more at work. I found them painful to work with locally and decided to try and build something better.
Aug 2026 · github.com · its alternatives →
- 8DU
Hi! As I was working on a side project, I noticed I wanted to use SQLite like a Document Database on the server. So I built Doculite. DocuLite lets you use SQLite like Firebase Firestore. It's written in Typescript and an adapter on top of sqlite3 and sqlite. Reasons: 1) Using an SQL Database meant having less flexibility and iterating slower. 2) Alternative, proven Document Databases only offered client/server support. 3) No network. Having SQLite server-side next to the application is extremely fast. 4) Replicating Firestore's API makes it easy to use. 5) Listeners and real-time…
2023 · npmjs.com · its alternatives →
- 9
EnterpriseDB (“EDB”), the leader in accelerating Postgres® in the enterprise, today announced its acquisition of Splitgraph, an early-stage disruptor that provides a Postgres compatible serverless SQL API for building data driven applications from hundreds of datasources. This move is seen as a mean
2020 · splitgraph.com · its alternatives →
- 10AS
Hi HN, we're Eric and Dean, creators of SchemafreeSQL. Its roots go back to an on-line Web App Development Environment we developed back in 1999. It was comprised of an IDE, Web Server, Object Store, Virtual File System, Template System, and polyglot (Java, JavaScript, and Python). Of course, we named it “.OS”. Then we ended up dropping it. But that's a story for another time. It was the ease of use of the Object Store from .OS that we really missed, which brings us back to SchemafreeSQL. It provides an enhanced API to your SQL Database which allows it to function as a Schemaless…
2022 · schemafreesql.com · its alternatives →
- 11
A container for dataclasses with multi-indexing and bulk operations. - joshlk/dataclassframe
2020 · github.com · its alternatives →
- 12HA
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 →
- 13
Hello Everyone! We built SQLFlow as a lightweight stream processing engine. We leverage DuckDB as the stream processing engine, which gives SQLFlow the ability to process 10's of thousands of messages a second using ~250MiB of memory! DuckDB also supports a rich ecosystem of sinks and connectors! https://sql-flow.com/docs/category/tutorials/ https://github.com/turbolytics/sql-flow We were tired of running JVM's for simple stream processing, and also of bespoke one off stream processors I would love your feedback, criticisms and/or…
Dec 2025 · sql-flow.com · its alternatives →
- 14
A replacement for SQL for small and mid-size systems
2022 · github.com · its alternatives →
- 15
SQL Polyglot▲53Try running a query anywhere from PostgreSQL to DuckDB without leaving your browser.
2023 · codapi.org · its alternatives →
- 16
I've always been curious about how SQL engines actually work. So I built a minimum viable SQL engine in Go. - Supports CSV files as tables - Supports SELECT, FROM, WHERE, LIMIT It's very simple: 1. Parses query string 2. Converts it into an AST representation 3. Executes the query against the CSV 4. Returns the results
2024 · github.com · its alternatives →
- 17
Stackby combines spreadsheets, relational databases, AI fields & agents and automations in one no-code workspace. Free for up to 5 users — no credit card required.
2021 · stackby.com · its alternatives →
- 18
Postgres-Backed Drop-in Temporal Replacement. Contribute to dbos-inc/dbosify-py development by creating an account on GitHub.
Jun 2026 · github.com · its alternatives →
- 19
- 20QW
2023 · play.questdb.io · its alternatives →
- 21
I got tired of the overhead required to run even a simple data analysis - cloud setup, ETL pipelines, orchestration, cost monitoring - so I built a fully local data-stack/IDE where I can write SQL/Py, run it, see results, and iterate quickly and interactively. You get data lake like catalog, zero-ETL, lineage, versioning, and analytics running entirely on your machine. You can import from a database, webpage, CSV, etc. and query in natural language or do your own work in SQL/Pyspark. Connect to local models like Gemma or cloud LLMs like Claude for querying and analysis. You…
Apr 2026 · stream-sock-3f5.notion.site · its alternatives →
- 22
Hi everyone, I’m Timo, one of the creators of SuperDuperDB ! Today we are officially launching SuperDuperDB, an open-source framework for integrating AI directly with major databases, including streaming inference, scalable model training, and vector search, with release of v0.1. on GitHub and on ProductHunt. SuperDuperDB is not a database. It transforms your favorite database into an AI development and deployment environment (𝘮𝘢𝘬𝘪𝘯𝘨 𝘪𝘵 𝘴𝘶𝘱𝘦𝘳-𝘥𝘶𝘱𝘦𝘳). SuperDuperDB eliminates complex MLOps pipelines, specialized vector databases - and the need to migrate and duplicate data by…
2023 · github.com · its alternatives →
- 23
pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, Neptune, OpenSearch, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL). - aws/aws-sdk-pandas
2019 · github.com · its alternatives →
- 24
I'm a couple years late to the party but DuckDB is blowing my mind. I couldn't find an good embedded DuckDB stream processing solution so I hacked my own, calling it SQLFlow: https://github.com/turbolytics/sql-flow SQLFlow enables writing stream transformations in pure sql, executed using DuckDB. The goal was to create a lightweight, performant stream processing engine using pure SQL transformations, DuckDB didn't disappoint! I'd love your feedback, feature requests, impressions, or just comments. I'd love to turn this into a stable, usable project that people are…
2023 · github.com · its alternatives →
Also compare
- I wrote a RDBMS (SQLite clone) from scratch in pure Python alternatives
- Turn your Pandas dataframe into a Tableau-style UI for visual analysis alternatives
- Directus 9 alternatives
- Stein alternatives
- my database engine for GPU alternatives
- A Hands-On Guide on PySpark Coding and Best Practices alternatives
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 →