ccgus/fmdb

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 Libraries - Objective-C wrapper for SQLite.

Star history