esqueleto
sqlx
esqueleto | sqlx | |
---|---|---|
5 | 145 | |
177 | 11,892 | |
0.0% | 3.0% | |
0.0 | 9.2 | |
over 7 years ago | 8 days ago | |
Haskell | Rust | |
BSD 3-clause "New" or "Revised" 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.
esqueleto
-
Revisiting Haskell after 10 years
Writing Haskell programs that rely on third-party packages is still an issue when itâs a not actively maintained package. They get out of date with the base library (Haskellâs standard library), and you might see yourself in a situation where you need to downgrade to an older version. This is not exclusive to Haskell, but it happens more often than Iâd like to assume. However, if you only rely on known well-maintained libraries/frameworks such as Aeson, Squeleto, Yesod, and Parsec, to name a few, itâs unlikely you will face troubles at all, you just need to be more mindful of what you add as a dependency. Thereâs stackage.org now, a repository that works with Stack, providing a set of packages that are proven to work well together and help us to have reproducible builds in a more manageable wayânot the solution for all the cases but itâs good to have it as an option.
-
How to use PostgreSQL with Haskell: persistent + esqueleto
However, we can use Esqueleto (âa bare bones, type-safe EDSL for SQL queriesâ) with Persistent's serialization to write type-safe SQL queries. Itâs unlikely that you want to use Persistent by itself with SQL, so letâs use and review them together.
-
What databases do you find the most productive to connect to Haskell?
Postgresql-simple is a great library, it makes a nice use of overloaded strings to do the job. Some other nice libraries to keep an eye on are opaleye (postgres specific, which is equally nice but could be a bit difficult to get why the types are so big) and a combination of persistent (not DB specific! can work on postgres, sqlite, but also noSQL DBs like mongo, it's still easy to learn but you lose some things, such as joins due to the power of being agnostic) + esqueleto for type safe joins (be sure to look up the experimental package, it's a more comfortable syntax that will soon become the default one).
-
Notes on Luca Palmieri's Zero to Production in Rust
Using esqueleto in one of my haskell projects was a huge time sink and a major barrier to entry for colleagues.
-
Go performance from version 1.2 to 1.18
In Haskell: https://hackage.haskell.org/package/esqueleto
Either it analyzes the given SQL to determine the in/out types of each SQL query, or it calls the database describe feature at compile-time.
sqlx
-
A tale of TimescaleDB, SQLx and testing in Rust
For PostgreSQL, the most relevent part of the code is here. With this in mind I changed some things around to rely on schemas instead of databases and even simplified some parts of the implementation as this was always meant to be for internal use only..
-
Rust as a general application language
What exactly are you missing? I haven't really written "boring corporate backend stuff" in a few years but something like sqlx provides everything I've ever needed there.
-
Hey Rustaceans! Got a question? Ask here (49/2023)!
Badges are the little rectangles you typically see at the top of a crate's README: https://github.com/launchbadge/sqlx/blob/main/README.md
-
A new F# compiler feature: graph-based type-checking
SQLX has entered the chat [1].
[1] https://github.com/launchbadge/sqlx
-
Grimoire - A recipe management application.
Database : SqLite (using sqlx).
-
SQLX MSSQL Connection String Problem
The current (well, removed) MSSQL sqlx driver also doesn't support encrypted connections (https://github.com/launchbadge/sqlx/issues/1552), so it might work locally on an unnamed instance but not over the network until they add in the newer driver (which will be closed source but for an OSS project you should be able to request a free license I think)
-
Introducing SQLPage : write websites entirely in SQL
I'm considering making my own wrapper over lower-level database drivers. There are a lot of features in sqlx that I don't need, and the latest version seems to have removed useful data structures that SQLPage is using. It also removed support for SQL Server.
- SQLx 0.7 released! Offline mode usability improvements, performance fixes and major upgrades across the board!
- Is ORM still an anti-pattern?
-
MariaDB / SQLx - "Unknown Authentication Plugin"
add Ed25519 to AuthPlugin enum on https://github.com/launchbadge/sqlx/blob/061fdcabd72896d9bc3abb4ea4af6712a04bc0a8/sqlx-core/src/mysql/connection/auth.rs and implement them using these crates:
What are some alternatives?
opaleye
diesel - A safe, extensible ORM and Query Builder for Rust
yxdb-utils - Utilities for parsing Alteryx Database format
sea-orm - đ An async & dynamic ORM for Rust
groundhog - This library maps datatypes to a relational model, in a way similar to what ORM libraries do in OOP. See the tutorial https://www.schoolofhaskell.com/user/lykahb/groundhog for introduction
tokio - A runtime for writing reliable asynchronous applications with Rust. Provides I/O, networking, scheduling, timers, ...
hocilib - A lightweight Haskell binding to the OCILIB C API
rust-postgres - Native PostgreSQL driver for the Rust programming language
beam - A type-safe, non-TH Haskell SQL library and ORM
rbatis - Rust Compile Time ORM robustness,async, pure Rust Dynamic SQL
mysql-simple - A mid-level client library for the MySQL database, intended to be fast and easy to use.
actix-web - Actix Web is a powerful, pragmatic, and extremely fast web framework for Rust.