Friflo.Json.Fliox
A high-performance C# ORM for SQL and NoSQL databases with built-in messaging, pub-sub, and client-server architecture.
What is Friflo.Json.Fliox?
JSON Fliox is a C# ORM and client-server framework that provides unified access to SQL and NoSQL databases. It solves the problem of building performant, real-time web applications by combining database operations, messaging, and pub-sub in a single, type-safe API. It enables developers to work with multiple database backends while offering features like batching, transactions, and a built-in admin UI.
.NET developers building web applications, real-time systems, or services that require high-performance database access with messaging capabilities. It's also suitable for game developers using Unity who need a synchronized state and messaging layer.
Developers choose JSON Fliox for its unique combination of ORM, real-time messaging, and client-server architecture without vendor lock-in. Its performance (sub-millisecond pub-sub latency, high throughput) and ability to generate multiple client SDKs (C#, TypeScript, Kotlin) set it apart from traditional ORMs.
Overview
C# ORM - High Performance, SQL, NoSQL, Messaging, Pub-Sub
Use Cases
Best For
- Building real-time web applications with database synchronization
- Unifying access to mixed SQL and NoSQL database environments
- Developing .NET backends with integrated pub-sub messaging
- Creating admin dashboards with built-in database exploration
- Building multiplayer games requiring state synchronization and messaging
- Generating client SDKs in multiple languages from a single C# schema
Not Ideal For
- Projects that only need basic CRUD without real-time features, where simpler ORMs like Dapper or Entity Framework Core would suffice
- Teams deeply entrenched in Entity Framework Core with existing migrations, tooling, and community plugins
- Applications requiring support for niche or non-SQL NoSQL databases like MongoDB or Cassandra, as the focus is on SQL with JSON column storage
- Small, static websites or APIs where the overhead of setting up a client-server architecture and pub-sub is unnecessary
Pros & Cons
Pros
Supports both SQL (SQLite, PostgreSQL, MySQL, SQL Server) and NoSQL (in-memory, file-system) databases with a single API, including JSON column storage to avoid ORM impedance mismatch.
Provides sub-millisecond latency push notifications for database changes, with benchmarks showing 50k messages/sec throughput, enabling efficient real-time updates.
Includes Hub Explorer for browsing databases, executing commands, and monitoring, reducing the need for custom admin tools and speeding up development.
Automatically generates C#, TypeScript, and Kotlin clients from C# schemas, plus JSON Schema, OpenAPI, and GraphQL schemas, facilitating cross-platform development.
Cons
As a newer and unique ORM, it lacks the extensive third-party integrations, plugins, and community support available for established options like Entity Framework Core.
Requires configuring both client and server components even for basic applications, which can be overkill compared to lighter ORMs that handle database access directly.
Requires .NET Core 3.1 or higher or .NET Framework 4.6.2, which might not be compatible with older projects or environments stuck on legacy frameworks.
Open Source Alternative To
Friflo.Json.Fliox is an open-source alternative to the following products:
ServiceStack is a high-performance .NET web services framework that provides a simple, clean API for building REST, SOAP, and MQ services.
NHibernate is an object-relational mapping (ORM) solution for the .NET platform, providing a framework for mapping an object-oriented domain model to a traditional relational database.
Entity Framework Core is a lightweight, extensible, open-source version of Entity Framework for .NET Core and .NET 5+ applications.
Dapper is a micro-ORM (Object Relational Mapper) for .NET that provides high-performance data access with minimal overhead compared to full ORMs.
Frequently Asked Questions
Related Projects
DapperDapper - a simple object mapper for .Net
Entity Framework CoreEF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
SqlSugar.Net aot ORM SqlServer ORM Mongodb ORM MySql 瀚高 Postgresql ORM DB2 Hana 高斯 Duckdb C# VB.NET Sqlite ORM Oracle ORM Mysql Orm 虚谷数据库 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET9 ORM .NET8 ORM ClickHouse ORM QuestDb ,TDengine ORM,OceanBase ORM,GaussDB ORM,Tidb ORM Object/Relational Mapping
ServiceStack.OrmLiteThoughtfully architected, obscenely fast, thoroughly enjoyable web services for all
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.