esqueleto
Sqinn-Go
Our great sponsors
esqueleto | Sqinn-Go | |
---|---|---|
5 | 8 | |
177 | 395 | |
0.0% | - | |
0.0 | 5.5 | |
over 7 years ago | 3 months ago | |
Haskell | Go | |
BSD 3-clause "New" or "Revised" License | The Unlicense |
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.
-
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).
-
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.
Sqinn-Go
-
Show HN: My Go SQLite driver did poorly on a benchmark, so I fixed it
Note that Squinn is not "native go" or "go only", but the owner insists on misleading people:
- Show HN: Sqinn-Go is a Golang library for accessing SQLite databases in pure Go
- SQLite in Go, with and Without Cgo
-
SQLite in Go, with and without cgo
If you want to avoid cgo, consider sqinn as well: benchmarks.
-
A remote JSON interface for SQLite, in Go
Of course, it may seem... odd to add a remote interface to an embedded database, but I think that it fits some niches well, especially when decoupling persistence and logic is needed, without renouncing to the expressivity of SQL. It was inspired by PostgREST, but it’s much more “low level” – and it should be even simpler to adapt to some cases. Also, it serves the same purpose of sqinn but with a more general interface.
-
Go performance from version 1.2 to 1.18
Why don't you try a pure-Go implementation? Should have enough features implemented for basic use
What are some alternatives?
go-sqlite3 - sqlite3 driver for go using database/sql
opaleye
yxdb-utils - Utilities for parsing Alteryx Database format
sqlx - general purpose extensions to golang's database/sql
vertica-sql-go - Official native Go client for the Vertica Analytics Database.
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
hocilib - A lightweight Haskell binding to the OCILIB C API
beam - A type-safe, non-TH Haskell SQL library and ORM
go-mssqldb - Microsoft SQL server driver written in go language
godror - GO DRiver for ORacle DB
mysql-simple - A mid-level client library for the MySQL database, intended to be fast and easy to use.
go-sql-driver/mysql - Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package