GRDB.swift

GRDB.swift is a comprehensive SQLite toolkit and object-relational mapper for Swift. It provides a database wrapper that handles local data persistence, connection management, and encrypted file storage for Apple platforms.

The library features a dedicated observation framework that tracks database changes to automatically synchronize the application state and user interface in real time. It distinguishes itself with a type-safe query builder and a protocol-based mapping system that converts database rows into structured Swift objects.

The toolkit covers a broad range of administrative and operational capabilities, including versioned schema migrations, record upserts, and the storage of complex types as JSON. It also includes utilities for database backups, memory reclamation, and the execution of raw SQL with bound arguments.

Features

Database Wrappers - Provides a comprehensive SQLite wrapper handling connection management, migrations, and encryption for Apple platforms.

Local Database Persistence - Provides a comprehensive SQLite toolkit for local data persistence on Apple platforms.

SQLite Databases - Provides a comprehensive toolkit for managing local data storage using the SQLite engine.

Database Schema Migrations - Automates the application of versioned schema migrations to keep the database compatible with the application model.

Row Mapping Logic - Uses a protocol-based mapping system to convert database rows into structured Swift objects.

Object-Relational Mappers - Provides a full ORM for Swift that maps database rows to structured objects with support for upserts.

Schema Migrations - Manages database versioning through a sequence of ordered migration scripts to evolve the schema.

SQLite Integration - Offers a complete toolkit for direct querying and management of SQLite database files.

Type-Safe Data Abstractions - Implements type-safe abstractions for mapping database rows to Swift objects and handling complex types.

Type-Safe Query Builders - Provides a type-safe query builder to construct SQL statements using structured Swift expressions.

SQLite Wrappers - Wraps the low-level SQLite C API in a Swift-native layer for safer connection and statement management.

Database-to-UI Synchronization - Observes database changes to automatically synchronize the application state and user interface in real time.

Database - Features a value-observation system that tracks database changes to automatically refresh the user interface.

Raw SQL Execution - Enables the execution of raw SQL statements using bound arguments to prevent security vulnerabilities.

JSON Serializers - Provides utilities to serialize complex Swift data structures into JSON strings for database storage.

Data Retrieval - Provides mechanisms to retrieve data as raw records, single values, arrays, or cursors.

Data Upsert Operations - Provides record upsert capabilities to insert new data or update existing records during conflicts.

Reactive SQLite Libraries - Includes a reactive observation framework that tracks database changes to trigger automatic UI updates.

Connection Pooling - Implements a connection pooling system to coordinate read and write operations across multiple threads.

Hybrid Relational-JSON Storage - Allows storing complex data structures as JSON strings within traditional relational database columns.

Encrypted Database Managers - Secures stored data using passphrase-based encryption for password-protected database files.

UI State Synchronization - Automatically synchronizes user interface elements with underlying database changes via event-driven observations.

Database Change Notifications - Triggers notifications upon data modification to keep the application state synchronized with storage.

Database Drivers - Versatile toolkit for SQLite.

Database Libraries - Versatile SQLite toolkit for Swift.

groueGRDB.swift

Features

Star history