- sqlite3_open()- Opens specified database file. If the database file does not already exist,it is created.
- sqlite3_close()- Closes a prevIoUsly opened database file.
- sqlite3_prepare_v2()- Prepares a sql statement ready for execution.
- sqlite3_step()- Executes a sql statement prevIoUsly prepared by the sqlite3_prepare_v2() function.
- sqlite3_column_<type>()- Returns a data field from the results of a sql retrieval operation where <type> is replaced by the data type of the data to be extracted (text,blob,bytes,int,int16 etc).
- sqlite3_finalize()- Deletes a prevIoUsly prepared sql statement from memory.
- 'sqlite3_exec()- Combines the functionality of sqlite3_prepare_v2(),sqlite3_step() and sqlite3_finalize() into a single function call.