FAQs

• How do I create a blank SQLite database?

  You can use something like the SQLite Manager extension for Firefox. Or, you can use any of the commonly available SQLite front end tools such as:

  • SQLite Database Browser
  • Base
  • SQLiteStudio
  • MesaSQLite
  • SQLiteManager

• Do you plan to add support for SQLite's bind API methods?

  No. Currently, there are no plans to add support for the bind methods since you can easily create an SQL statement with variables by simply creating a String with the appropriate variable values inserted where necessary. For example:

    let name = "John"  
    let sql = "SELECT * FROM clients WHERE name='\(name)'"  
  

• But what about strings with single quotes in them, like John's Name? How can you insert them via SQLiteDB without using the bind API calls?

  That's what the esc method in SQLiteDB is for :) That method returns a quoted and escaped string - so you don't have to even enclose the resulting string in quotes like in the above example. Here's an example:

    let db = SQLiteDB.sharedInstance()
    let name = db.esc("John's Name")
    let sql = "SELECT * FROM clients WHERE name=\(name)"
  

• Can you explain the Swift functionality/code that you've used in SQLiteDB?

  I released SQLiteDB so that it can be of use to others who are facing the same issues in interfacing with SQLite databases using Swift. But unfortunately, I do not have the time to explain Swift functionality to you. Please go through the relevant Apple documentation such as this.

• I'm using Xcode 6 beta 3 (or beta 2, or any beta which is older than the latest release) and my project will not compile with SQLiteDB. What's wrong?

  I usually update SQLiteDB to the latest Xcode beta version within a day or so of the new beta being released. So if you are on an older version of Xcode 6 beta, your code may not work until you upgrade to the latest version. Or, you can go through the commit notes to see which version supports your version of Xcode and use the code from that particular commit.

• Nothing's working after upgrading to the latest Xcode 6 beta! What do I do?

  Since Swift is still heavily under development by Apple, things will change and this can result in things breaking. I will be fixing SQLiteDB to comply with the latest Apple changes as soon as I can. So first check if I've actually pushed in some changes since the last time first :)

  If I haven't fixed the issues yet, please be patient. I'll fix them as soon as I can.