stephencelis/SQLite.swift
SQLite.swift
SQLite.swift is a type-safe Swift wrapper and object-relational mapping layer that provides a bridge for interacting with SQLite databases. It functions as a database driver that allows for embedded database management and local data persistence within Swift applications.
The project distinguishes itself through a type-safe expression builder that verifies SQL statement syntax and intent at compile time. It includes specialized support for high-performance text matching via full-text search integration and provides mechanisms for securing sensitive data through database encryption.
The library covers a broad range of capabilities including versioned schema migration, atomic transaction management, and a chainable query interface for filtering and pagination. It also supports advanced SQL constructs such as recursive queries, window functions, and the registration of custom SQL functions.
Additional operational controls include database journaling configuration for performance optimization and the retrieval of extended error codes for debugging.
Features
- SQLite Databases - Provides a serverless, transactional SQL database engine integrated directly within Swift applications.
- Type-Safe Query Builders - Provides a type-safe expression builder that verifies SQL statement syntax and intent at compile time.
- Type-Safe Schema Definitions - Enables the creation of tables and indexes using strongly typed column expressions and constraints.
- Data Type Mappings - Maps database values to high-level Swift types like UUIDs and URLs during data retrieval.
- Database Migrations - Facilitates updating the database structure to new versions without losing existing user data.
- Database Query Execution - Runs commands to create, insert, update, and delete records using expression builders or raw SQL.
- Database Schema Managers - Offers a declarative toolset for defining and versioning database structures using type-safe expressions.
- Fluent Query Builders - Implements a chainable, functional API for constructing complex SQL queries programmatically.
- Local Data Persistence - Enables saving application state and indexed data to local disk for persistence across restarts.
- Schema Migrations - Provides tools for managing and automating the evolution of the database structure over time.
- SQLite Drivers - Serves as a low-level Swift bridge for executing raw SQL and managing transactions.
- Type Mapping Converters - Provides utilities for translating between complex Swift objects and SQLite-compatible primitive values.
- Type-Safe Data Abstractions - Adds new records or updates existing ones upon conflict using type-safe setters.
- Type-Safe Object-Relational Mappers - Maps SQLite database rows and columns to Swift types at compile time for safe data access.
- C-API Wrappers - Provides a high-level Swift interface that encapsulates the low-level SQLite3 C library functions.
- SQLite Wrappers - Provides a type-safe Swift interface and expression builder to simplify interaction with SQLite.
- Database Column Bindings - Maps database result columns to Swift types using a protocol-based system for safe data retrieval.
- SQL Query Validators - Verifies SQL statement syntax and intent at compile time to prevent runtime database errors.
- Common Table Expressions - Supports building hierarchical data lookups using common table expressions with recursive clauses.
- Schema Versioning - Tracks and handles schema versions using internal pragmas to trigger conditional migrations.
- Database Connection Managers - Manages connections to disk-based, in-memory, or temporary databases with integrated thread-safety.
- Atomic Transactions - Groups multiple statements into atomic blocks that roll back changes if any operation fails.
- Full Text Search - Integrates SQLite virtual tables to implement high-performance text searching and indexing.
- Pagination - Provides chainable functions for selection, filtering, joining, sorting, and pagination of records.
- Raw SQL Execution - Enables running arbitrary SQL strings for complex operations that bypass the type-safe expression layer.
- Advanced SQL Construct Execution - Supports complex SQL constructs including window functions and common table expressions.
- Record Updating - Provides a fluent builder interface for modifying existing data rows with conditional filtering.
- SQL Aggregate Functions - Calculates scalar values such as counts, sums, and averages across filtered datasets.
- Encrypted Database Managers - Secures sensitive local data by encrypting database files with a key during the connection process.
- Serialized Access - Ensures thread-safe database access by routing all operations through a dedicated serial execution queue.
- Database Drivers - Simple and safe wrapper for SQLite3.
- Database Libraries - Type-safe Swift layer for SQLite3.
- Database Management - Type-safe wrapper for SQLite3.
