sea-query
polars
Our great sponsors
sea-query | polars | |
---|---|---|
23 | 144 | |
1,012 | 26,218 | |
5.7% | 6.7% | |
9.1 | 10.0 | |
8 days ago | 2 days ago | |
Rust | Rust | |
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.
sea-query
-
Hey Rustaceans! Got a question? Ask here (8/2023)!
The main limitation of prepared statement is that you can only insert values, so you cannot dynamically construct the query depending on the parameters. For that, you can use a query builder such as sea-query, which should handle that.
-
Modern DB that works with sqlx?
I would say https://www.sea-ql.org is your best bet. Itβs highly configurable and they also have tools for no bs orm and graphql! Very new, but there is 1.0 release and tonnes of documentation and cook books.
-
What's new in SeaQuery 0.28.0
[#508] Representing a identifier with &'static str. The IdenStatic trait looks like this:
-
What's new in SeaQuery 0.27.0
π We are pleased to release SeaQuery 0.27.0! Here are some feature highlights π:
-
Using Rust as my Backend
SeaORM or SeaQuery are also very good instead of diesel/sqlx
- Sea-query: A dynamic SQL query builder for MySQL, Postgres and SQLite
- GitHub - SeaQL/sea-query: A dynamic SQL query builder for MySQL, Postgres and SQLite
-
Celebrating 3,000+ GitHub Stars π
SeaQL.org was founded back in 2020. We devoted ourselves into developing open source libraries that help Rust developers to build data intensive applications. In the past two years, we published and maintained four open source libraries: SeaQuery, SeaSchema, SeaORM and StarfishQL. Each library is designed to fill a niche in the Rust ecosystem, and they are made to play well with other Rust libraries.
-
What's new in SeaORM 0.9.0
Upgrade sea-query to 0.26
-
Introducing StarfishQL - visualizing the dependency network on crates.io
As the new member of the SeaQL family, it's a stellar example of what could be done with Rust and the SeaORM / SeaQuery / SeaSchema suite of tools. We couldn't be more excited to see applications being built on Rust and the SeaQL ecosystem!
polars
-
Why Python's Integer Division Floors (2010)
This is because 0.1 is in actuality the floating point value value 0.1000000000000000055511151231257827021181583404541015625, and thus 1 divided by it is ever so slightly smaller than 10. Nevertheless, fpround(1 / fpround(1 / 10)) = 10 exactly.
I found out about this recently because in Polars I defined a // b for floats to be (a / b).floor(), which does return 10 for this computation. Since Python's correctly-rounded division is rather expensive, I chose to stick to this (more context: https://github.com/pola-rs/polars/issues/14596#issuecomment-...).
-
Polars
https://github.com/pola-rs/polars/releases/tag/py-0.19.0
-
Stuff I Learned during Hanukkah of Data 2023
That turned out to be related to pola-rs/polars#11912, and this linked comment provided a deceptively simple solution - use PARSE_DECLTYPES when creating the connection:
- Polars 0.20 Released
- Segunda linguagem
- Polars: Dataframes powered by a multithreaded query engine, written in Rust
- Summing columns in remote Parquet files using DuckDB
- Polars 0.34 is released. (A query engine focussing on DataFrame front ends)
What are some alternatives?
sqlx - general purpose extensions to golang's database/sql
vaex - Out-of-Core hybrid Apache Arrow/NumPy DataFrame for Python, ML, visualization and exploration of big tabular data at a billion rows per second π
sea-orm - π An async & dynamic ORM for Rust
modin - Modin: Scale your Pandas workflows by changing a single line of code
rust-postgis - postgis helper library.
datafusion - Apache DataFusion SQL Query Engine
aws-sdk-rust - AWS SDK for the Rust Programming Language
DataFrames.jl - In-memory tabular data in Julia
datatable - A Python package for manipulating 2-dimensional tabular data structures
sqlx - π§° The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
Apache Arrow - Apache Arrow is a multi-language toolbox for accelerated data interchange and in-memory processing