FunSQL.jl
SQLToy
| FunSQL.jl | SQLToy | |
|---|---|---|
| 4 | 5 | |
| 138 | 122 | |
| 2.2% | - | |
| 8.0 | 0.0 | |
| 2 days ago | over 1 year ago | |
| Julia | JavaScript | |
| GNU General Public License v3.0 or later | MIT License |
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.
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
SQLToy
- Shouldn't FROM come before SELECT in SQL?
-
SQL: The difference between WHERE and HAVING
You might look at SQLToy which is a DB and blog I wrote to teach how SQL processing works internally: https://github.com/weinberg/SQLToy
-
Show HN: SQLToy – a tiny relational database for learning SQL via code
I am a Javascript developer and I've used SQL for years but it's always been a bit of a black box. I recently learned about the SQL order of operations and the relational model and it kind of blew my mind. In the process of digesting this information I wrote my own database in Javascript which I think might help others in my same situation. The result is SQLToy.
It is a SQL database written in Javascript. It's under 500 lines of code (including comments) and has zero dependencies.
The purpose of SQLToy is not to use it as a database but to learn SQL. Instead of doing this from the "outside-in" by learning the query language you do it "inside-out" by going through the implementation of the most common SQL operators. Instead of just learning what the operators do, you also learn how they do it which (hopefully!) should lead to a much deeper level of understanding.
A detailed wiki walks through the code of 15 different SQL operations including SELECT, WHERE, JOINs, GROUP BY, Aggregate Functions COUNT, AVG, MAX, MIN to name a few.
The wiki can be found here: https://github.com/weinberg/SQLToy/wiki
Feedback appreciated!
- Show HN: SQLToy – my zero-dependency SQL database in
What are some alternatives?
TablaM - The practical relational programing language for data-oriented applications
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.
tresql - Shorthand SQL/JDBC wrapper language, providing nested results as JSON and more
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
Pluto.jl - 🎈 Simple reactive notebooks for Julia
prql-query - Query and transform data with PRQL
ddl-diff - Generates SQL migrations by parsing and diffing DDL
normconf2022
Octo.jl - Octo.jl 🐙 is an SQL Query DSL in Julia
BabySqueel - :pig: An expressive query DSL for Active Record
zillion - Make sense of it all. Semantic data modeling and analytics with a sprinkle of AI. https://totalhack.github.io/zillion/