57 lines (41 loc) · 1.62 KB

Features

Schema-Driven Development

Define Once, Use Everywhere

# schema.graphql - Your single source of truth
type User {
  id: ID!
  name: String!
  email: String!
  posts: [Post]
}

✅ Automatic table creation from GraphQL types
✅ Relationship detection (posts: [Post] → foreign key + metadata)
✅ Type validation at insert time
✅ Zero boilerplate - no C# table definitions needed

GraphQL Support

Full GraphQL Implementation

✅ Queries: Field selection, arguments, aliases
✅ Mutations: Create, update, delete operations
✅ Relationships: Automatic resolution with foreign keys
✅ Introspection: __schema and __type queries
✅ Error handling: GraphQL-compliant error responses

Storage Engine

High-Performance Embedded Database

✅ Page-based storage: 4KB pages with efficient I/O
✅ MemTable buffer: 16MB write buffer for fast inserts
✅ Binary serialization: MessagePack for compact storage
✅ Memory management: ArrayPool and Span for zero-copy I/O

Indexing System

Multiple Index Types

✅ Hash indexes: O(1) primary key lookups
✅ B-tree indexes: Range queries and sorted scans
✅ Automatic indexing: Primary keys indexed automatically
✅ Multi-column support: Create indexes on any column

Performance Optimizations

Prototype-Level Performance

✅ LRU page cache: Reduces disk I/O by 70-90%
✅ Batch loading: Eliminates N+1 query problems
✅ Zero-allocation lexer: ref struct tokenization
✅ Lock-free reads: Minimized contention