opteryx
sqlparser-rs
| opteryx | sqlparser-rs | |
|---|---|---|
| 1 | 12 | |
| 43 | 2,443 | |
| - | 2.4% | |
| 9.8 | 9.3 | |
| 6 days ago | 3 days ago | |
| Python | Rust | |
| Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
opteryx
-
Pure Python Distributed SQL Engine
Thanks for sharing.
I have a SQL Engine in Python too (https://github.com/mabel-dev/opteryx). I focused my initial effort on supporting SQL statements and making the usage feel like a database - that probably reflects the problem I had in front of me when I set out - only handling handfuls of gigabytes in a batch environment for ETLs with a group of new-to-data-engineering engineers. Have recently started looking more at real-time performance, such as distributing work. Am interesting in how you've approached.
sqlparser-rs
-
Introducing SQLPage : write websites entirely in SQL
sqlparser to parse SQL queries and detect variable bindings
-
Understanding the SQL AST and what can be done with it
So to start with this, I looked into SQL parsing and found this library https://github.com/sqlparser-rs/sqlparser-rs
-
Supabase Logs: open source logging server
We switched to an open source alternative, the rust-based sqlparser-rs library, contributing a few updates for the BigQuery dialect.
- Parsing SQL with Rust
-
Writing a SQL LS in Rust - Looking for Coding Companions.
I have experience with sqlparser-rs (for my sqlpage project), but it does not track the source code location of the parsed data structures (yet).
-
Pure Python Distributed SQL Engine
It uses https://github.com/sqlparser-rs/sqlparser-rs as the parser and lexer. The binder, planner, optimizer and executor are in Python. The optimizer stage only works on the logical plan and the rules are heuristic only.
-
Parsing / Recursive Descent Parser
That code could be copied directly from some real-world examples - sqlparser-rs code looks pretty much exactly the same.
https://github.com/sqlparser-rs/sqlparser-rs
-
RisingLight is an OLAP database system for educational purpose
Also neat to find the SQL parser library they use.
- We Went All in on Sqlc/Pgx for Postgres and Go
- “Swift is the only language I could find with over 100 keywords”
What are some alternatives?
quokka - Making data lake work for time series
sled - the champagne of beta embedded databases
nomad - Deprecated and re-branded as Alto
goyesql - Parse SQL files with multiple named queries and automatically prepare and scan them into structs.
influxdb3-python - Python module that provides a simple and convenient way to interact with InfluxDB 3.0.
sqlite
pg8000 - A Pure-Python PostgreSQL Driver
kube - Rust Kubernetes client and controller runtime
datafusion-ballista - Apache Arrow Ballista Distributed Query Engine
prettytable-rs - A rust library to print aligned and formatted tables
emr-serverless-samples - Example code for running Spark and Hive jobs on EMR Serverless.
go - The Go programming language