Announcing pGenie: Generate typesafe Haskell from plain SQL for Postgres

• demo-artifacts

  2 2 0.0 Java

  Artifacts generated from the "demo" project

  

Comparing https://github.com/pgenie-io/demo-artifacts/blob/main/haskell-hasql/library/PgenieArtifacts/MySpace/MusicCatalogue/Hasql/Sessions.hs to the schema at https://github.com/pgenie-io/demo/blob/master/migrations/1.sql, I feel like the generated types are more general than they ought to be? E.g. insertAlbum shouldn't allow Nothing for the name; and the return value should always be a single id (I assume a uniqueness violation will throw an error?), so a Fold seems awkward.

• postgrest

  100 22,342 9.7 Haskell

  REST API for any Postgres database

  

It must be mentioned that some applications do truly need dynamic statements. Typically such applications control the structure of the DB and change it dynamically too. One example is PostgREST. Most of applications deal with a statically structured database though and hence don't need dynamic statements.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• demo

  1 13 3.5

  Demonstration of pgenie (by pgenie-io)

  

Comparing https://github.com/pgenie-io/demo-artifacts/blob/main/haskell-hasql/library/PgenieArtifacts/MySpace/MusicCatalogue/Hasql/Sessions.hs to the schema at https://github.com/pgenie-io/demo/blob/master/migrations/1.sql, I feel like the generated types are more general than they ought to be? E.g. insertAlbum shouldn't allow Nothing for the name; and the return value should always be a single id (I assume a uniqueness violation will throw an error?), so a Fold seems awkward.

• cli

  2 6 3.2 Haskell

  Pgenie CLI application (by pgenie-io)

  

Suggest a related project