Haskell Relational Record Tutorials

Contents:

• Instant Gratification
  • Connecting to the PostgreSQL database
  • Your very first query
• Introduction
  • What is Haskell Relational Record?
  • What HRR is not
  • How does it work
• Basic DB mapping
  • Full example
  • Projections
  • TypeMap
• CRUD workflow in HRR
  • Select
  • Insert
  • Update
  • Delete
  • Where clauses
• Advanced DB mapping
  • date/time types
  • JSON(B) type
  • Enums
  • Arrays
• Advanced Workflow
  • DB-side constraints / data validation
  • Joins
  • Subqueries
  • Union, Coalesce
  • Case … when
  • Functions
  • Housekeeping
  • Fallback to HDBC
  • Bulk inserting / preparing statements
• Summary and Conclusion
  • Why and when you should use HRR in a live system
  • Drawbacks you might be in for
  • Integration