SapphireDb 2.1.1

.NET Core 3.1 This package targets .NET Core 3.1. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package SapphireDb --version 2.1.1                

                    
                

            
NuGet\Install-Package SapphireDb -Version 2.1.1
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="SapphireDb" Version="2.1.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add SapphireDb --version 2.1.1                

                    
                

            
#r "nuget: SapphireDb, 2.1.1"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install SapphireDb as a Cake Addin
#addin nuget:?package=SapphireDb&version=2.1.1

// Install SapphireDb as a Cake Tool
#tool nuget:?package=SapphireDb&version=2.1.1

SapphireDb - Server for Asp.Net Core Build Status

SapphireDb is a self-hosted, easy to use realtime database for Asp.Net Core and EF Core.

It creates a generic API you can easily use with different clients to effortlessly create applications with realtime data synchronization. SapphireDb should serve as a self hosted alternative to firebase realtime database and firestore on top of .Net.

Check out the documentation for more details: Documentation

Features

  • 🔧 Dead simple configuration
  • 📡 Broad technology support
  • 💻 Self hosted
  • 📱 Offline support
  • 💾 Easy to use CRUD operations
  • ⚡ Model validation
  • ✔️ Database support
  • 📂 Supports joins/includes
  • ➿ Complex server evaluated queries
  • 🔌 Actions
  • 🔑 Authorization included
  • ✉️ Messaging
  • 🌐 Scalable

Learn more

Installation

Install package

To install the package execute the following command in your package manager console

PM> Install-Package SapphireDb

You can also install the extension using Nuget package manager. The project can be found here: https://www.nuget.org/packages/SapphireDb/

Configure DbContext

You now have to change your DbContext to derive from SapphireDbContext. Also make sure to adjust the constructor parameters.

// Change DbContext to SapphireDbContext
public class MyDbContext : SapphireDbContext
{
  //Add SapphireDatabaseNotifier for DI
  public MyDbContext(DbContextOptions<MyDbContext> options, SapphireDatabaseNotifier notifier) : base(options, notifier)
  {

  }

  public DbSet<User> Users { get; set; }

  public DbSet<Test> Tests { get; set; }
}

Register services and update pipeline

To use the SapphireDb you also have to make some changes in your Startup.cs-File.

public class Startup
{
  public void ConfigureServices(IServiceCollection services)
  {
    //Register services
    services.AddSapphireDb(...)
      .AddContext<MyDbContext>(cfg => ...);
  }

  public void Configure(IApplicationBuilder app)
  {
    //Add Middleware
    app.UseSapphireDb();
  }
}

Examples

Server

AspNet Core Example

Client

React Example

Svelte Example

NodeJs Example

Angular Example

Documentation

Check out the documentation for more details: Documentation

Implementations

Server

SapphireDb - Server for Asp.Net Core

Client

sapphiredb - JS client (JS, NodeJs, React, Svelte, ...)

ng-sapphiredb - Angular client

Author

Morris Janatzek (morrisjdev)

Licenses

SapphireDb - MIT License

sapphiredb-js - MIT License

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp3.1 is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on SapphireDb:

Package Downloads
SapphireDb.RedisSync

Redis sync module for SapphireDb
SapphireDb.HttpSync

Http sync module for SapphireDb

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.1.8-alpha 993 6/16/2021
3.1.7-alpha 976 3/10/2021
3.1.6-alpha 948 3/9/2021
3.1.5-alpha 1,063 10/26/2020
3.1.4-alpha 1,067 10/26/2020
3.1.3-alpha 991 10/26/2020
3.1.2-alpha 1,018 10/26/2020
3.1.1-alpha 1,120 8/2/2020
3.1.0-alpha 1,002 8/2/2020
3.0.0 19,538 7/25/2020
2.2.1 1,122 7/22/2020
2.2.0 1,822 6/20/2020
2.1.3 1,165 4/4/2020
2.1.2 1,212 4/3/2020
2.1.1 1,161 3/24/2020
2.1.0 1,363 3/21/2020
2.0.0 1,149 2/24/2020
1.5.0 1,171 2/18/2020
1.4.0 1,220 2/8/2020
1.3.0 1,160 1/21/2020
1.2.0 1,171 1/15/2020
1.1.6 1,123 1/13/2020
1.1.5 1,220 1/7/2020
1.1.4 1,196 1/7/2020
1.1.3 1,143 1/6/2020
1.1.1 1,221 1/4/2020
1.1.0 1,260 1/3/2020
1.0.7 1,195 1/2/2020
1.0.6 1,231 12/27/2019
1.0.5 1,143 12/22/2019
1.0.4 1,178 12/18/2019
1.0.3 1,134 12/9/2019
1.0.2 1,039 12/8/2019
1.0.1 1,099 12/8/2019
1.0.0 1,140 12/4/2019