Tencent/wcdb
Wcdb
WCDB is a cross-platform storage layer and embedded database engine that serves as a framework for SQLite. It functions as an object relational mapper, linking application classes to database tables to enable data operations via objects rather than raw queries.
The project is distinguished by an integrated encryption layer for securing data at rest and a full-text search engine that uses language-specific tokenizers for text lookups. It also features transparent field compression to reduce storage footprints and a connection-pooling model to coordinate simultaneous read and write operations across multiple threads.
The system provides comprehensive data management capabilities, including schema synchronization, automatic migrations, and built-in data recovery tools for repairing damaged database files. It further implements type-safe query generation to prevent injection attacks and maintains a compatibility layer for legacy database code.
Features
- Cross-Platform Storage Frameworks - Serves as a cross-platform storage framework providing consistent API and storage behavior across multiple operating systems.
- Object-Relational Mapping - Functions as an object-relational mapper linking application classes to database tables for object-based data operations.
- SQLite Databases - Utilizes a relational SQLite engine to handle low-level disk I/O and atomic transactions for persistence.
- Record Management Interfaces - Provides standard create, read, update, and delete operations for managing database records and tables.
- Embedded Database Engines - Functions as an embedded database engine integrated directly into the application process.
- Full Text Search - Indexes and searches text content across multiple languages using integrated tokenizers.
- Full-Text Search Engines - Includes a full-text search engine with language-specific tokenizers for efficient text retrieval across large datasets.
- Object-Relational Mappers - Simplifies database interactions by mapping application classes to SQLite tables.
- Storage Encryption - Provides an integrated encryption layer that secures the database file at rest to prevent unauthorized access.
- Connection Pools - Implements a connection pooling mechanism to coordinate simultaneous read and write operations across multiple threads.
- Transparent Field Compression - Intercepts data access to automatically compress and decompress specific table columns to reduce storage footprint.
- Database Migrations - Allows transferring data between different databases via configuration without manual migration tracking.
- Mobile Storage Engines - Manages local storage on mobile devices with specialized features like schema synchronization and data recovery.
- Database Schema Migrations - Automatically updates the database table structure at runtime by comparing current fields with bound class definitions.
- Connection Pooling - Coordinates simultaneous read and write operations across multiple threads using a connection-pooling model.
- Native Language Querying - Executes database queries and filters using native language integration to eliminate raw string concatenation.
- Schema Synchronizers - Automatically aligns database fields to remain consistent with changes made to bound class definitions.
- Transparent Column Compression - Reduces storage footprints by automatically compressing and decompressing specific table fields.
- Type-Safe Query Builders - Translates native language expressions into SQL queries to ensure type safety and prevent injection attacks.
- Encrypted Database Managers - Secures data at rest using an integrated encryption layer to prevent unauthorized access to the database file.
- SQL Injection Prevention - Prevents SQL injection attacks by using type-safe query generation instead of raw string concatenation.
- Thread-Safe Database Access - Handles multiple simultaneous read and write operations through connection pooling to optimize multi-threaded performance.
- Database Libraries - Efficient mobile database framework for Apple platforms.
- Databases and Storage - Efficient and secure mobile database framework for SQLCipher.
