hasql-th
py-mysql-type-plugin
| hasql-th | py-mysql-type-plugin | |
|---|---|---|
| 4 | 2 | |
| 110 | 0 | |
| - | - | |
| 5.2 | 5.4 | |
| 5 months ago | 26 days ago | |
| Haskell | Python | |
| 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.
hasql-th
-
How to use PostgreSQL with Haskell: hasql
Hasql is an ecosystem of libraries. To keep it simple, let’s limit ourselves to core hasql, hasql-transaction, and hasql-th. We’re using hasql 1.6.3.2 published in 2023.
-
Parsing SQL
unexpected '&'
https://github.com/nikita-volkov/hasql-th#error-example-1
-
Open Source SQL Parsers
There is also a Haskell port of the original PostgreSQL parser, implemented using megaparsec, which makes it highly flexible and hackable: https://github.com/nikita-volkov/hasql-th#implementation
-
Haskell doesn't make sense without pure functions
I'd consider hasql-th a good example in what concerns databases. Otherwise, I just use aeson together with deriving-aeson and lens-aeson.
py-mysql-type-plugin
-
Python: Just Write SQL
It's fine advice - if you can type check your queries. My colleague wrote a mypy plugin for parsing SQL statements and doing type checking against a database schema file, which helps to identify typos and type errors early: https://github.com/antialize/py-mysql-type-plugin
- Parsing SQL
What are some alternatives?
Neks - A dead simple networked key/value store
pugsql - A HugSQL-inspired database library for Python
tokyocabinet-haskell - This repository will get archived soon. Please visit https://git.singpolyma.net/tokyocabinet-haskell
powderkeg - Live-coding the cluster!
hasql - The fastest PostgreSQL libpq-based driver for Haskell
yesql - A Clojure library for using SQL.
wai-middleware-cache-redis - Redis backend for wai-middleware-cache
mini_sql - a minimal, fast, safe sql executor
ampersand - Build database applications faster than anyone else, and keep your data pollution free as a bonus.
squiller - Generate boilerplate from annotated SQL queries
hasql-notifications - Use PostgreSQL LISTEN/NOTIFY with your Hasql Types
typed-sql