# LiteDB

**Repository Path**: AITechInfo/LiteDB

## Basic Information

- **Project Name**: LiteDB
- **Description**: LiteDB is a small, fast and lightweight .NET NoSQL embedded database.
Serverless NoSQL Document Store
Simple API, similar to MongoDB...
- **Primary Language**: C#
- **License**: MIT
- **Default Branch**: Query_Tests
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-06-03
- **Last Updated**: 2025-06-03

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# LiteDB

This branch is current development of new version of LiteDB v6.

# Next steps
- IntoPipe
- Distinct Pipe
- Virtual collections (IDocumentStore): $master, $pragmas, $file_json, ...


# Needs implementation

## Engine

## Operations
- Update
- Batch
- Rebuild
- Vaccum? (maybe later)
- Extensions in ILiteEngine (insert/update/....)
- Recovery report (expose in $recovery)


## Query Engine
- Create IQuery and split Query in Query/GroupByQuery
- IntoPipe
- Distinct Pipe
- Virtual collections (IDocumentStore): $master, $pragmas, $file_json, ...

## Services
- CRC32
- AES - XTS Review
- ErrorHandling review
- try/catch/deallocate
- Auto-Rebuid, Flag error
- CancelationToken 

## Exception
- Normalize all exception using ERR_xxx

## BsonExpressions
- MakeDocument spread: { ...$ }
- MakeArray spread: [ ...phones ]
- CoalesceExpression:  a ?? 5 
- ANY: array ANY >= 8 // retorna TRUE se algum item de left (um array) satisfizer a operação com right (single::)

## Tokenizer
- Write a single tokenizer
   


## BsonValue
- DateTimeOffset

## LiteDatabase
- BsonMapper
- LiteCollection, LiteQuery, ...
- LiteStorage

## LiteDB.TestSuite

## SharedMode

## Performance
- Test use of `ref` in pipe context on movenext
- Create extenstion methods for linq
    - from _store.GetIndexes().FirstOrDefault(x => x.Expression == predicate.Left);
    - to _store.GetIndexes().FirstOrDefaultByExpression(predicate.Left);


## Performance boost (future)
- Read stream in extend size 64kb
- Async queue writer
- BsonDocumentReader
- BsonDocumentWriter
- Sort using unsafe (without BsonValue)
- [BsonDocumentGenerate] - map POCO class to BsonDocument and vice-versa
- Transaction MultiThread - a single bulk operation can use multiple threads (using `Parallel`)

## Documentation
- Define docs structure using a menu tree navigation and a single template


# Future
- Remove Reflection/Expressions to run over native x64

## Query Join
- DataStore Alias to support SELECT p._id FROM products p
- JoinPipeEnumerator (DataStore, PathExpression, Inner/Left)
- Link over _id only
```SQL
SELECT c, p
  FROM customers c
 INNER JOIN products p ON c.id_customer (always use products PK to link)
```
- Convert PipeValue in List<(DataStore, PipeValue)> in enumerators
- JoinDataStore - use only _id as key
- JoinPipeEnumerator keeps IndexNode and navigate in "continue mode"

## SubQuery
- Used in FROM (....)
- Used in SELECT (...) AS col
- Used in WHERE _id IN (...)