A third-party, type-safe, Swift-language layer over SQLite.
A third-party, type-safe, Swift-language layer over SQLite.
Questions tagged [sqlite.swift]
252 questions
0
votes
1 answer
Use NSArray in SQLite Statement
I use SQLite.swift and want to replace the question marks in a statement. This can be done for single entries like this:
let stmt = db.prepare("INSERT INTO users (email) VALUES (?)")
for email in ["betty@icloud.com", "cathy@icloud.com"] {
…
Michael
- 32,527
- 49
- 210
- 370
0
votes
1 answer
How To Retrive Data In Tableview or Textfield(autocomplete) from a sqlite DataBase file ( citylist.db ) in swift xcode
From past 2 days I am searching over the internet for the link between swift and sqlite but i am unable to get the code for it and for the database connection, as i want retrive the data from the citylist.db file into an auto complete textfield in…
Irshad Qureshi
- 807
- 18
- 41
0
votes
1 answer
SQLite API changes proximal to Xcode 6.3 release?
After updating to Xcode 6.3/Swift 1.2 I'm getting these errors. (.NoCase can't be found, and .insert doesn't accept (Setter, Setter).
Did something change in the SQLite swift API?
clearlight
- 12,255
- 11
- 57
- 75
0
votes
0 answers
Add "blocking" to Swift for-loop
I am using Swift in a project, and using SQLite.swift for database handling. I am trying to retrieve the most recent entry from my database like below:
func returnLatestEmailAddressFromEmailsTable() -> String{
let dbPath =…
Camillo
- 544
- 1
- 6
- 24
-1
votes
3 answers
How to handle the removal of database encryption in the next version of iOS application?
In iOS app version 1, I am storing each and every data in table in encrypted form. But In iOS app version 2, I have removed the encryption of those data in each and every table. During app upgrade from version 1 to version 2, since the older version…
Subi
- 141
- 1
- 1
- 9
-1
votes
1 answer
How to append to array in for loop?
How can I append my results in this array so I can use it later ?
var animalQuestion = [(orderlist: Int, questionid:String, question: String, description: String)]()
This is my array which I declared in my class above.
let stmt = try…
Ziyaad
- 67
- 8
-1
votes
2 answers
'Binding' is not convertible to UILabel using SQLite in Swift
My first time around here with a Swift related question with the SQLite.Swift library.
I have a for loop for a db.prepare statement, but I am stuck when trying to assign an array value to a UILabel.
// Prepare query to retrieve the message
var…
Alexof
- 21
- 6
-2
votes
1 answer
How to make a dynamic, calculated column? (Swift, SQLite)
How i can to make a dynamic, calculated column? Which is calculated using other columns and not stored in the database.
Which can be used for data output and sorting.
Library: stephencelis/SQLite.swift…
Артём Денисов
- 3
- 3
-2
votes
1 answer
Can I split one iOS app into two or more, but continue sharing the same sqlite database
I have a single Health tracking app which I believe has become too complicated. Complicated both in terms of code-base as well as UI.
I would like to split it into a standalone exercise app and a standalone health metrics (bp, blood glucose, etc)…
JohnGalt131
- 5
- 1
- 5
-3
votes
1 answer
Looking for sqlite.swift example project
Are there any good sqlite.swift example projects that I can work through to learn sqlite.swift? I'm knew to swift and looking for a good wrapper for database access and would like to find a good tutorial to help with some hands on learning.
thanks
lsg13
- 1
- 1
-3
votes
2 answers
How can I declare a variable nil until I need it?
Am just starting to use SQLite in Swift and am running into a declaration problem. I would like to wrap everything in one class that I can then call methods on.
My problem is I don't know how to declare db so that when I do call Connect, it can be…
LuisC329
- 131
- 8
-4
votes
1 answer
Xcode Can't connect to SQLITE Database
I am trying to connect to SQLITE DB hosted at "http://server/apr/mysqlite.db" using sqlite3_open() but failing to achieve the connection. I can see the database file via browser explorer.
I am able to setup connection with database available at my…
Partha Das
- 17
- 1
- 6