esqueleto
mysql-simple
esqueleto | mysql-simple | |
---|---|---|
5 | - | |
178 | 91 | |
0.0% | - | |
0.0 | 0.0 | |
about 8 years ago | 11 months ago | |
Haskell | Haskell | |
BSD 3-clause "New" or "Revised" License | BSD 3-clause "New" or "Revised" 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.
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.
mysql-simple
We haven't tracked posts mentioning mysql-simple yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
opaleye
database-migrate - database-migrate haskell library to assist with migration for *-simple sql backends.
yxdb-utils - Utilities for parsing Alteryx Database format
mysql-haskell - Pure haskell mysql driver
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
mysql - A lightweight Haskell binding to the C mysqlclient API
hocilib - A lightweight Haskell binding to the OCILIB C API
geoip2 - Pure haskell access to the MaxMind GeoIP2 database
beam - A type-safe, non-TH Haskell SQL library and ORM
HongoDB - A Simple Key Value Store
ampersand - Build database applications faster than anyone else, and keep your data pollution free as a bonus.