stephencelis/SQLite.swift

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.

Star history