ccgus/fmdb
Fmdb
fmdb is an object-oriented SQLite database library and persistence layer for native macOS and iOS environments. It provides an Objective-C wrapper that encapsulates the low-level C API, allowing applications to manage local relational data storage and embedded database connections through a high-level interface.
The library focuses on thread-safe database access by synchronizing operations across multiple threads using serialized queues to prevent data corruption and race conditions. It includes specialized capabilities for secure local storage, such as database encryption and the management of encryption keys.
The project covers comprehensive database management, including atomic transaction handling with named save points, schema inspection, and SQL parameter binding to prevent injection. It also provides utilities for result set iteration, dictionary-based row mapping, and the implementation of full-text search using specialized tokenizers.
Features
- Embedded Databases - Provides a complete embedded database management system for native applications without requiring a separate server.
- SQLite Databases - Serves as a library for managing a serverless, transactional SQL database engine within macOS and iOS environments.
- Atomic Transactions - Implements ACID-compliant atomic transactions to ensure data consistency during multiple SQL operations.
- SQL Query Execution - Executes non-SELECT statements such as CREATE and DELETE and returns success or error indicators.
- Database Connections - Manages the lifecycle of connections to file-based, temporary, or in-memory SQLite databases.
- Database Query Execution - Executes SELECT statements and returns iterable result sets for record retrieval.
- Local Persistence Layers - Offers a persistence layer for storing application data and state in local file-based databases.
- SQLite Integration - Provides direct integration and high-level wrapping of SQLite for use in Objective-C and Cocoa applications.
- C-API Wrappers - Provides an Objective-C wrapper that encapsulates the low-level SQLite C API for simplified database interaction.
- SQLite Wrappers - Provides an object-oriented Objective-C interface that encapsulates the low-level SQLite C API.
- Cross-Thread Database Dispatchers - Synchronizes database operations across multiple threads using a serialized queue to ensure data integrity.
- Database Synchronization Wrappers - Provides a thread-safe interface that prevents race conditions during concurrent database access.
- Serialized Access - Coordinates concurrent database access through a serialized queue to prevent race conditions and data corruption.
- Thread-Safe Database Access - Synchronizes database operations across multiple threads using serialized queues to prevent data corruption.
- Column Value Extraction - Retrieves data from specific columns by index or name as strings, integers, or binary data.
- Row Mapping Logic - Transforms database records into dictionaries where column names serve as keys for retrieved values.
- Save Points - Provides named save points allowing the application to roll back a transaction to a specific internal state.
- Full Text Search - Enables advanced text indexing and keyword searching using specialized tokenizers for full-text search.
- Local Database Security - Implements security measures for local database files, including encryption and key management.
- Named Parameter Bindings - Uses placeholders to bind values into SQL statements, preventing injection and ensuring proper escaping.
- Prepared Statements - Utilizes parameterized SQL templates to prevent injection and optimize repeated query execution.
- Query Result Fetching - Provides functionality to advance through returned rows one by one for sequential processing.
- Result Streaming - Implements sequential result processing to minimize memory overhead when handling large datasets.
- Encrypted Database Managers - Provides a management interface for creating and maintaining encrypted SQLite database files.
- SQL Batching - Supports processing multiple semicolon-separated SQL statements in a single call for efficient execution.
- Data Persistence - Objective-C wrapper for SQLite database operations.
- Database Engines - Objective-C wrapper for SQLite.
- Database Libraries - Objective-C wrapper for SQLite.
