Menu / packages / sqlite.swift

sqlite.swiftas of 0.16.0 · `964c300f`

https://github.com/stephencelis/sqlite.swift

What it serves, where

Capability	iOS	macOS	watchOS	tvOS	visionOS	Linux	Catalyst
Codable persistence	✓ serves it · confidence 0.90 · as of 0.16.0 `QueryType.insert` Sources/SQLite/Typed/Coding.swift:42 View the line on GitHub → `QueryType.insertMany` Sources/SQLite/Typed/Coding.swift:87 View the line on GitHub → `QueryType.upsert` Sources/SQLite/Typed/Coding.swift:123 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `QueryType.insert` Sources/SQLite/Typed/Coding.swift:42 View the line on GitHub → `QueryType.insertMany` Sources/SQLite/Typed/Coding.swift:87 View the line on GitHub → `QueryType.upsert` Sources/SQLite/Typed/Coding.swift:123 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `QueryType.insert` Sources/SQLite/Typed/Coding.swift:42 View the line on GitHub → `QueryType.insertMany` Sources/SQLite/Typed/Coding.swift:87 View the line on GitHub → `QueryType.upsert` Sources/SQLite/Typed/Coding.swift:123 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `QueryType.insert` Sources/SQLite/Typed/Coding.swift:42 View the line on GitHub → `QueryType.insertMany` Sources/SQLite/Typed/Coding.swift:87 View the line on GitHub → `QueryType.upsert` Sources/SQLite/Typed/Coding.swift:123 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `QueryType.insert` Sources/SQLite/Typed/Coding.swift:42 View the line on GitHub → `QueryType.insertMany` Sources/SQLite/Typed/Coding.swift:87 View the line on GitHub → `QueryType.upsert` Sources/SQLite/Typed/Coding.swift:123 View the line on GitHub →	✓ serves it · confidence 0.85 · as of 0.16.0 `QueryType.insert` Sources/SQLite/Typed/Coding.swift:42 View the line on GitHub → `QueryType.insertMany` Sources/SQLite/Typed/Coding.swift:87 View the line on GitHub → `QueryType.upsert` Sources/SQLite/Typed/Coding.swift:123 View the line on GitHub →	✓ serves it · confidence 0.85 · as of 0.16.0 `QueryType.insert` Sources/SQLite/Typed/Coding.swift:42 View the line on GitHub → `QueryType.insertMany` Sources/SQLite/Typed/Coding.swift:87 View the line on GitHub → `QueryType.upsert` Sources/SQLite/Typed/Coding.swift:123 View the line on GitHub →
Database encryption	? not verified yet · confidence 0.55 · as of 0.16.0 `Connection.key` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:66 View the line on GitHub → `Connection.rekey` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:102 View the line on GitHub → `Connection.sqlcipher_export` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:113 View the line on GitHub →	? not verified yet · confidence 0.55 · as of 0.16.0 `Connection.key` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:66 View the line on GitHub → `Connection.rekey` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:102 View the line on GitHub → `Connection.sqlcipher_export` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:113 View the line on GitHub →	? not verified yet · confidence 0.55 · as of 0.16.0 `Connection.key` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:66 View the line on GitHub → `Connection.rekey` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:102 View the line on GitHub → `Connection.sqlcipher_export` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:113 View the line on GitHub →	? not verified yet · confidence 0.55 · as of 0.16.0 `Connection.key` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:66 View the line on GitHub → `Connection.rekey` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:102 View the line on GitHub → `Connection.sqlcipher_export` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:113 View the line on GitHub →	? not verified yet · confidence 0.55 · as of 0.16.0 `Connection.key` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:66 View the line on GitHub → `Connection.rekey` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:102 View the line on GitHub → `Connection.sqlcipher_export` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:113 View the line on GitHub →	? not verified yet · confidence 0.30 · as of 0.16.0 `Connection.key` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:66 View the line on GitHub → `Connection.rekey` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:102 View the line on GitHub → `Connection.sqlcipher_export` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:113 View the line on GitHub →	? not verified yet · confidence 0.40 · as of 0.16.0 `Connection.key` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:66 View the line on GitHub → `Connection.rekey` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:102 View the line on GitHub → `Connection.sqlcipher_export` `#if SQLCipher` Sources/SQLite/Extensions/Cipher.swift:113 View the line on GitHub →
Full-text search	✓ serves it · confidence 0.80 · as of 0.16.0 `FTS5Config` Sources/SQLite/Extensions/FTS5.swift:35 View the line on GitHub → `FTS4Config` Sources/SQLite/Extensions/FTS4.swift:255 View the line on GitHub → `Module.FTS5` Sources/SQLite/Extensions/FTS5.swift:26 View the line on GitHub →	✓ serves it · confidence 0.80 · as of 0.16.0 `FTS5Config` Sources/SQLite/Extensions/FTS5.swift:35 View the line on GitHub → `FTS4Config` Sources/SQLite/Extensions/FTS4.swift:255 View the line on GitHub → `Module.FTS5` Sources/SQLite/Extensions/FTS5.swift:26 View the line on GitHub →	✓ serves it · confidence 0.80 · as of 0.16.0 `FTS5Config` Sources/SQLite/Extensions/FTS5.swift:35 View the line on GitHub → `FTS4Config` Sources/SQLite/Extensions/FTS4.swift:255 View the line on GitHub → `Module.FTS5` Sources/SQLite/Extensions/FTS5.swift:26 View the line on GitHub →	✓ serves it · confidence 0.80 · as of 0.16.0 `FTS5Config` Sources/SQLite/Extensions/FTS5.swift:35 View the line on GitHub → `FTS4Config` Sources/SQLite/Extensions/FTS4.swift:255 View the line on GitHub → `Module.FTS5` Sources/SQLite/Extensions/FTS5.swift:26 View the line on GitHub →	✓ serves it · confidence 0.80 · as of 0.16.0 `FTS5Config` Sources/SQLite/Extensions/FTS5.swift:35 View the line on GitHub → `FTS4Config` Sources/SQLite/Extensions/FTS4.swift:255 View the line on GitHub → `Module.FTS5` Sources/SQLite/Extensions/FTS5.swift:26 View the line on GitHub →	✓ serves it · confidence 0.70 · as of 0.16.0 `FTS5Config` Sources/SQLite/Extensions/FTS5.swift:35 View the line on GitHub → `FTS4Config` Sources/SQLite/Extensions/FTS4.swift:255 View the line on GitHub → `Module.FTS5` Sources/SQLite/Extensions/FTS5.swift:26 View the line on GitHub →	✓ serves it · confidence 0.75 · as of 0.16.0 `FTS5Config` Sources/SQLite/Extensions/FTS5.swift:35 View the line on GitHub → `FTS4Config` Sources/SQLite/Extensions/FTS4.swift:255 View the line on GitHub → `Module.FTS5` Sources/SQLite/Extensions/FTS5.swift:26 View the line on GitHub →
In-memory database	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection.Location.inMemory` Sources/SQLite/Core/Connection.swift:46 View the line on GitHub → `Connection.init` Sources/SQLite/Core/Connection.swift:106 View the line on GitHub → init(_ location: Location = .inMemory, readonly: Bool = false) throws — in-memory is the default location. Package.swift:39 View the line on GitHub → Package.swift declares a iOS platform floor.	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection.Location.inMemory` Sources/SQLite/Core/Connection.swift:46 View the line on GitHub → `Connection.init` Sources/SQLite/Core/Connection.swift:106 View the line on GitHub → init(_ location: Location = .inMemory, readonly: Bool = false) throws — in-memory is the default location. Package.swift:40 View the line on GitHub → Package.swift declares a macOS platform floor.	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection.Location.inMemory` Sources/SQLite/Core/Connection.swift:46 View the line on GitHub → `Connection.init` Sources/SQLite/Core/Connection.swift:106 View the line on GitHub → init(_ location: Location = .inMemory, readonly: Bool = false) throws — in-memory is the default location. Package.swift:41 View the line on GitHub → Package.swift declares a watchOS platform floor.	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection.Location.inMemory` Sources/SQLite/Core/Connection.swift:46 View the line on GitHub → `Connection.init` Sources/SQLite/Core/Connection.swift:106 View the line on GitHub → init(_ location: Location = .inMemory, readonly: Bool = false) throws — in-memory is the default location. Package.swift:42 View the line on GitHub → Package.swift declares a tvOS platform floor.	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection.Location.inMemory` Sources/SQLite/Core/Connection.swift:46 View the line on GitHub → `Connection.init` Sources/SQLite/Core/Connection.swift:106 View the line on GitHub → init(_ location: Location = .inMemory, readonly: Bool = false) throws — in-memory is the default location. Package.swift:43 View the line on GitHub → Package.swift declares a visionOS platform floor.	✓ serves it · confidence 0.85 · as of 0.16.0 `Connection.Location.inMemory` Sources/SQLite/Core/Connection.swift:46 View the line on GitHub → `Connection.init` Sources/SQLite/Core/Connection.swift:106 View the line on GitHub → init(_ location: Location = .inMemory, readonly: Bool = false) throws — in-memory is the default location. Package.swift:31 View the line on GitHub → Package.swift has an explicit #if os(Linux) branch enabling the SQLiteSwiftCSQLite default trait (bundled SQLite for Linux builds).	✓ serves it · confidence 0.85 · as of 0.16.0 `Connection.Location.inMemory` Sources/SQLite/Core/Connection.swift:46 View the line on GitHub → `Connection.init` Sources/SQLite/Core/Connection.swift:106 View the line on GitHub → init(_ location: Location = .inMemory, readonly: Bool = false) throws — in-memory is the default location. Package.swift:38 View the line on GitHub → Package.swift does not declare a macCatalyst floor, but all anchor symbols are unconditional (no platform gaps) in the extracted surface.
Schema migrations	✓ serves it · confidence 0.70 · as of 0.16.0 `Connection.userVersion` Sources/SQLite/Core/Connection+Pragmas.swift:8 View the line on GitHub → `SchemaChanger` Sources/SQLite/Schema/SchemaChanger.swift:29 View the line on GitHub → `SchemaChanger.alter` Sources/SQLite/Schema/SchemaChanger.swift:198 View the line on GitHub →	✓ serves it · confidence 0.70 · as of 0.16.0 `Connection.userVersion` Sources/SQLite/Core/Connection+Pragmas.swift:8 View the line on GitHub → `SchemaChanger` Sources/SQLite/Schema/SchemaChanger.swift:29 View the line on GitHub → `SchemaChanger.alter` Sources/SQLite/Schema/SchemaChanger.swift:198 View the line on GitHub →	✓ serves it · confidence 0.70 · as of 0.16.0 `Connection.userVersion` Sources/SQLite/Core/Connection+Pragmas.swift:8 View the line on GitHub → `SchemaChanger` Sources/SQLite/Schema/SchemaChanger.swift:29 View the line on GitHub → `SchemaChanger.alter` Sources/SQLite/Schema/SchemaChanger.swift:198 View the line on GitHub →	✓ serves it · confidence 0.70 · as of 0.16.0 `Connection.userVersion` Sources/SQLite/Core/Connection+Pragmas.swift:8 View the line on GitHub → `SchemaChanger` Sources/SQLite/Schema/SchemaChanger.swift:29 View the line on GitHub → `SchemaChanger.alter` Sources/SQLite/Schema/SchemaChanger.swift:198 View the line on GitHub →	✓ serves it · confidence 0.70 · as of 0.16.0 `Connection.userVersion` Sources/SQLite/Core/Connection+Pragmas.swift:8 View the line on GitHub → `SchemaChanger` Sources/SQLite/Schema/SchemaChanger.swift:29 View the line on GitHub → `SchemaChanger.alter` Sources/SQLite/Schema/SchemaChanger.swift:198 View the line on GitHub →	✓ serves it · confidence 0.65 · as of 0.16.0 `Connection.userVersion` Sources/SQLite/Core/Connection+Pragmas.swift:8 View the line on GitHub → `SchemaChanger` Sources/SQLite/Schema/SchemaChanger.swift:29 View the line on GitHub → `SchemaChanger.alter` Sources/SQLite/Schema/SchemaChanger.swift:198 View the line on GitHub →	✓ serves it · confidence 0.65 · as of 0.16.0 `Connection.userVersion` Sources/SQLite/Core/Connection+Pragmas.swift:8 View the line on GitHub → `SchemaChanger` Sources/SQLite/Schema/SchemaChanger.swift:29 View the line on GitHub → `SchemaChanger.alter` Sources/SQLite/Schema/SchemaChanger.swift:198 View the line on GitHub →
Type-safe queries	✓ serves it · confidence 0.90 · as of 0.16.0 `Table` Sources/SQLite/Typed/Query.swift:881 View the line on GitHub → `Expression` Sources/SQLite/Typed/Expression.swift:56 View the line on GitHub → `QueryType.filter` Sources/SQLite/Typed/Query.swift:314 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `Table` Sources/SQLite/Typed/Query.swift:881 View the line on GitHub → `Expression` Sources/SQLite/Typed/Expression.swift:56 View the line on GitHub → `QueryType.filter` Sources/SQLite/Typed/Query.swift:314 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `Table` Sources/SQLite/Typed/Query.swift:881 View the line on GitHub → `Expression` Sources/SQLite/Typed/Expression.swift:56 View the line on GitHub → `QueryType.filter` Sources/SQLite/Typed/Query.swift:314 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `Table` Sources/SQLite/Typed/Query.swift:881 View the line on GitHub → `Expression` Sources/SQLite/Typed/Expression.swift:56 View the line on GitHub → `QueryType.filter` Sources/SQLite/Typed/Query.swift:314 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `Table` Sources/SQLite/Typed/Query.swift:881 View the line on GitHub → `Expression` Sources/SQLite/Typed/Expression.swift:56 View the line on GitHub → `QueryType.filter` Sources/SQLite/Typed/Query.swift:314 View the line on GitHub →	✓ serves it · confidence 0.85 · as of 0.16.0 `Table` Sources/SQLite/Typed/Query.swift:881 View the line on GitHub → `Expression` Sources/SQLite/Typed/Expression.swift:56 View the line on GitHub → `QueryType.filter` Sources/SQLite/Typed/Query.swift:314 View the line on GitHub →	✓ serves it · confidence 0.85 · as of 0.16.0 `Table` Sources/SQLite/Typed/Query.swift:881 View the line on GitHub → `Expression` Sources/SQLite/Typed/Expression.swift:56 View the line on GitHub → `QueryType.filter` Sources/SQLite/Typed/Query.swift:314 View the line on GitHub →
SQLite access	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection` Sources/SQLite/Core/Connection.swift:38 View the line on GitHub → `Connection.prepare` Sources/SQLite/Core/Connection.swift:189 View the line on GitHub → `Connection.run` Sources/SQLite/Core/Connection.swift:233 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection` Sources/SQLite/Core/Connection.swift:38 View the line on GitHub → `Connection.prepare` Sources/SQLite/Core/Connection.swift:189 View the line on GitHub → `Connection.run` Sources/SQLite/Core/Connection.swift:233 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection` Sources/SQLite/Core/Connection.swift:38 View the line on GitHub → `Connection.prepare` Sources/SQLite/Core/Connection.swift:189 View the line on GitHub → `Connection.run` Sources/SQLite/Core/Connection.swift:233 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection` Sources/SQLite/Core/Connection.swift:38 View the line on GitHub → `Connection.prepare` Sources/SQLite/Core/Connection.swift:189 View the line on GitHub → `Connection.run` Sources/SQLite/Core/Connection.swift:233 View the line on GitHub →	✓ serves it · confidence 0.90 · as of 0.16.0 `Connection` Sources/SQLite/Core/Connection.swift:38 View the line on GitHub → `Connection.prepare` Sources/SQLite/Core/Connection.swift:189 View the line on GitHub → `Connection.run` Sources/SQLite/Core/Connection.swift:233 View the line on GitHub →	✓ serves it · confidence 0.85 · as of 0.16.0 `Connection` Sources/SQLite/Core/Connection.swift:38 View the line on GitHub → `Connection.prepare` Sources/SQLite/Core/Connection.swift:189 View the line on GitHub → `Connection.run` Sources/SQLite/Core/Connection.swift:233 View the line on GitHub →	✓ serves it · confidence 0.85 · as of 0.16.0 `Connection` Sources/SQLite/Core/Connection.swift:38 View the line on GitHub → `Connection.prepare` Sources/SQLite/Core/Connection.swift:189 View the line on GitHub → `Connection.run` Sources/SQLite/Core/Connection.swift:233 View the line on GitHub →

✓ serves it · ◐ with conditions · ✕ not served (proven) · ? not verified yet — hover any verdict for the receipt, click to pin it

Notes

Codable persistence: Coding.swift surfaces Encodable insert/insertMany/upsert/update and Decodable Row.decode; all unconditional.

Database encryption: Entire Cipher.swift surface is gated behind the SQLCipher package trait (#if SQLCipher); no platform resolves the symbols unconditionally present, so no platform can be marked supported. All-conditional confidence cap 0.6 respected.

Full-text search: FTS4/FTS5 Swift API is unconditional in the surface. Runtime availability of the FTS module depends on the linked SQLite build: the manifest's FTS5 trait is only supported with the bundled SQLiteSwiftCSQLite; system SQLite on Apple platforms ships FTS support per OS version.

In-memory database: Connection.Location.inMemory is an unconditional enum case and the default Connection location.

Schema migrations: Genuinely surfaced but modest in scope: user_version pragma helper (Connection.userVersion) plus SchemaChanger for ALTER-style schema changes. No versioned migration runner/registry; confidence reduced accordingly.

Type-safe queries: Typed query DSL (Table/Expression/QueryType) is the package's headline feature; all anchors unconditional in the surface.

SQLite access: Core SQLite wrapper (Connection/Statement) is unconditional across the extracted surface. Digest truncated at 800/968 decls and 1 ObjC file unparsed; anchors verified in the digest.

Badges for your README

Maintainer of sqlite.swift? These are yours — verified claims, linked to the receipts. Wrong verdict? That's a fix we want; see contribute.

sqlite.swiftas of 0.16.0 · 964c300f

What it serves, where

Notes

Badges for your README

sqlite.swiftas of 0.16.0 · `964c300f`