potygen
postgresql-typed
potygen | postgresql-typed | |
---|---|---|
2 | 2 | |
- | 83 | |
- | - | |
- | 4.9 | |
- | 2 months ago | |
Haskell | ||
- | 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.
potygen
- Kysely: TypeScript SQL Query Builder
-
Objection to ORM Hatred
I really hope the community converges on just one common solution to this as I see soo many different approaches to the same “there’s no great modular ORM for typescript” problem.
I myself went the route of “lets just have raw sql queries” but extract distinct and specific types from them automatically- https://github.com/potygen/potygen
Great thing is that it handles sql of any complexity - CTEs, views, nested selects/joins/unions/custom functions you name it. All tools you can use to encapsulate logic in sql itself (what ORM were supposed to be for) and then have it be statically validated at compile time thus saving you the need for righting all those trivial unit tests that was also one of the key benefits of ORMs.
Admittedly if there was something like LINQ I would probably not have ventured into building potygen, but I’m glad I did as I learned so much about SQL as a language and what it had to offer - its silly how much logic I used to rely on writing in code that could easily be handled by sql in a much mode concise way.
postgresql-typed
- Kysely: TypeScript SQL Query Builder
-
What databases do you find the most productive to connect to Haskell?
If you need Cassandra specifically, cql-io is pretty good. For a general purpose database I'd go with Postgres. There are many good choices in the Haskell ecosystem, but I really like postgres-typed. It lets you write plain SQL, checks you queries against a live database schema at compile time, and makes sure you use the results correctly as well. It's amazing, I never ran into type related errors and it's pretty seamless.
What are some alternatives?
kanel - Generate Typescript types from Postgres
postgresql-transactional - Transactional monadic actions on top of PostgreSQL.
postgresql-tx - [Moved to: https://github.com/Simspace/postgresql-tx]
postgresql-simple-opts - An optparse-applicative parser for postgresql-simple's connection options
postgresql-simple-named - :question: Implementation of named parameters for `postgresql-simple` library
cassandra-cql - Haskell client for Cassandra's CQL protocol
postgresql-syntax - PostgreSQL SQL syntax utilities
postgresql-schema - PostgreSQL Schema is a database migration tool.
postgresql-simple-migration - PostgreSQL Schema Migrations for Haskell
postgresql-simple-interpolate - Safe interpolated SQL queries in Haskell
postgresql-error-codes - PostgreSQL error codes
esqueleto - Bare bones, type-safe EDSL for SQL queries on persistent backends.