malloy
ibis
malloy | ibis | |
---|---|---|
19 | 23 | |
1,827 | 4,241 | |
1.4% | 6.5% | |
9.8 | 10.0 | |
10 days ago | 3 days ago | |
TypeScript | Python | |
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.
malloy
- 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/
-
When not to use SQL - Sean J Taylor
Sidenote: have you used Google Malloy? If so, what did you like/dislike?
ibis
-
Show HN: Hashquery, a Python library for defining reusable analysis
I really don't understand the appeal of dbt vs a proper programming language. The templating approach leads to massive spaghetti. I look forward to trying out something like Ibis [0]
0: https://ibis-project.org/
-
This Week In Python
ibis – portable Python dataframe library
- Ibis: The portable Python dataframe library
- FLaNK Stack 26 February 2024
-
Quarto
The main benefit is that you get a Python (or R, Julia or Rust) interpreter. So you can evaluate code. A good example of the value of this is the Ibis docs which use Quarto: https://ibis-project.org/
-
Polars – A bird's eye view of Polars
Ive found polars quite intuitive, though for python, I lean more towards [ibis](https://ibis-project.org/). The interface is nearly identical, but ibis has the benefit if building sql queries before pulling any actual data (like dbplyr) — whereas polars requires the data to be in-memory (at least for rdb’s, though correct me if Im wrong)
this to me seems like a good argument for only using ibis, but Im happy to be convinced otherwise
- Ibis – Universal Interface for Data Wrangling
-
Vanna.ai: Chat with your SQL database
Please add Ibis Birdbrain https://ibis-project.github.io/ibis-birdbrain/ to the list. Birdbrain is an AI-powered data bot, built on Ibis and Marvin, supporting more than 18 database backends.
See https://github.com/ibis-project/ibis and https://ibis-project.org for more details.
- Ibis
What are some alternatives?
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
snowflake-connector-python - Snowflake Connector for Python
logica - Logica is a logic programming language that compiles to SQL. It runs on Google BigQuery, PostgreSQL and SQLite.
PySpark-Boilerplate - A boilerplate for writing PySpark Jobs
Preql - An interpreted relational query language that compiles to SQL.
Apache Impala - Apache Impala
partiql-lang-kotlin - PartiQL libraries and tools in Kotlin.
pangres - SQL upsert using pandas DataFrames for PostgreSQL, SQlite and MySQL with extra features
rfcs - RFCs for major changes to EdgeDB
sqlite_scanner - DuckDB extension to read and write to SQLite databases
spyql - Query data on the command line with SQL-like SELECTs powered by Python expressions
katacoda