Npgsql.FSharp
Dapper.FSharp
Our great sponsors
| Npgsql.FSharp | Dapper.FSharp | |
|---|---|---|
| 7 | 7 | |
| 308 | 361 | |
| - | - | |
| 1.8 | 4.8 | |
| 4 days ago | about 1 month ago | |
| F# | F# | |
| MIT License | 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.
Npgsql.FSharp
-
Idiomatic way to interact with database
When working with F#, my database layer code has always seemed ugly. It feels like functional languages don't pair well with storage. I've used F# with Dapper, EF, and Npgsql.FSharp. Although Npgsql.FSharp works well, I would still like to use something like EF since it handles inserts and updates so well.
-
Best practices F# API?
Not a big fan of ORMs in general, I've been using https://github.com/Zaid-Ajaj/Npgsql.FSharp for postgres.
- Data Access in Fsharp
-
Best resources for learning F# to write boring apps?
On Postgres, there's a decent low ceremony option by Zaid Ajaj: https://github.com/Zaid-Ajaj/Npgsql.FSharp
-
Recommended libraries / frameworks for web services
For database, I use PostgreSQL with https://github.com/Zaid-Ajaj/Npgsql.FSharp and I like it very much. Writing the services, I do hide database operations behind interfaces like
-
Making Http Requests in F#
Npgsql.FSharp
Dapper.FSharp
-
No pure fsharp orm?
What about Dapper.FSharp?
- Idiomatic way to interact with database
-
Warning FS0101: This API supports the FSharp.Data.SqlClient...
Dapper FSharp is quite popular and worth checking out.
-
Is there a market for a complete fsharp ORM library?
I have been looking for frameworks to work with databases in f# and found some reasonable. My favorite so far is Dapper.FSharp. It's a very nice CRUD helper. I looked for some 'fsharp helper' for EF and found EFCore.FSharp which does not support discriminated unions unfortunately and does not go very far. I was intrigued by Litedb.FSharp but I would like to stick with sql databases.
-
If you were to create a Web API today from scratch how would you do it ?
Database: SQL or Event Store. If SQL, One of https://fsprojects.github.io/SQLProvider/, https://github.com/Dzoukr/Dapper.FSharp or https://github.com/SQLStreamStore/SQLStreamStore
- Best practices F# API?
-
Data Access in Fsharp
They are slightly different and depending on your background one might feel more confortable than the other Feel free to choose the one you like the best, in my case I will continue the rest of the post with the Expression based one given that we already have some expression based code from Dapper.FSharp. Previously we added some authors, let'ts try to add Posts to those authors with Donald.
What are some alternatives?
SqlHydra - SqlHydra is a suite of NuGet packages for working with databases in F# including code generation tools and query expressions.
Thoth.Json.Net
Rezoom.SQL - Statically typechecks a common SQL dialect and translates it to various RDBMS backends
FSharp.Data.Npgsql - F# type providers to support statically typed access to input parameters and result set of sql statement in idiomatic F# way. Data modifications via statically typed tables.
Donald - A lightweight, generic F# database abstraction.
FSharp.SystemTextJson - System.Text.Json extensions for F# types
Npgsql.FSharp.Analyzer - F# analyzer that provides embedded SQL syntax analysis, type-checking for parameters and result sets and nullable column detection when writing queries using Npgsql.FSharp.
ply - High performance System.Threading.(Value)Task computation expressions for F#
VisualFSharp - The F# compiler, F# core library, F# language service, and F# tooling integration for Visual Studio
Falco - A toolkit for building fast and functional-first web applications using F#.
Giraffe - A native functional ASP.NET Core web framework for F# developers.