FunSQL.jl
normconf2022 | FunSQL.jl | |
---|---|---|
2 | 4 | |
0 | 138 | |
- | 2.2% | |
10.0 | 8.0 | |
over 1 year ago | 2 days ago | |
HTML | Julia | |
MIT License | GNU General Public License v3.0 or later |
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.
normconf2022
- Replacing Pandas with Polars. A Practical Guide
-
PRQL a simple, powerful, pipelined SQL replacement
The last example in this notebook [0] shows how similar PRQL is to dplyr. The rest of the notebook shows how you can use PRQL from R, Python and the command line.
[0]: https://github.com/snth/normconf2022/blob/main/notebooks/nor...
FunSQL.jl
-
PRQL a simple, powerful, pipelined SQL replacement
You might enjoy the FunSQL library; SQL verbs are represented using regular Julia objects and you pipeline them together to build bigger queries. A key difference to other SQL builders is that you assemble a tree of "tabular operations" instead of a SQL syntax tree.
https://github.com/MechanicalRabbit/FunSQL.jl
- FunSQL.jl – Julia library for compositional construction of SQL queries
-
PRQL is a modern language for transforming data — a simpler and more powerful SQL
The developers of HTSQL are working now on FunSQL – https://github.com/MechanicalRabbit/FunSQL.jl
-
SQL: The difference between WHERE and HAVING
There is no HAVING and the you can use any tabular operators in any order. Aggregates are also separated from grouping and can be used in any context after Group is applied.
[0] https://github.com/MechanicalRabbit/FunSQL.jl
What are some alternatives?
ddl-diff - Generates SQL migrations by parsing and diffing DDL
TablaM - The practical relational programing language for data-oriented applications
trustfall - A query engine for any combination of data sources. Query your files and APIs as if they were databases!
DifferentialEquations.jl - Multi-language suite for high-performance solvers of differential equations and scientific machine learning (SciML) components. Ordinary differential equations (ODEs), stochastic differential equations (SDEs), delay differential equations (DDEs), differential-algebraic equations (DAEs), and more in Julia.
cargo-semver-checks - Scan your Rust crate for semver violations.
tresql - Shorthand SQL/JDBC wrapper language, providing nested results as JSON and more
prql-query - Query and transform data with PRQL
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
ArangoDB - 🥑 ArangoDB is a native multi-model database with flexible data models for documents, graphs, and key-values. Build high performance applications using a convenient SQL-like query language or JavaScript extensions.
Pluto.jl - 🎈 Simple reactive notebooks for Julia
SQLToy - Learn SQL by creating a SQL database in JavaScript