SQLiteDemo

What is this

If you want to lower the persistence level, for any reason, you can easily use the C based library libsqlite3 in iOS.

But, if you want to use Swift instead of Objective-C, you may find some difficulties in importing the library or especially when dealing with the C pointers and structures inside Swift.

Below, you can see how "beautiful" is the translation of a simple function of this library:

func sqlite3_exec(_: COpaquePointer, 
                  sql: UnsafePointer<Int8>, 
                  callback: CFunctionPointer<((UnsafeMutablePointer<Void>, Int32, UnsafeMutablePointer<UnsafeMutablePointer<Int8>>, UnsafeMutablePointer<UnsafeMutablePointer<Int8>>) -> Int32)>, 
                  _: UnsafeMutablePointer<Void>, 
                  errmsg: UnsafeMutablePointer<UnsafeMutablePointer<Int8>>) -> Int32

This project is not a wrapper or something like that, it's only a very simple working example on how to effectively use the basic methods of libsqlite3, like how to:

• Create and remove a database;
• Create and remove tables;
• Insert, Update and Remove elements in a table;
• Select elements in a table;

Author

Lucas Eduardo, lucasecf@gmail.com