Dapper.FSharp
SQLStreamStore
Our great sponsors
| Dapper.FSharp | SQLStreamStore | |
|---|---|---|
| 7 | 4 | |
| 361 | 468 | |
| - | -0.4% | |
| 4.8 | 0.0 | |
| about 1 month ago | 5 months ago | |
| F# | C# | |
| 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.
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.
SQLStreamStore
-
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
- Activity Log
-
Event Sourcing library
If you are using a relational database, and need pub sub, I would take a look at https://github.com/SQLStreamStore/SQLStreamStore. It supports MSSQL, MySQL, Postgres, and sqlite.
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.
SqlKata Query Builder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Npgsql.FSharp - Thin F# wrapper around Npgsql, the PostgreSQL database driver for .NET
Audit.NET - An extensible framework to audit executing operations in .NET and .NET Core.
Rezoom.SQL - Statically typechecks a common SQL dialect and translates it to various RDBMS backends
Event Store - EventStoreDB, the event-native database. Designed for Event Sourcing, Event-Driven, and Microservices architectures
Donald - A lightweight, generic F# database abstraction.
NEventStore - A persistence agnostic Event Store for .NET
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.
Transacto
VisualFSharp - The F# compiler, F# core library, F# language service, and F# tooling integration for Visual Studio
CQRSlite - A lightweight framework to help creating CQRS and Eventsourcing applications in C#