Preql
malloy
| Preql | malloy | |
|---|---|---|
| 16 | 21 | |
| 613 | 2,023 | |
| - | 1.0% | |
| 0.0 | 9.8 | |
| over 2 years ago | 5 days ago | |
| Python | TypeScript | |
| 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.
Preql
- Pql, a pipelined query language that compiles to SQL (written in Go)
-
PRQL, Pipelined Relational Query Language
Hm, I just realized there are two similar projects with very similar names: this one, and
https://github.com/erezsh/Preql
-
Oops, I wrote yet another SQLAlchemy alternative (looking for contributors!)
First, let me introduce myself. My name is Erez. You may know some of the Python libraries I wrote in the past: Lark, Preql and Data-diff.
-
Why don't SQL transpilers take off?
Example of language that implements this: https://github.com/erezsh/Preql
-
Even Babies fear … Fu**ing SQL
But what about PreQL?
-
Show HN: PRQL – A Proposal for a Better SQL
It seems people here are really interested in alternatives to SQL. So perhaps you'd also like to have a look at https://github.com/erezsh/Preql
(Same name, same goal, different approach, and already working)
-
Made a Programing language using python
There's also lark, which is used by a plethora of projects (I haven't used it, but I heard about PreQL on a podcast where they talk for a bit about what it's like to develop a new language in lark)
-
A primer on programming languages for data science
Just want to mention preql exists as an option - https://github.com/erezsh/Preql
- Ask HN: SQL tooling: REPL-likes, Intellisense, etc.
-
Against SQL
I share the author's point of view, which led me to start a new relational programming language that compiles to SQL. If that sounds interesting, you can find it here: https://github.com/erezsh/Preql
malloy
-
Logica – declarative logic programming language for data
There's also Malloy[0] from Google that compiles into SQL
> Malloy is an experimental language for describing data relationships and transformations.
[0]: https://github.com/malloydata/malloy
-
Codd almighty! Has it been half a century of SQL already?
> SQL is great at expressing simple needs very well, but in more advanced cases, it can get "mind-twistingly complicated" even for a mathematically included brain.
I have found Malloy[1] to be easier to read and write, even for really complex queries. Malloy complies to SQL. As an example check out [2].
Malloy can query .csv files directly (enabled by duckdb). You can also join .csv files. This makes getting started a breeze for beginners, and is a boon for data scientists. Much easier than Pandas in many cases.
With the visualization capabilities it has built in, Malloy sort-of competes with Tableau and PowerBI.
Most people only write SQL to get data out of databases, for these people, Malloy is an interesting tool to consider.
[1] https://www.malloydata.dev/
- Malloy: A language for describing data relationships and transformations
- Malloy: Open-source language for analyzing, transforming, and modeling data
- Malloy
-
Upcoming Data Engineering Tools
Rust and python combination has resulted in some amazing python libraries. One interesting thing I see is people developing different variety of query languages like EdgeQL and Malloy
- Malloy: An Experimental Language for Data
-
I don't need your query language
I felt the same way when Malloy[0] launched. It has some interesting features, but I couldn't see myself ever using it. Nothing makes a big enough difference to spend the time to learn it.
Would love to hear from anybody that's using it regularly
0 - https://www.malloydata.dev/
What are some alternatives?
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
PyPika - PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
logica - Logica is a logic programming language that compiles to SQL. It runs on DuckDB, Google BigQuery, PostgreSQL and SQLite.
rel8 - Hey! Hey! Can u rel8?
rfcs - RFCs for major changes to EdgeDB
prosto - Prosto is a data processing toolkit radically changing how data is processed by heavily relying on functions and operations with functions - an alternative to map-reduce and join-groupby
partiql-lang-kotlin - PartiQL libraries and tools in Kotlin.
spyql - Query data on the command line with SQL-like SELECTs powered by Python expressions
db-benchmark - reproducible benchmark of database-like ops
xsuspender - :eyes: :computer: :zzz: :battery: Save battery by auto-suspending unfocused X11 applications.