Our great sponsors
| Preql | jrutil | |
|---|---|---|
| 16 | 2 | |
| 594 | - | |
| - | - | |
| 0.0 | - | |
| over 1 year ago | - | |
| Python | ||
| 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.
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
jrutil
- Soustrast se všemi kdo jedou domů vlakem
-
Against SQL
I've also tried to rewrite some of my challenging queries [0] in my hypothetical syntax and while I think your observation about pipeline length is correct, the result still came out much better than SQL. Frankly, even in F#, most of my pipelines are around 5 functions too. In my view, pipelines are just a convenient mental model. I'd love to see your sketches, here are my (very WIP) concepts: [1]
[0]: for example this monstrosity: https://gitlab.com/dvdkon/jrutil/-/blob/dbb971c18526e68dcc97...
What are some alternatives?
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
opaleye
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.
fquery - A graph query engine
rel8 - Hey! Hey! Can u rel8?
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
malloy - Malloy is an experimental language for describing data relationships and transformations.
db-benchmark - reproducible benchmark of database-like ops
PostgreSQL - Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
spyql - Query data on the command line with SQL-like SELECTs powered by Python expressions
cupscript - CupScript Is A Simple Scripting Language Completely Created Using Python