LiteDB — 轻量级NoSQL嵌入式数据库

## LiteDB - A .NET NoSQL Document Store in a single data file <p>LiteDB is a small, fast and lightweight NoSQL embedded database.</p> - Serverless NoSQL Document Store - Simple API similar to MongoDB - 100% C# code for .NET 3.5 / .NET 4.0 / NETStandard 1.3 / NETStandard 2.0 in a single DLL (less than 300kb) - Thread safe and process safe - ACID in document/operation level - Data recovery after write failure (journal mode) - Datafile encryption using DES (AES) cryptography - Map your POCO classes to <code>BsonDocument</code> using attributes or fluent mapper API - Store files and stream data (like GridFS in MongoDB) - Single data file storage (like SQLite) - Index document fields for fast search (up to 16 indexes per collection) - LINQ support for queries - Shell command line - try this online version - Pretty fast - compare results with SQLite here - Open source and free for everyone - including commercial use - Install from NuGet: <code>Install-Package LiteDB</code> <h2>New in 4.0</h2> - New <code>Expressions/Path</code> index/query support. See Expressions - Nested <code>Include</code> support - Optimzed query execution (with explain plain debug) - Fix concurrency problems - Remove transaction and auto index creation - Support for full scan search and LINQ search - New shell commands: update fields based on expressions and select/transform documents - See full changelog <h2>Try online</h2> <p><a rel="nofollow">Try LiteDB Web Shell</a>. For security reasons, in the online version not all commands are available. Try the offline version for full feature tests.</p> <h2>Documentation</h2> <p>Visit <a>the Wiki</a> for full documentation. For simplified chinese version, <a>check here</a>.</p> <h2>Download</h2> <p>Download the source code or binary only in <a>LiteDB Releases</a></p> <h2>How to use LiteDB</h2> <p>A quick example for storing and searching documents:</p> ```java // Create your POCO class public class Customer { public int Id { get; set; } public string Name { get; set; } public int Age { get; set; } public string[] Phones { get; set; } public bool IsActive { get; set; } } // Open database (or create if doesn't exist) using(var db = new LiteDatabase(@"MyData.db")) { // Get customer collection var col = db.GetCollection<Customer>("customers"); // Create your new customer instance var customer = new Customer { Name = "John Doe", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }; // Create unique index in Name field col.EnsureIndex(x => x.Name, true); // Insert new customer document (Id will be auto-incremented) col.Insert(customer); // Update a document inside a collection customer.Name = "Joana Doe"; col.Update(customer); // Use LINQ to query documents (with no index) var results = col.Find(x => x.Age > 20); } ``` Using fluent mapper and cross document reference for more complex data models ```java // DbRef to cross references public class Order { public ObjectId Id { get; set; } public DateTime OrderDate { get; set; } public Address ShippingAddress { get; set; } public Customer Customer { get; set; } public List<Product> Products { get; set; } } // Re-use mapper from global instance var mapper = BsonMapper.Global; // "Produts" and "Customer" are from other collections (not embedded document) mapper.Entity<Order>() .DbRef(x => x.Customer, "customers") // 1 to 1/0 reference .DbRef(x => x.Products, "products") // 1 to Many reference .Field(x => x.ShippingAddress, "addr"); // Embedded sub document using(var db = new LiteDatabase("MyOrderDatafile.db")) { var orders = db.GetCollection<Order>("orders"); // When query Order, includes references var query = orders .Include(x => x.Customer) .Include(x => x.Products) // 1 to many reference .Find(x => x.OrderDate <= DateTime.Now); // Each instance of Order will load Customer/Products references foreach(var order in query) { var name = order.Customer.Name; ... } } ``` <h2>Where to use?</h2> - Desktop/local small applications - Application file format - Small web applications - One database per account/user data store - Few concurrent write operations <h2>Plugins</h2> - A GUI viewer tool: https://github.com/falahati/LiteDBViewer - A GUI editor tool: https://github.com/JosefNemec/LiteDbExplorer - Lucene.NET directory: https://github.com/sheryever/LiteDBDirectory - LINQPad support: https://github.com/adospace/litedbpad - F# Support: https://github.com/Zaid-Ajaj/LiteDB.FSharp ## Changelog Change details for each release are documented in the release notes. ## License MIT Copyright (c) 2017 - Maurício David ## Thanks A special thanks to @negue and @szurgot helping with portable version and @lidanger for simplified chinese translation.