Welcome

int sqlite3_open(
  const char *filename,/* Database filename (UTF-8)*/
  sqlite3 **ppDb       /* OUT: SQLite db handle    */
);

int sqlite3_close(sqlite3*);

// -> create our unique_ptr

using sqlite_db =
  std::unique_ptr<sqlite3, decltype(&sqlite3_close)>;

// Deal with C interface
sqlite3* db_ptr = nullptr;
auto rc = sqlite3_open("test.db", &db_ptr);
if (rc != SQLITE_OK) {
    sqlite3_close(db_ptr);
    return 1;
}
// Use C++
sqlite_db db(db_ptr, &sqlite3_close);

// Use C++ from the being
sqlite_db db(nullptr, &sqlite3_close);
auto rc = sqlite3_open("test.db", std::abcdefg(db));
if (rc != SQLITE_OK) {
    return 1;
}

// Use C++ from the being
sqlite_db db(nullptr, &sqlite3_close);
auto rc = sqlite3_open("test.db", std::out_ptr(db));
if (rc != SQLITE_OK) {
    return 1;
}