These are the eight methods and two objects that form the SQLite interface. These are the basic list of functions that each user/reader must be aware of when using SQLite in code. These statements don't change, nor does their functionality. These are the key statements to ensure that users are aware of the name, format, and where these functions are used:
sqlite3
: Database connection object, made bysqlite3_open()
, killed bysqlite3_close
()sqlite3_stmt
: Preparation statement object, made bysqlite3_prepare()
, killed bysqlite3_finalize()
sqlite3_open()
: Opens the database (new or existing) and uses constructorsqlite3
sqlite3_prepare()
: Compiles some SQL text into byte code to perform updating or querying tasks and is the constructor ofsqlite3_stmt
sqlite3_bind()
: Application data is stored into the parameters of the original SQLsqlite3_step()
: The further advancement ofsqlite3_stmt
onto the next row or completionsqlite3_column()
: The current row result outlining column...