rd-parse
pql
| rd-parse | pql | |
|---|---|---|
| 1 | 4 | |
| 102 | 647 | |
| 0.0% | 0.5% | |
| 0.0 | 7.3 | |
| almost 2 years ago | 2 months ago | |
| JavaScript | Go | |
| MIT License | 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.
rd-parse
-
Pql, a pipelined query language that compiles to SQL (written in Go)
I also wrote a parser (in typescript) for postgres (https://github.com/ivank/potygen), and it turned out quite the educational experience - Learned _a lot_ about the intricacies of SQL, and how to build parsers in general.
Turned out in webdev there are a lot of instances where you actually want a parser - legacy places where they used to save things in plane text for example, and I started seeing the pattern everywhere.
Where I would have reached for some monstrosity of a regex to solve this, now I just whip out a recursive decent parser and call it a day, takes surprisingly small amount of code! (https://github.com/dmaevsky/rd-parse)
pql
-
Google's New Pipe Syntax in SQL
I haven't seen it mentioned yet, but it reminds me of PQL (not PRQL): https://pql.dev
It's inspired by Kusto and available as an open-source CLI. I've made it compatible with SQLite in one of my tools, and it's refreshing to use.
An example:
StormEvents - FLaNK 04 March 2024
- Pql, a pipelined query language that compiles to SQL (written in Go)
- Pipelined Query Language
What are some alternatives?
Preql - An interpreted relational query language that compiles to SQL.
llm-rag-graph - Build relationship Graphs using LLM in a Retrieval-Augmented Generation(RAG) framework with pgvector as a vector database
tenzir - Tenzir is the data pipeline engine for security teams.
ingestr - ingestr is a CLI tool to copy data between any databases with a single command seamlessly.
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
petrol - Petrol's an OCaml SQL API made to go FAST.