SQLStreamStore
Dapper.FSharp
| SQLStreamStore | Dapper.FSharp | |
|---|---|---|
| 4 | 7 | |
| 468 | 361 | |
| -0.2% | - | |
| 0.0 | 4.8 | |
| 5 months ago | about 1 month ago | |
| C# | 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.
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.
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?
SqlKata Query Builder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
SqlHydra - SqlHydra is a suite of NuGet packages for working with databases in F# including code generation tools and query expressions.
Audit.NET - An extensible framework to audit executing operations in .NET and .NET Core.
Npgsql.FSharp - Thin F# wrapper around Npgsql, the PostgreSQL database driver for .NET
Event Store - EventStoreDB, the event-native database. Designed for Event Sourcing, Event-Driven, and Microservices architectures
Rezoom.SQL - Statically typechecks a common SQL dialect and translates it to various RDBMS backends
NEventStore - A persistence agnostic Event Store for .NET
Donald - A lightweight, generic F# database abstraction.
Transacto
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.
CQRSlite - A lightweight framework to help creating CQRS and Eventsourcing applications in C#
VisualFSharp - The F# compiler, F# core library, F# language service, and F# tooling integration for Visual Studio