256 questions
0
votes
1
answer
149
views
SwiftUI + Sqlite 3 (stephencelis) - how to create sqlite3 order statement in variable?
I use SQLite.swift library and have a question regarding the order method.
Related to the SQLite.swift sort syntax, I would like to put the sort order in a variable, as I need different sort ...
- 35
3
votes
2
answers
957
views
SQLite Expression - name space conflict with Xcode 16/iOS 18
When you will update Xcode 15 to Xcode 16, you will get many errors using SQLite.swift library.
For example: Missing argument label 'value:' in call etc, etc.
How to fix them?
- 167
0
votes
0
answers
125
views
"error: Unexpected null value for column" while it does contain a value
I created an SQLite database using fmdb and inserted data. I am now using sqlite.swift instead of fmdb. It crashes when I read a key of type blob which does have a value:
SQLite/Query.swift:1235: ...
0
votes
1
answer
85
views
SingleValueContainer error thrown during unit tests - retrieving records
I am a bit confused why I am getting this error thrown while trying to read from the database. In my test, I write the record successfully. Immediately after the write, I am trying to read the ...
- 1,044
0
votes
1
answer
180
views
How Can I enable FTS5 support in SQLite.swift using the Swift Package Manager
I have a project that is built using SPM and in it I use the SQLite.swift library (src). In my Package.swift file I have the following dependency:
let package = Package(
...
dependencies: [
....
- 30.5k
1
vote
3
answers
955
views
Flutter build on iOS fails while Android build is working fine
First, I'm building a Flutter app for Android and iOS. While building and running on Android is working fine the iOS build is failing since I added SQLite support.
flutter run --debug
Changing current ...
0
votes
2
answers
110
views
Determine number of rows returns from SQLite.swift raw query
I am using the SQLite.swift library and running raw queries.
I have the following
let results = try db!.prepare("""
SELECT class from "character" where character_id = ?
&...
- 3,089
1
vote
0
answers
112
views
Cannot Import SQLite for SQLite Swift Wrapper in Library Target
I read the similar question @ Cannot Import SQLite for SQLite Swift Wrapper but it wasn't quite my scenerio.
Xcode 14.3.1
I started a macOS Library project in Xcode. I added the SQLite.xcodeproj file ...
- 725
1
vote
0
answers
57
views
How to convert Sqlite.swift Binding to a primitive Swift type?
How can I get a primitive Swift type from a SQLite.swift Binding, I have this sample:
for row in try db.prepare("select * from table") {
let t = row[0]! as Int64
...
- 412
0
votes
0
answers
203
views
@import error while building sqlite.swift in Xcode
I am new to iOS development. I am working on developing an app which saves data into a sqlite.swift db and I have added the SQLite framework to the targets and linked the required libraries as per the ...
- 25
0
votes
0
answers
148
views
SwiftUI - Update Array of objects in parent view model (Binding Issue) - Code works until you switch Tabs
I need some help with this question please.
I am using SQLite.swift to store data in DB, I would like to fetch data only once when the application starts as it's a heavy operation. I need to be able ...
- 583
3
votes
0
answers
349
views
The operation couldn’t be completed. (SQLite.Result error 0.)
I am running into sporadic issues in production with SQLite.Swift where calls return the following SQLite.Result: "The operation couldn’t be completed. (SQLite.Result error 0.)".
A quick web ...
- 240
0
votes
2
answers
227
views
How to delete column in SQLite.swift
I am trying to do a SQLite.swift (v 0.12.2) migration which will delete column. But I can't found any method in documentation for that. I see only addColumn, but no any for deletion. How is it ...
- 2,293
1
vote
1
answer
364
views
Dynamic Filter in Sqlite.swift to check if a column is not null
I need some help in understanding the following problem.
I have the need for a dynamic filter (trying to not duplicate the queries for different scenarios).
I have already found that I can create a ...
- 188
1
vote
0
answers
445
views
Xcode Previews fail with: "missing required module 'SQLiteObjc'"
Although I can compile and run my project using SQLite.swift, I can't preview views that are in a local package.
An issue was recently fixed for Carthage installs:
https://github.com/stephencelis/...
- 5,363
